Data Analysis using PowerPivot

Our classes are always live and instructor led from our Exton, PA or EPIC Partner locations. Springhouse AnywhereLive options require Internet Access. Select classes are Guaranteed to Run (GTR). View our complete schedule policies.






​You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Intended Audience

​This course is for students with a sound working knowledge of Microsoft Excel 2016 and general computing proficiency, including those who will be using Excel to make business decisions.

At Completion

Upon successful completion of this course, students will be able to:

  • Become familiar with the PowerPivot application and import data.
  • Become familiar with the Power Query Add-In feature in Excel.
  • Manipulate data in a PowerPivot worksheet.
  • Create reports using PowerPivot data.
  • Use basic DAX functions in PowerPivot.


​To ensure your success, we recommend you are familiar with creating Excel functions and are comfortable using and creating Excel Pivot Tables. Currently, these topics can be found in our Microsoft Excel 2016 Level 2 and Microsoft Excel 2016 Level 3 classes.

Exams & Certifications


Course Outline

Unit 1 - Getting Started with PowerPivot.

  • Lesson 1.1 - Enable and Navigate
  • Lesson 1.2 - Import Data from Various Data Sources


Unit 2 - Manipulating PowerPivot Data

  • Lesson 2.1 - Database Concepts
  • Lesson 2.2 - Organize and Format Tables
  • Lesson 2.3 - Creating Calculated Columns


Unit 3 - Power Query

  • Lesson 3.1 - Enable Power Query
  • Lesson 3.2 - Setting up Data Models
  • Lesson 3.3 - Extract, Transform, Load


Unit 4 - Creating PowerPivot Reports

  • Lesson 4.1 - Create PivotTables
  • Lesson 4.2 - Create PivotCharts
  • Lesson 4.3 - Using Hierarchies
  • Lesson 4.4 - Filter Data Using Slicers
  • Lesson 4.5 - Protect Reports


Unit 5 - Using DAX Functions in PowerPivot

  • Lesson 5.1 - Measures vs. Calculated Columns
  • Lesson 5.2 - Using DAX Measures
  • Lesson 5.3 - Extract Data from Tables Using Measures
  • Lesson 5.4 - Using DAX Filters
  • Lesson 5.5 - Working with Time Dependent Data



Data Analysis using PowerPivot EXC 2010 PPData Analysis using PowerPivot

Get More Information




Help us prove you're not a robot:

 ‭(Hidden)‬ Catalog-Item Reuse

Microsoft Gold Partner


AXELOS Limited

The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited.
IT Infrastructure Library® is a registered trade mark of AXELOS Limited
The Swirl logo™ is a registered trade mark of AXELOS Limited
Accredited course material is property of ITSM Academy.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 -