Power Pivot Workshop Intermediate – Video Course


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.


Course Curriculum
  1. DAX Language
    •   DAX Language
    •   Introduction to DAX
    •   Calculated Columns and Calculated Fields
    •   DAX Error Handling
    •   Overview of DAX Functions

  2. Table Functions and CALCULATE
    •   Table Functions and CALCULATE
    •   RELATED and RELATEDTABLE functions
    •   FILTER and ALL functions
    •   CALCULATE function
    •   Visual Totals and ALLSELECTED
  3. Basic Time Intelligence
    •   Basic Time Intelligence
    •   What is Time Intelligence
    •   Calendar Table
    •   Counting Working Days
    •   Multiple Calendar Tables
    •   Aggregations Over Time
  4. Power BI and SharePoint
    •   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​
  5. Additional Material and Sample Files
    •   Download Sample Files


Course access

  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.


Buying options

3 hours video

$70
$55

Take it
or
3 hours video

FREE

Find more
3 hours video

$70
$55

 
4 hours video

$70
$55

Find more
3 video courses

+ 10% OFF
$140
$99

Take it