Accept cookies to show this video. Cookies Policy
Allow all cookies

Power Pivot Workshop – Video Course

Learn to master Power Pivot for Excel from your chair with our high quality video course.

This video course is divided in three parts: the first one (Beginner) introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Beginner section is completely available in the free trial, you are just one click away to start.

The second part of the course (Intermediate) improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions.

The last part (Advanced) enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot.

Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course.

The course includes almost 10 hours of video in 73 lectures.

Collapse allCurriculum

  • Introduction to Self-Service Business Intelligence

    • Introduction to Self-Service Business Intelligence
      FREE
    • Self-Service BI
      FREE
    • Power Pivot
      FREE
    • Power Query
      FREE
    • Power View
      FREE
    • Power Map
      FREE

  • Introduction to Power Pivot

    • Introduction to Power Pivot
      FREE
    • PivotTables in Excel
      FREE
    • PivotTables in Excel 2013
      FREE
    • Using Power Pivot
      FREE
    • Calculated Columns
      FREE
    • Linked Tables
      FREE
    • Calculated Fields
      FREE
    • Publishing to Power BI
      FREE

  • Loading Data

    • Loading Data
      FREE
    • Loading Data in Power Pivot
      FREE
    • Loading from SQL Tables
      FREE
    • Loading from SQL Queries
      FREE
    • Loading from Access
      FREE
    • Loading from Analysis Services
      FREE
    • Using Linked Tables
      FREE
    • Loading from Excel
      FREE
    • Loading from Text Files
      FREE
    • Loading from the Clipboard
      FREE
    • Loading from Reports
      FREE
    • Loading from Data Feeds
      FREE
    • Loading from Azure Marketplace
      FREE
    • Loading from SharePoint
      FREE
    • Data Connection Properties
      FREE

  • Data Modeling

    • Data Modeling
      FREE
    • Introduction to Data Models
      FREE
    • Normalization and Denormalization
      FREE
    • Star Schemas
      FREE
    • Over Denormalization
      FREE

  • DAX Language

    • DAX Language
      FREE
    • Introduction to DAX
      FREE
    • Calculated Columns and Calculated Fields
    • DAX Error Handling
    • Overview of DAX Functions

  • Table Functions and CALCULATE

    • Table Functions and CALCULATE
      FREE
    • RELATED and RELATEDTABLE functions
    • FILTER and ALL functions
    • CALCULATE function
    • Visual Totals and ALLSELECTED

  • Basic Time Intelligence

    • Basic Time Intelligence
      FREE
    • What is Time Intelligence
    • Calendar Table
    • Counting Working Days
    • Multiple Calendar Tables
    • Aggregations Over Time

  • Power BI and SharePoint

    • Power BI and SharePoint
      FREE
    • ​Power BI and SharePoint​ Introduction
    • Using Power Query​
    • Using Power View​
    • Using Power Map​
    • Publishing on Office 365​
    • Publishing on SharePoint​

  • Creating Reports and KPI

    • Creating Reports and KPI
      FREE
    • Using KPI in Power Pivot
      FREE
    • Advanced Excel Features for Power Pivot
    • Optimizing the User Experience with the Data Model

  • Advanced DAX Concepts

    • Advanced DAX Concepts
      FREE
    • Important DAX Concepts​
    • Filter Context​
    • CALCULATE​
    • Row Context​
    • Evaluation Contexts and Relationships​
    • Context Transition​
    • ALLSELECTED​

  • Advanced DAX Functions

    • Advanced DAX Functions
      FREE
    • ​Advanced DAX Functions and Patterns​
    • RANKX​
    • KEEPFILTERS​
    • Semi Additive Measures​
    • Event in Progress​
    • Calculations Over Weeks​

  • DAX as a Query Language

    • DAX as a Query Language
      FREE
    • ​Basic DAX Query Functions​
    • Linked-Back Tables in Excel​
    • Advanced DAX Query Functions​

  • DAX Patterns

    • DAX Patterns
      FREE
    • DAX Patterns Introduction​
    • Banding​
    • ABC / Pareto Analysis​
    • Parent-Child Hierarchies​
    • Compare Budget and Sales​

  • Additional Material and Sample Files​​

    • Download Sample Files
      FREE
Student Rating
4.4
16 ratings
56%
38%
0%
0%
6%
4-star Reviews (3 of 10)
  • Morris Muthubi (Apr 14, 2020)

    This was a well-outlined class. I look forward to finishing the definitive guide. I love Marco's teaching style and I look forward to more interaction. Worth the money and time

  • Kenneth Barber (Dec 4, 2019)

    This course has aged surprisingly well. However, some parts of this course are no longer relevant. SQLBI's Mastering DAX course largely supersedes this course, and I would recommend that most people take Mastering DAX instead.

  • Marshall Joubert (Jun 17, 2019)

    Despite covering a previous version of Excel, the material was still relevant.