PowerPivot for Excel

Request more details:

Description:
You can use PowerPivot (and the built-in DAX language) to create and analyse pivot tables based on multiple datasets, removing the need to work with Analysis Services or other complicated software applications.
Prerequisites:
To ensure your success, we recommend you first take at least our Excel Intermediate course, but ideally Advanced or have equivalent knowledge.
Getting started:
What PowerPivot is
Installing PowerPivot
The PowerPivot ribbon
Connecting to tables:
Connecting to SQL Server
Filtering rows and columns
Changing a table after import
Creating a data model:
Hiding columns and tables
Renaming columns and tables
Relationships:
Diagram view
Auto-detection
Manually creating
Pivot tables:
Creating pivot tables
Sorting pivot tables
Formatting pivot tables
Slicers
Connecting to Excel:
Creating Excel tables
Linking to Excel tables
Connecting to other data:
Linking to Access
Pasting tables
Linking to SSRS reports
Calculated columns:
Creating aggregator columns
IF and SWITCH
Using the BLANK function
Using RELATED to link tables
Measures:
Measures vs. calculated columns
Creating aggregation measures
Problems with ratios
X suffix functions (eg SUMX)
FILTER and CALCULATE:
The FILTER function
The CALCULATE function
ALL and ALLEXCEPT
Using the EARLIER function
Creating a calendar:
Why use a calendar table?
Creating in Excel
Creating in SQL
Multiple date tables
Date calculations:
Working days
Period to date
Prior and parallel years
Semi-additive measures
Hierarchies:
Creating a hierarchy
Using in pivot tables
Key Performance Indicators:
Three parts of a KPI
Creating the measures needed
Creating a KPI
KPIs with absolute targets