Power Query Advanced - Better Techniques for Better Results

Your next step to mastering the financial data cleaning process.

The course every Power Query user needs.

Build amazing data transformations with confidence using higher-level features.

What Will I Learn?

  • Create data analytics like world-class companies
  • Executive Case Study: you will clean, analyze and document a project data set ; includes video instructions and downloadable Excel file solutions to insure you're learning
  • Write If-Then-Else statements within conditional columns and create embedded functions in custom columns
  • Reference the Power Query Formula Language to find and use unique functions to transform your data
  • Build using the 'M' language Advanced Editor and Query Manager to control your processes and work faster


  • Strong desire to learn advanced Power Query data cleansing skills
  • Basic knowledge of Power Query (have used it, even at a beginner level)
  • Know your way around the Power Query ribbons and editor

Who Is The Target Audience?

  • Those who want to learn an in-demand business skill and increase their career opportunities
  • Those who want to improve their data analytics and Power Query talents
  • Those who are willing to try Power Query in new ways

Class Curriculum

  How to Use Power Query In Advanced Ways: Do More In Fewer Steps
Available in days
days after you enroll
  How to Use Waterfall Queries
Available in days
days after you enroll

Your Instructor

Doug Burke
Doug Burke

If you're like me, you see tremendous value in developing your career in data analytics and creating financial systems. Companies need these skills more than ever.

But did you know . . .

The hardest part of any useful financial system is getting it to meet your specific data needs

This statement comes from my 20+ years of experience building data analytics systems at Fortune 500 companies. Let me share my secrets so you can build first-rate financial systems and fill them with clean data.

My specialty is creating financial systems using Excel 2016, Power Query, Power Pivot and Power BI.

I love this topic and use it every day . . . Learn from me.

  • I read the software user manuals so you don't have to
  • I enjoy teaching complex topics in a clear, simple manner
  • I'm very involved in the financial analytics community as a member of Microsoft's Power BI User Panel, and a frequent speaker at Oracle analytics events

Courses like mine are not widely available so I decided to create one.

Thanks to the internet, a global audience now shares this knowledge. Don't believe me? Here is an instructor dashboard snapshot from when I taught on Udemy. This stuff has gone global!

Now I have my own site at so I can offer students even more opportunities for learning.

Take my courses and enter a community of like-minded people who want everyone to succeed. I will personally answer any question posted and provide frequent updates on what's happening in the financial analytics and Power BI communities.

There is so much value here and I encourage you to join.

div class="preenrollment-form-wrapper col-sm-10 col-sm-offset-1">

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! 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?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!