This course is ideal for participants seeking to master self-service BI using Excel’s Power Pivot and DAX capabilities. It focuses on building robust data models and writing efficient DAX formulas for business analytics. Participants will work through scenario-based exercises to improve reporting accuracy and performance.
Learning Outcomes:
Create relational data models using Power Pivot
Write calculated columns and measures using DAX
Use DAX functions for time intelligence and filters
Analyse data trends and metrics through PivotTables
Key Topics:
Power Pivot architecture and model building
Introduction to DAX syntax and context
Time intelligence and CALCULATE functions
Relationships and hierarchies in data models
Module 1: Power Pivot Overview
• Pivot Table Vs Power Pivot
• Create a Power Pivot Data Model in Excel
• Manage Data Relationships
Module 2: Power Pivot Calculation
• Calculated columns
• Measures
• Key Performance Indicators (KPI) in Power Pivot
Module 3: DAX Functions
• Understanding DAX
• Lookups in Power Pivot Formula
• RELATED Functions
• RELATEDTABLE Functions
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
