Digital SkillsProductivityPP-201 100% HRDF claimable

Microsoft Power Pivot

PowerPivot extends pivot tables with a data model, offering improved summarization, cross-tabulation, and advanced calculations. Power Query retrieves and cleans data; Power View creates interactive dashboards.

1 DayPEOPLElogy

What you'll learn

Create Power Pivot tables drawing from multiple data sources
Develop calculated metrics with consistent formatting
Assemble pivot tables, charts, and dimensions into dashboards
Apply DAX formula language to create measures and columns
Utilize DAX Advanced Time Intelligence for period comparisons and KPIs

Course modules (5)

01Introducing Power Pivot and the internal data model

02The pivotal Pivot Table

03Using external data with Power Pivot

04Adding formulas (calculated columns and measures)

05DAX Time Intelligence and KPIs