This course teaches you how to clean, model, and analyze data using Power Query, Power Pivot, and DAX in Excel. Through practical, hands-on lessons, you’ll learn to import data from multiple sources, transform messy datasets, build scalable data models, and perform advanced calculations. By the end, you’ll be able to create dynamic reports, work efficiently with complex data, and apply real-world analytical skills, plus earn a certificate to showcase your expertise.
Course curriculum
Requirements
Basic Excel skills (formulas, tables)
Analytical mindset and willingness to learn
Laptop/PC with Excel installed
Outcomes
Understand the basics of PivotTables, Power Query, and Power Pivot
Import data from multiple sources into Excel
Clean, transform, and standardize data using Power Query
Build data models using relationships in Power Pivot
Write basic DAX formulas for calculations
Create reports using multiple tables and a connected data model




