Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Improve your skills while working at home
Online Training options available for all of our courses
Live-Instructor - Online Group Training - On-Demand


Excel BI Tools: PowerPivot and Interactive Visualizations Training Course

Excel BI Tools: PowerPivot and Interactive Visualizations Training Course


Course Description:  The Excel BI Tools: PowerPivot and Interactive Visualizations course will train students on how to use tools included in Excel 2016 to perform professional level data analysis. Students will learn to work with Power Pivot to extend the functionality of their Pivot Tables, Power Query to retrieve and prepare data, Power View to create interactive dashboards, and Power Map to perform data visualizations.

Upon completion of the course, users will be able to:

  • Understanding Power Pivot and the Power BI Tools
  • Working with Data
  • Importing Data into Power Pivot
  • Creating the Data Model
  • Using Calculations in Power Pivot
  • Using Data Analysis Expressions
  • Working with DAX Formulas
  • Data Analysis with Pivot Tables and Pivot Charts
  • Working with Power View
  • Building Interactive Reports with Power View
  • Loading and Transforming Data with Power Query
  • Visualizing Data with Power Map

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 9/21/2020 - 9/23/2020
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 10/19/2020 - 10/21/2020
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 11/16/2020 - 11/18/2020
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 12/21/2020 - 12/23/2020
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 1/18/2021 - 1/20/2021
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 2/15/2021 - 2/17/2021
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 3/15/2021 - 3/17/2021
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 4/12/2021 - 4/14/2021
Course Fee : $1495


Excel BI Tools: PowerPivot and Interactive Visualizations
Locations: Available Nationwide and Online
Class Date(s): 5/3/2021 - 5/5/2021
Course Fee : $1495


Course Syllabus

Section 1 – Understanding Power Pivot and the Power BI Tools
• What is Power Pivot, Power Query, Power View and Power Map
• Why use the Power BI Tools
• Excel versus Power Pivot
• Pivot Table Examples with Excel Data
• Power Pivot Examples with a Data Model
• Power View and Power Map Examples

Section 2 – Working with Data
• Work with an Excel List
• Use Vlookup to add Helper Columns
• Work with an Excel Table
• Cleaning up Tables
• Working with Normalized Tables

Section 3 – Importing Data into Power Pivot
• Understanding Acceptable Data Types
• Add Excel Tables to Power Pivot
• Import Access Tables
• Save the File
• Add and Maintain Data in Power Pivot

Section 4 – Creating the Data Model
• What is a Data Model
• Understanding Key Fields
• Create Relationships between Tables in the Model
• Manage Relationships
• Creating and Using Linked Tables
• Creating and Using Hierarchies

Section 5 – Using Calculations in Power Pivot
• Types of Calculations in Power Pivot
• Create a Calculated Column
• Create a Calculated Field (Measures)
• Implicit Calculated Field
• Explicit Calculated Field
• Understanding DAX Measure Rules and Best Practices
• Choosing Between Calculated Columns and Measures
• Create a Key Performance Indicator (KPI)

Section 6 - Using Data Analysis Expressions
• Understanding Data Analysis Expressions (DAX) Formulas
• Where to use DAX formulas
• Understanding the DAX syntax
• How to create DAX formulas
• Types of operations you can perform with DAX

Section 7 – Working with DAX Formulas
• Working with Filter Function
• Working with Time Intelligence Functions
• Using Multiple Functions is a Formula
• Using Multiple Data Tables

Section 8 – Data Analysis with Pivot Tables and Pivot Charts
• Creating Pivot Tables
• Filtering Data using Slicers
• Add Visualizations to a Pivot Table
• Creating Pivot Charts
• Formatting Pivot Charts
• Using Multiple Charts and Tables

Section 9 – Working with Power View
• Visualizing Data with Power View
• Creating a Basic Report
• Making Improvements with Power View
• Creating Tables and Matrices
• Building Bar, Column and Pie Charts
• Constructing Line and Scatter Charts
• Producing Map-Based Visualizations

Section 10 – Building Interactive Reports with Power View
• Linking Visualizations in Power View
• Using tiles to Organize the Data
• Filtering Groups and Views
• Exposing the Dashboard

Section 11 – Loading and Transforming Data with Power Query
• Importing Data
• Transforming, cleansing and Filtering Data
• Merging and Shaping Data
• Grouping and Aggregating Data
• Inserting Calculated Columns

Section 12 – Visualizing Data with Power Map
• Preparing the Data for Mapping
• Create a Map-Based Graph
• Create Heat and Region Maps
• Adding Multiple Layers to a Map
• Analyze Changes over Time
• Creating a Tour

Excel Analytics On-Site Group Training
Arrange a private Excel Analytics training class for your team with one of our Certified Instructors. Private instruction for your team members at a lower per-student price than attending the public courses. Learn More or complete the quote request form below.



Data Analysis On-Demand Training

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Business Computer Skills BBB Profile