Power Query Series

Develop best practices in connecting, combining and refining data sources to effectively provide automated and high-quality data for reporting and analysis.

  Enroll in Course

An outline of this training course

This mini series module reviews many best practice tips in using Power Query as a data connection technology featured in Excel and Power BI. Tutorials cover key features of Power Query including tips in searching for data sources, making connections, and shaping data to meet your Power BI needs. By using the techniques showcased in this course, you will be able to save time through automation of various task and perform various complex data cleansing activities. This course is designed for beginner to advance users of Power BI.

Power Query Series module can also be accessed with a purchase of an Enterprise DNA Membership or Center of Excellence License.

Details of what you will learn during this course
  • Learn - the key features of Power Query as a data connection tool for Excel and Power BI
  • Understand - the most techniques that can be utilized for automation of task
  • Learn – how to merge and shape data sources to match your data analysis requirements
  • Learn – how to prepare data for further analysis in Power BI
  • Master - the beginner techniques before moving onto advanced development

What you get with the course
  • Over 3 hours of video tutorials
  • Over 12 short form video tutorials covering best practices and feature reviews
  • An accompanying resource download for appropriate video tutorials

Here are the specifics for the course
Learn how to:
  • Master the key features of Power Query
  • Use important techniques in organizing data
  • Learn how to merge/blend and consolidate data from different sources
  • Create data automation practices
  • Clean data for better analytics


For testimonials and to see how Enterprise DNA is helping thousands more Power BI users, check out the testimonial wall

For a list of all courses available through Enterprise DNA, view here.

"Very powerful learning sessions and insights. I knew Power BI since quite a long time but never knew how amazing, powerful and dynamic it is. Enterprise DNA is high probably the best online learning community for Power BI." - Arnaud Chatueng "It has really opened a new world of possibilities for me, when I look at the data now. I start to ask questions about the data at hand, which I never thought before. It has helped me a lot to improve my skills at handling different scenarios regarding data analysis." - Wajahat Mahmood "Normally, I am not very enthusiastic about online tutorials. However, I was surprised that I went through the course in one sitting. Each session sparked my interest since I could visualize how the content relates to my working environment." - Shane Barnes

Your Instructor

Sam McKay
Sam McKay

Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.

He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.

Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charterholder, achieving the designation in 2011.

He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.

Course Curriculum

  Power Query Series
Available in days
days after you enroll
  Your Feedback
Available in days
days after you enroll
Available in days
days after you enroll

Frequently Asked Questions

When does the course start and finish?
This is an on-demand course that you can view at any time once you are enrolled.
Can I download the course modules?
Yes, they are all available for download and watching offline.
How long do I have access to the course?
If you purchase this course individually, you will obtain lifetime access. If you upgrade to Membership or our CoE, this is an annual subscription.
Can you create an invoice for my company?
You will receive a receipt after purchase but if you need anything more then please make contact directly via - [email protected] and this can be arranged.
Do I get Membership or CoE access if I purchase this course individually?
No, you must purchase the relevant All Access pass to receive all the additional offerings embedded into our platform.
What currency is the price in?
All pricing is in US dollars.
Can I buy one license and share it with other people?
No, it is strictly one license per user. This is monitored at Enterprise DNA.
Do you offer one-off support or coaching?
All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.
What if I need to train my team?
We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Passionate about empowering users of Power BI

"My goal is to teach others that you have almost unlimited analytical power when harnessing all the features in Power BI.

Through training across a number of different mediums, I've reached over 100,000 Power BI users, showing them a range of tips and tricks in Power BI development.

I'm a true believer that Power BI is the future of analysis and know individuals with the right training can now create advanced analytics in a scalable way that can have a real impact in the way insights are found and consumed within organisations."

Sam McKay, CFA - Founder & CEO, Enterprise DNA

"Fantastic course and content, I enjoyed walking through each topic area, which was detailed enough to allow me to apply the concepts immediately, without being overly time consuming. My reports look amazing now and have been constructed the correct way, with clean data tables and structures, rather my original hodge-podge approach." - Mal Breen "This is an excellent course for people who are looking to understand and enhance their use of DAX formulas. It contains thorough explanations with clear examples. I was able to implement lots of improvements to my projects after completing this course." - Lee Mounter "Enterprise DNA is only the platform to learn detailed Power BI, I have gone through the multiple courses online, I have never gotten the complete knowledge on Power BI, Enterprise DNA has fulfilled my dream of learning Power BI in detail. Thank you Sam, you are super person in training" - Shailendra

Get started now!