Microsoft® Excel 2016: Data Analysis With PowerPivot

Loading Courses

October 2019

Microsoft® Excel 2016: Data Analysis with PowerPivot

October 16 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map

Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models…

Find out more »

November 2019

Microsoft® Excel 2016: Data Analysis with PowerPivot

November 19 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map

Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models…

Find out more »

December 2019

Microsoft® Excel 2016: Data Analysis with PowerPivot

December 12 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map

Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models…

Find out more »
+ Export Events

Course Description:

This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models that permit the connection to multiple data tables invariably linked by way of a relational join. Pivot Tables, thus, can be much more robust as they can be derived from a variety of data source tables. In addition, there are very powerful calculations that can be created from functions categorized as Data Analysis Expressions, or DAX functions. The Excel power user can also create both calculated fields as well as summary calculations known as Measures. These Measures can also be expressed ironically in the form of KPI’s, or Key Performance Indicators, which essentially are graphics depicted by logical conditions.

Course Objectives:

  • Review of Pivot Table basics
  • Understanding Relational Databases
  • Creating a Data Model in Power Pivot
  • Developing Data Relationships
  • Creating Pivot Tables from the Power Pivot data model
  • Creating calculated fields
  • Creating summary calculations (measures)
  • Using DAX functions
  • Utilizing Key Performance Indicators (KPI’s)

Course Outline:

Getting Started with Power Pivot
Review of Pivot Tables
Data Normalization

Exploring a Relational Data Diagram
Developing a Data Model in Power Pivot
Creating Data Relationships
Creating a Pivot Table from the Data Model

Working with Calculations
Creating a Calculated Column
Creating a Summary Calculation Measure

Exploring Data Analysis Expressions
Creating a DAX function
Using DAX functions in Pivot Table reports

Working with Advanced Functionality in Power Pivot
Adding an Excel table to the Data Model
Work with Dates and Time in Power Pivot

Creating Key Performance Indicators (KPI’s)
Visualizing Measures
Exploring various KPI options


Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Course Information
  • Course ID:Intermediate
  • Course Level:Advanced
  • Prerequisite:Excel Intermediate or equivalent knowledge
  • Credit:PDUs/PDHs/PDCs: 7.5
  • Fee:$395
  • Length:1 day
  • Hours:8:30 a.m. - 4:15 p.m.
  • Delivery:Instructor Led Classroom

Related Courses