Course Overview Print

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

Course Outline

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

*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).
Mastering Excel's Power Pivot and Data Analysis Expression (DAX)
Fees Enquire Now

Have Question?

We’re here to help — reach out anytime.

By submitting this form, you consent to be contacted via email and/or your mobile number regarding your enquiry. You consent to the collection, use, disclosure and processing of your personal data in accordance with our Personal Data Policy.