Power Query Course

Learn to automate your mundane Data Cleaning Tasks using Power Query

A quick talk

I call the following a Data Jockey's Ordeal !

A typical Excel Report or Dashboard goes through 3 essentials phases

  1. You get Data from multiple sources, consolidate it, clean it (vlookup, filter, add-delete columns or rows and bunch of other mundane repetitive tasks..)
  2. Then Analyse it - Formulas / Pivots
  3. Finally Present it - Graphs / Charts & PPTs

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

Most people of think of solving this problem using... VBA (creating a Macro in Excel). Not a bad idea but not that good as well. 3 Major problems that you'll run into

  1. VBA can't handle large data sets - It tends to be as slow or slower than Excel
  2. VBA is hard to learn - The grammar of VBA, the syntax, the logic building takes a long time to master
  3. VBA Code will break from even the slightest change the data structure.

And you are back to manual data cleaning.

Consider my solution..

Learn Power Query

3 awesome things about Power Query that you can't ignore

  1. Power Query is a mind blowing tool to clean and automate data cleaning process
  2. It's free and is already built into Excel and Power BI
  3. It is damn easy to learn!

Results of using Power Query

In the last few years I have taught hundreds of people, how to use power query to solve data cleansing and automation problems.

Now it may sound like that I am exaggerating but the major benefit that all of my students got that how much time they saved by automating repetitive tasks.

I am not taking about 10-20% efficiency. Consider a long, mundane data cleaning task that took 3 people, 3 hours each day for a week, now gets done in 20 mins flat. With one click!

3 people x 3 hours per day for 5 days = 45 hrs saved per week for only on a single task!

I am sure you'd want that.. wouldn't you?

Consider this automation example

If you don't believe me see this simple example of combining data from multiple excel files... Imagine how much time would you take to do this manually each day.

I solved this problem using Power Query (this is an actual video from the course)

Power Query Course

Power Query is going to be new for you.. you will need help from scratch. That's why I have put together this course which teaches you how to work with Power Query and set up automation right from Scratch.

The course is divided into 2 parts

  • Part 1 The Fundamentals (21 Lessons) - These are short easy case studies to learn the most important features of Power Query from scratch
  • Part 2 Practical Case Studies (15 Lessons) - These are more advanced close to real life case studies to apply the learning from Part 1 on how to automate your repetitive tasks

Download the Detailed Course Outline (pdf)

Bonuses Included..

  • Excel Crash Course for 2+ Hours ($99) - Most important Excel Formulas, Shortcuts & Pivot Tables
  • Life time access to both course - Power Query + Excel Crash Course
  • Access to all future course updates

Come learn Power Query with me

Your Instructor

Chandeep Chhabra
Chandeep Chhabra

Hi, my name is Chandeep! I am assuming that you already know me through my blog. But if you are new around here, let me give you some quick listicles about me

  • I stay in Gurgaon in India
  • I 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, Excel and PowerPoint were the 2 tools that I became really good at and Goodly is all about teaching people how to use these tools effectively
  • I now run a blog (www.goodly.co.in) which has over 400+ posts on practical use of Excel and PowerBI in real life business scenarios.

I have meticulously created this course to help you build solid data analysis skills. Since it is an online training program you can finish it on your own pace and convenience

There is just one strong recommendation -
Don't buy this course and then never use it! Be consistent in completing & practicing the lessons everyday and I promise you'll see surprising results for yourself

Frequently Asked Questions

When does the course start and finish?
The course starts as soon as you complete the payment process. It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
Your login will be active for 1 year from the date of purchase. You can even download all videos and example files.
What if I am unhappy with the course?
I would never want you to be unhappy! If you are unsatisfied with the course just shoot me an email in the first 30 days and I'll give you a full refund. No questions, no grudges :)

Indian Students enroll here

Get a better deal - Enroll in the 4 in 1 Bundle

DAX Course + Power Query Course + DAX Functions Library + Excel Refresher Course

Enroll for $239

Get started now!

If you always wanted to work faster and smarter, don't procrastinate. This course will be worth every penny and minute of your time.