Data Modelling and Analysis with Excel Power Pivot

Excel PowerPivot easily analyses millions of rows of data, create relationships between tables & use DAX calculations

Join the 1% of Excel users who know how to use the most powerful features and tools in Microsoft Excel

I have been in the It industry since 1979, so I am not new to learning new technology along the way to keep up with it all. Ian Littlejohn's course that I completed is one of the best that have helped impress my colleagues and management at my workplace. Ian's precise and very engaging way of teaching has made my work effortless and an very effective. I use less time now to go through my weekly and monthly data analysis and presentation a breeze. Thanks again Ian. - Jeganathan Vettyvelu


Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis.

Power Pivot will improve your time to create reports, develop data analysis and gain insight into your your data by at least 80%.

  • Create relationships between tables of data without Vlookups
  • Create powerful Key Metric and Key Performance Indicator calculations
  • Manage and work with data models of millions of records of data
  • Create powerful new dashboards and reports

Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years.

Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data.

Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user.

Intended Audience: Excel, Professionals

Welcome to Analyze Data with Excel Power Pivot
Overview of Power Pivot Course
Activating Power Pivot in Excel
Download the Training Data File
Loading Data into PowerPivot
Browse, Filter and Sort PowerPivot Data
Home Menu Options
The AutoSum Function in Power Pivot
Design Menu Options
The Advanced Menu Option
PowerPivot Menu in Excel
Creating PivotTables
Changing the Method of Calculation
Pivot Table Calculations
PivotTable Filters and Slicers
Filtering PivotTables and PivotCharts
Creating Hierarchies
Download the Training Data Files
Create Relationships to Master Data
Create PivotTables with Table Relationships
Download the Training Data
Create Calculated Columns in DAX
Date Functions in PowerPivot
Using the Sort By Option
Download the Date Master File
Create a Date Table
Text and Logical Calculated Fields
Download the Price Increase Excel file
Creating Related Calculated Formulas
Review of Calculated Fields
Power Pivot Calculated Fields
The Calculate Formula
Date Measure Examples
Download the KPI Workbook
Creating Named Sets
Creating KPIs

What's included

  • 28 Video Lessons
  • 9 Text Lessons

  • Works on all devices
  • Certificate of completion

Ian Littlejohn