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.

Course Curriculum
  1. 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
  2. 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
  3. 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
  4. Data Modeling
    •   Data Modeling FREE
    •   Introduction to Data Models FREE
    •   Normalization and Denormalization FREE
    •   Star Schemas FREE
    •   Over Denormalization FREE
  5. DAX Language
    •   DAX Language FREE
    •   Introduction to DAX FREE
    •   Calculated Columns and Calculated Fields
    •   DAX Error Handling
    •   Overview of DAX Functions

  6. Table Functions and CALCULATE
    •   Table Functions and CALCULATE FREE
    •   RELATED and RELATEDTABLE functions
    •   FILTER and ALL functions
    •   CALCULATE function
    •   Visual Totals and ALLSELECTED
  7. Basic Time Intelligence
    •   Basic Time Intelligence FREE
    •   What is Time Intelligence
    •   Calendar Table
    •   Counting Working Days
    •   Multiple Calendar Tables
    •   Aggregations Over Time
  8. 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​
  9. 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
  10. Advanced DAX Concepts
    •   Advanced DAX Concepts FREE
    •   Important DAX Concepts​
    •   Filter Context​
    •   CALCULATE​
    •   Row Context​
    •   Evaluation Contexts and Relationships​
    •   Context Transition​
  11. Advanced DAX Functions
    •   Advanced DAX Functions FREE
    •   ​Advanced DAX Functions and Patterns​
    •   RANKX​
    •   Semi Additive Measures​
    •   Event in Progress​
    •   Calculations Over Weeks​
  12. DAX as a Query Language
    •   DAX as a Query Language FREE
    •   ​Basic DAX Query Functions​
    •   Linked-Back Tables in Excel​
    •   Advanced DAX Query Functions​
  13. DAX Patterns
    •   DAX Patterns FREE
    •   DAX Patterns Introduction​
    •   Banding​
    •   ABC / Pareto Analysis​
    •   Parent-Child Hierarchies​
    •   Compare Budget and Sales​
  14. Additional Material and Sample Files​​
    •   Download Sample Files FREE

Course access

  This video course is hosted by SQLBI on Vimeo platform, and it will be accessible on desktop and mobile browsers for three years (36 months) after the purchase date.
After registering to the course, you will receive an email containing the credentials to access the training. Please note that these credentials are intended as personal and you should not share them with other people.