Data & Analytics
Power Query & Data Modeling
Master the ETL engine behind Excel and Power BI. Clean, transform, and shape data from multiple sources into structured, analysis-ready models.
18 hours
Live virtual sessions or on-site training
Intermediate to Advanced
What You Will Learn
Data Transformation
Merge & Append
Custom Columns
Star Schema Design
Course Curriculum
2 modules01
Data Transformation
- Connecting to files, databases, and APIs
- Column operations and data types
- Merge and append queries
02
Advanced Shaping
- Custom columns with M language
- Parameterized queries
- Error handling and data quality
- Building reusable templates
After This Course
- Automate data cleaning workflows
- Combine data from multiple sources
- Build reusable ETL templates
Who Is This For
- Excel power users
- Power BI analysts
- Data professionals
Prerequisites
Intermediate Excel or Power BI experience.
Ready to master Power Query & Data Modeling?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.