The Intermediate course 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 course includes 3 hours of video in 19 lectures. You need a minimal experience of Power Pivot, or you should take the Beginner course before this one.
After this course, we suggest you to take the Power Pivot Workshop Advanced.
- DAX Language
- DAX Language
- Introduction to DAX
- Calculated Columns and Calculated Fields
- DAX Error Handling
- Overview of DAX Functions
- Table Functions and CALCULATE
- RELATED and RELATEDTABLE functions
- FILTER and ALL functions
- CALCULATE function
- Visual Totals and ALLSELECTED
- Basic Time Intelligence
- What is Time Intelligence
- Calendar Table
- Counting Working Days
- Multiple Calendar Tables
- Aggregations Over Time
- Power BI and SharePoint
- Power BI and SharePoint Introduction
- Using Power Query
- Using Power View
- Using Power Map
- Publishing on Office 365
- Publishing on SharePoint
- Download Sample Files
This video course is hosted by SQLBI on Vimeo platform, and it will be accessible by 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.