About this course
A more advanced companion to the Intro course. Where the introductory Power Query course gives you the GUI fluency, the Expert’s Guide takes you into the M-language layer underneath — custom functions, parameters, optimisation, and the case-study patterns that come up in real industry workflows.
Allah Ditta covers the full lifecycle: interface and connection to common sources, transformation fundamentals (filter, sort, split, merge, type-change, conditional logic, error handling, unpivot/pivot), advanced techniques (grouping, joins, custom columns, many-to-many relationships), the M language itself, and optimisation patterns for large datasets. The final module is a tour of Power Query applications across industries with hands-on case studies.
What you’ll learn
- Connect to Excel, databases, and online services
- Apply every core transformation: filter, sort, split, merge, type-change
- Handle errors, nulls, and conditional logic
- Unpivot and pivot data for analysis-friendly shapes
- Group, aggregate, merge, and append queries at scale
- Manage many-to-many relationships
- Write custom M-language functions and use parameters
- Apply performance-optimisation patterns for large datasets
- Work through real-world Power Query case studies
Who this course is for
Analysts who have used Power Query for a while and want to go beyond GUI-level operations into custom functions, optimisation, and the M language itself.
About the instructor
Allah Ditta is a Power Query specialist and trainer who has built and taught Power Query solutions across industries including finance, retail, and manufacturing.
What’s in this course
Introduction to Excel Power Query
- Course Introduction
- Course Content
- Introduction to Power Query
- Power Query Benefits
- Power Query Version and Compatibility
- Navigating the Power Query Interface
- Connecting to Data Sources
- Excel, Database, and Online Services
Data Transformation Fundamentals
- Data Transformation Fundamentals
- Filtering rows and Columns
- Sorting Data
- Splitting and Merging Columns
- Changing Data Types and Formatting
- Applying Conditional Logic
- Error Handling and Null-Values
- Unpivoting and Pivoting Data
- Pivoting Data
Advanced Data Transformation Techniques
- Advanced Data Transformation Techniques For Grouping and Aggregating Data
- Merging and Appending Queries
- Creating and Managing Custom Columns
- Handling Many-To-Many Relationships
- Loading Data into Excel and Integrating with Pivot Tables
Power Query Functions and Optimization
- Introduction to Power Query M Language
- Creating Custom Functions and Managing Parameters
- Best Practices For Data Transformation and Modeling
- Performing Optimizing Tips
- Troubleshooting Common Issues
Real-World Scenarios and Case Studies
- Hands-on Examples Showcasing Power Query Applications In Various Industries
- Query Applications in Various Industries
- Tips and Tricks For Efficient Data Analysis
- Resources For Further Learning
Get the Course Files
- Download the course files