Nearly 80% of the time is consumed in performing repetitive data cleaning tasks!
The worst part.. you’ve gotta do this each day, each week, each month in-fact each time you need to create the report 😑
Think how much time would you save if you automate this process ⏲️
Most people of think of solving this problem using… VBA (creating a Macro in Excel). Not a bad idea but there are 3 major problems that you’ll run into,
VBA can’t handle large data sets – It tends to be as slow as Excel.
VBA is hard to learn – The grammar of VBA, the syntax, the logic building takes a long time to master.
VBA Code will break from even the slightest change in the data structure.
And you are back to manual data cleaning.
Consider my solution.. 🧠
➜ Power Query is a mind blowing tool to clean data and automate repetitive data cleaning tasks.
➜ It’s free and is already built into Excel and Power BI.
➜ It is damn easy to learn!
In the last few years I have taught thousands of people on how to use power query to solve data cleaning and automation problems.
Now it may sound that I am exaggerating but the major benefit that all of my students get is that how much time they save by automating repetitive tasks.
I’m sure you’d want to save that much time.. wouldn’t you?
What is Power Query?
Combining Data from Multiple Excel Files – Simple Version
Combining Data from Multiple Excel Files – Advanced Version
Combining Data from Multiple Sheets in a Single Sheet – Using IF
Combining Data from Multiple Sheets in a Single Sheet – Without using IF
Loading Data from the Web
Working with Dates
Exercise 1 – Question and Answer
Intervention 1 – Common Errors and Gotcha’s in Power Query
Joins in Power Query
Application of Joins – VLOOKUP
Application of Joins – Dynamic Filters
Using Parameters & Templates in Power BI
Schedule your Refresh
M Code Basics
Exercise 2 – Slightly more complex case
Working with more than 1 Mn Rows in Excel.
Complex Date Transformations
Complex Unpivoting – Data with 2 Headers
Combining & Complex Unpivoting together – Creating Custom Functions
Combining Data from Multiple Excel Files – Everything is dynamic
Filtering Headers of Data
Transpose Rows in Columns – Only for a single column
Combine Duplicate Values in a Single Row
Repeat Row N Times
How to Unstack Rows in Columns
Dynamic Column Renaming
Creating Dynamic Path for Excel and Power BI Source Data
How to refer to Previous Row
Replace Errors in Multiple Column at Once
Make Remove Other Columns Dynamic
I am assuming that you already know me through my blog, but if you are new around here, here are a few things about me.
I stay in Dubai, UAE and used to work as a Financial Analyst for an Investment Bank in Mumbai (India). Back in December 2013 I quit my full time job to start Goodly.
Being an Analyst, I became really good with Excel and I now teach Excel and PowerBI around the world through Online Courses, Blog, YouTube and LIVE Corporate Training Programs.
Power Query can do a lot of complex stuff only using the user interface (without any code). You need to understand what options are available and how to use them.
Realistically speaking, if you practice for 1 hour each day you should be in a really good position to solve real life problem within a month.
Yes. Power Query comes built in Excel (2016 and onwards) and in Power BI. Even if you’re working with older versions of Excel (2010 or above) you can install Power Query for free.
Your Power Query knowledge can transferred to Power BI, Power Platform and Excel.
No. I don’t go in depth of the M language in this course. I am working on a separate course for learning advanced applications of M language.
I’ll help you with structured learning and guidance along the way and not let you make the mistakes that I made. But there are no shortcuts and you’ll have to put in the hard work.
If you’ve liked my teaching style so far on YouTube – I am pretty sure you’re going to love the course too.
Copyright © 2022, Goodly. All rights reserved.