Ultimate Excel Course #13 - Introduction to the Data Model and PowerPivot

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Lessons (45m)
    • 1. What is the Data Model and PowerPivot?

    • 2. Adding Tables to the Data Model and Creating Relationships between Tables

    • 3. Creating a PivotTable from the Data Model

    • 4. Enabling the PowerPivot Add-In

    • 5. Exploring the PowerPivot Window

    • 6. Introduction to DAX - Calculated Columns

    • 7. Introduction to DAX - Measures


About This Class


This class is #13 in a series called the Ultimate Excel Course.

In this class you will be introduced to the Data Model and PowerPivot in Excel. This is an extremely powerful area of modern Excel.

This class is for people who work with large volumes of data and need to perform powerful analysis.

This is a huge area of Excel so this class serves as an introduction and insight into this feature. It will enable you to understand what it is and how it may benefit you.

In the class we import some data from a csv file into the data model using Power Query. This file contains over 100,000 rows of data. We then create relationships from it to 3 other tables.

Then we create a PivotTable from multiple tables of data in the model. Next we look at enabling the PowerPivot add-in and demonstrate some basic examples of DAX formulas. 

The Excel files used during the class are provided so that you can follow along. You can then take on the project exercises to test your skills in action.

Please post any questions in the discussion area and I will get back to you.

Grab a coffee, enrol and let's do this.

Please note that this is class #13 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions - The Decision Making Formulas of Excel

Class #4 - Conditional Formatting: Make your Data Come to Life

Class #5 - Lookup Functions - The Powerful VLOOKUP Function and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your Data Ranges as Tables for Superior Management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot