Power Query Course
Automate data cleaning in Excel & Power BI
Automate all your mundane repetitive data cleaning tasks.
A typical Excel report or dashboard goes through three essential phases.
Nearly 80% of the time is consumed in performing repetitive data cleaning tasks.
And the worse part.. you've got to do this again tomorrow, next week, next month. In fact, each time you need to create the report.
Power Query converts these tasks into one click of a button. It is truly sensational.
Who is this course for?
The course is split into two parts.
Part 1 - Fundamentals
These are short easy case studies to learn the most important features of Power Query from scratch.
Part 2 - Practical Case Studies
These are more advanced close to real-life case studies to apply learning from part 1 on how to automate your repetitive tasks.
"If you are looking to take your data analysis skills to the next level, this course will be worth every penny and minute of your time."
Introduction to the Power Query Course
Download the Practise Files
Getting Started & Becoming Familiar - Part 1
Getting Started & Becoming Familiar - Part 2
Combine Data from Multiple Excel Files - Same Structure
Combine Data from Multiple Excel Files - Uneven Data Structure - Part 1
Combine Data from Multiple Excel Files - Uneven Data Structure - Part 2
Combine Data from Multiple Excel Sheets - Part 1
Combine Data from Multiple Excel Sheets - Part 2
Loading Data from Web
Working with Dates in Power Query
Exercise - Clean this Data
Answer - Clean this Data
Errors & Things to be Cautious of in PQ
What is Unpivoting?
Answer - What is Unpivoting?
Grouping
The Reverse of Unpivoting - Pivoting
Joins in Power Query - Part 1
Joins in Power Query - Part 2
Application of Join - Vlookup in PQ
Application of Join - Dynamic Filter in PQ
Parameters and templates in Power BI
Cartesian Join
Scheduled Refreshes
M Code & Concepts - Part 1
M Code & Concepts - Part 2
Complex Date Transformations
Working with > Million Rows
Complex Unpivoting - 2 Headers
Very Complex Unpivoting and Combining Data - Part 1
Very Complex Unpivoting and Combining Data - Part 2
Combine Data from Multiple Excel Files - Advanced - Part 1
Combine Data from Multiple Excel Files - Advanced - Part 2
Refer to the Previous Row
Filtering Headers
Transpose Rows into Columns in Excel
Combine Duplicate Values into a Single Row
Repeat Row N Times
Unstack Rows to Columns
Unstack Uneven Rows to Separate Columns
Create a Dynamic Data Source Path - Part 1
Create a Dynamic Data Source Path - Part 2
Chandeep is an Excel & Power BI trainer, consultant and blogger. He is the founder of the Goodly blog and YouTube channel.
He lives in Dubai, UAE and used to work as a Financial Analyst for an Investment Bank in Mumbai (India). Back in December 2013, he quit to start Goodly.
Being an Analyst, he became really good with Excel and now teaches Excel and Power BI around the world through online courses, Blog, YouTube and live corporate training programs.