• Module1: MS Power Pivot

    MS Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. In this session we are going to:

    • create a  Linked tables Data model,
    • create a Relationship between tables,
    • use DAX (Data Analysis Expressions), Implicit and Explicit Measures,
    • use KPI (Key Performance Indicators) visually inside our Pivot table.


    • MS Power Pivot Activity 1

    • MS Power Pivot Activity 2

    • Certificate only available below on completion of ALL Videos and Knowledge Checkpoints in this Module.