Data & Analytics
Power Query & Data Modeling
Master Power Query (M language) for data extraction, transformation, and loading across Excel and Power BI. Learn to automate data pipelines that clean, merge, and reshape data from any source.
Live virtual sessions or on-site training
3 Levels
Need a custom curriculum for your team? Contact us
What You Will Learn
Data Transformation
Merge & Append
Custom Columns
Star Schema Design
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modules01
Day 1: Connecting and Cleaning Data
- Understanding the ETL process: Extract, Transform, Load
- Launching Power Query in Excel and Power BI Desktop
- Connecting to Excel, CSV, web, and folder sources
- Navigating the Power Query Editor interface
- Removing columns, filtering rows, and sorting data
- Changing data types and handling errors
- Renaming columns and promoting headers
02
Day 2: Basic Transformations and Loading
- Splitting and merging columns
- Replacing values and trimming whitespace
- Unpivoting and pivoting columns for reshaping data
- Adding custom columns with simple formulas
- Grouping rows for summarization
- Configuring load destinations: table, connection, or data model
- Refreshing queries and understanding applied steps
After This Level
- Connect to common data sources and load data into Power Query
- Clean and shape data using essential transformations
- Reshape data with pivot, unpivot, and group operations
- Load transformed data into Excel tables or Power BI models
Who Is This For
- Data analysts and report builders
- Excel power users moving to Power BI
- Anyone who prepares data from multiple sources
Prerequisites
Familiarity with Excel or Power BI basics.
Ready to master Power Query & Data Modeling?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.