Microsoft® Excel: Data Analysis With PowerPivot

Click Here For More Information

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 Level:Advanced
  • Prerequisite:Excel Intermediate or equivalent knowledge
  • Credit:PDUs/PDHs/PDCs: 7.5
  • Fee:$395
  • Length:1 day
  • Hours:Varies
  • Delivery:Virtual Instructor-Led or Onsite
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelAdvanced
  • Advanced PreparationDownload and install class files a minimum of 3 working days prior to class.
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses