Microsoft Excel: Power Pivot & Power View | AKTINA IT

Microsoft Excel: Power Pivot & Power View

  • Course Overview
  • Course Outline
  • Course Arrangements
Introduction: 
Power Pivot and Power View's integration into Excel brings a whole new level of scalability and functionality. With the inclusion of PowerPivot and Power View, Microsoft Excel 2013 becomes a first-class business intelligence (BI) tool that's capable of storing, processing and visualizing vast amounts of data.
Audience: 
Existing Excel users and IT Pros providing Excel support
Prerequisites: 
Acquaintance with basic features and functionality of Microsoft Excel
  • Introduction
  • PivotTable functionality
  • Installing PowerPivot
  • Supported Data Sources
  • Getting Data into PowerPivot
  • Creating Linking Data
  • Copying and Pasting Data from Excel
  • Importing Data from
    • Excel
    • SQL Server
    • a Text File
    • Other Sources
  • Data Cleaning
  • Creating and Managing Relationships
    • Auto Detecting Relationships
    • Defining a Relationship Manually
    • Calculation between Tables
    • Defining a Difficult Relationship
    • Concatenated Key Relationship
  • Data Sheet View
  • PowerPivot Window view
  • Applying Numeric Formatting
  • Data Sorting in the PowerPivot Window
  • Data Filtering in the PowerPivot Window
  • Rearranging Columns
  • Show/Hiding Columns at Two Levels
  • Undo and Redo in PowerPivot
  • Deleting Columns
  • Using the Context Menu
    • PowerPivot DAX Functions & Measures
      • Operators in the DAX Language
      • Adding a new column Using DAX Formula
      • Working with DAX Measures
      • DAX Function Reference
      • Grabbing Values from a Related table
      • Building Formulas in the PowerPivot Grid
    • Building Pivot Reports using PowerPivot
      • Elements of a Pivot Report
      • Arranging Field Headings to Build a Report
      • Using the PowerPivot Field List to Create Reports
      • Building a Pivot Report Building a Report with Two Pivot Charts
      • Building a Report with multiple views
      • Adding Slicers and Understanding Slicer Auto Layouts
      • Adding a Pivot Chart to an Existing Layout
      • Adding a Pivot Table to an existing layout
  • Power View
    • What is Power View
    • Power view Basic
    • Using the Filters Pane
    • Decorating you reports
    • Understanding table, Matrix, and cards
    • Using the Matrix Visualization
    • Using the Card Visualization
    • Using a Table as slicer
    • Using Chart
    • Using the line Chart
    • Using the pie Chart
    • Using the scatter Chart
    • Using Maps
    • Understanding Drill Down
    • Using Titles
    • Understanding multipliers
    • Using Power view Effectively
Dates and Times: 
Nov 21 - Dec 5
Duration (Hours): 
6
City: 
Lefkosia

Newsletter Subscription

Subscribe with your email address to stay up to date.

Find a Course

Go to top