Excel PowerPivot is a course for advanced Excel users who want to use Microsoft Power Pivot to perform enterprise-scale data analysis directly within Excel. Students learn to import data from multiple sources into the PowerPivot data model, define table relationships, write DAX (Data Analysis Expressions) formulas to create calculated columns and measures, and use the Power Pivot data model as the basis for powerful PivotTable reports.
What You Will Learn
- Import data from multiple sources into the Excel Power Pivot data model
- Create relationships between tables in the Power Pivot diagram view
- Write DAX calculated columns and measures for custom aggregations and KPIs
- Use Power Pivot-based PivotTables to analyse data from multiple related tables
- Build KPIs, hierarchies, and perspectives in the Power Pivot data model
Who Should Attend
Advanced Excel users, financial analysts, and business intelligence professionals who want to move beyond standard PivotTables to multi-table data modelling within Excel.
Prerequisites
Advanced Excel experience including PivotTables and Excel formulas. Completion of Excel – Part Three or equivalent is recommended.
