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.





7ab7cd16-c847-e711-98e2-00155d0a14062017-12-20T10:00:00Z375.000000000000019:00 AM4:00 PMExton7ab7cd16-c847-e711-98e2-00155d0a1406
7bb7cd16-c847-e711-98e2-00155d0a14062018-02-09T10:00:00Z375.000000000000019:00 AM4:00 PMExton7bb7cd16-c847-e711-98e2-00155d0a1406
c5c454c8-29ce-e711-8b1b-00155d0a14062018-04-06T08:00:00Z375.000000000000019:00 AM4:00 PMExtonc5c454c8-29ce-e711-8b1b-00155d0a1406
c6c454c8-29ce-e711-8b1b-00155d0a14062018-05-25T08:00:00Z375.000000000000019:00 AM4:00 PMExtonc6c454c8-29ce-e711-8b1b-00155d0a1406
c7c454c8-29ce-e711-8b1b-00155d0a14062018-07-13T08:00:00Z375.000000000000019:00 AM4:00 PMExtonc7c454c8-29ce-e711-8b1b-00155d0a1406
c8c454c8-29ce-e711-8b1b-00155d0a14062018-08-31T08:00:00Z375.000000000000019:00 AM4:00 PMExtonc8c454c8-29ce-e711-8b1b-00155d0a1406


​​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 2010 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.
  • Manipulate data in a PowerPivot worksheet.
  • Create reports using PowerPivot data.
  • Use DAX functions in PowerPivot.
  • Distribute PowerPivot Data.


​To ensure your success, we recommend you first take one of the following Element K courses or have equivalent knowledge: Microsoft® Excel® 2010: Level 1, Microsoft® Excel® 2010: Level 2, and Microsoft® Excel® 2010: Level 3.

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 -