Intermediate
Advanced Excel: Power Query, Power Pivot, DAX
Automatically cleaning large, messy data sources with Power Query, and advanced data modeling with Power Pivot and DAX.
Request This TrainingWho It's For
corporate teams It's suitable for
Prerequisites
- The "Data Analysis with Excel" course or equivalent experience
Learning Outcomes
- Building an automated data cleaning workflow with Power Query
- Creating a multi-table data model with Power Pivot
- Writing calculated fields and measures with DAX
- Creating report templates that update periodically
Program
1
Data Preparation with Power Query
- Importing data from multiple sources
- Automating transformation steps
2
Data Modeling
- Relational table model
- Introduction to Power Pivot
3
DAX Formulas
- Calculated columns and measures
- Time intelligence functions
4
Automated Reporting
- Refreshable report templates
- Performance optimization
Tools Used
Microsoft Excel (Power Query, Power Pivot, DAX)
Frequently Asked Questions
It uses the same Power Query/DAX engine; this course builds the same skills while staying within Excel.
Submit your request to take this training.
Request This TrainingWe respond to requests within 24 hours.