Fundamentals in Power Query and M

Acquire an extensive knowledge and understanding of the Power Query and M language to help you easily transform your data from multiple sources into Power BI

An outline of this training course

Gain a comprehensive knowledge on Power Query as a tool in preparing, transforming and loading data; and designing and shaping tables for data modelling.

Develop an in-depth understanding of the elemental building blocks of all Power Query operations, whether accessed through the user interface (UI) or via custom M code.

In this course, Melissa de Korte provides a progressive framework with extensive examples that will allow you to perform a nearly infinite array of data transformations that will improve your data model, speed report performance, and simplify your DAX. This is the first of multiple Power Query/M courses that Melissa has planned over the coming years

Power Query/M Masterclass course - can also be accessed through a purchase of an Enterprise DNA Membership or Center of Excellence License.



Details of what you will learn during this course

  • Gain - an extensive knowledge and understanding of the Power Query User interface and the components of the M language programming
  • Explore - the features and capabilities of the Query Editor as a data transformation tool
  • Develop - a holistic understanding of Power Query's elemental building blocks: values, lists, records, tables and functions
  • Learn - how Power Query treats data types, and how to trap and correct common errors
  • Obtain - expert insight into more advanced topics, such as environments and projection and selection
  • Acquire - strategies for mastering M code over time


What you get with the course
  • Almost 3 hours of intensive training videos
  • Resource pack of pbix files and data sets for practical application

Testimonials

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

"Sam and EnterpriseDNA have taken my PowerBI to the next level. The courses are excellently well presented. Sam's extensive experience in building BI tools means the tutorials and webinars are always relevant and always hit the mark. Enterprise DNA is a 5* resource - I highly recommend."- David Nightingale, Johannesburg South Africa   "I came across Enterprise DNA through one of the free YouTube videos. After getting a lot of valuable info for free, I felt ready to dig deeper into PowerBi in general and DAX in particular, and the membership here certainly has given me good value for money therefore I highly recommend signing a membership." - Erik Jacobsen, Scandinavian   "I have been in the Analytics and Data Warehouse space for about 20 years and have been a serious advocate of Power BI from it’s inception. I am excited to become a member of this forum, having review as many of Sam’s vidoes as I could and have enefited significantly from his tutelage." - Brad - Canada

Your Instructor


Melissa de Korte
Melissa de Korte
  • Skilled in ETL and Modelling. Delivered practical Power Query solutions in both Excel and Power BI.
  • Expertise in analysing business process data. Delivering, deploying and supporting Power BI solutions throughout the organisation.
  • All-round Power platform enthusiast.

Course Curriculum


  Introduction
Available in days
days after you enroll
  Power Query / M
Available in days
days after you enroll
  Your Feedback
Available in days
days after you enroll
  Certification
Available in days
days after you enroll

Frequently Asked Questions


How long do I have access to the course?
You will have access to the course for as long as your Enterprise DNA membership or CoE license is active.
Can I purchase a single course instead of the full Enterprise DNA membership?
The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
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

"The course is ideal of those like me who are looking for a central resource in which to learn. The subject can seem overwhelming when you are flipping from one providers channel to another. I wanted to build a strong base from which I could be confident moving forward." - Anna Corr

 		"The course has been structured in a way that is in bite size pieces that makes it easy to consume. The focus of getting the basics and teaching about best practices is essential for the success of using Power BI to build meaningful reports."
- SC Leung



 		"Excellent courses, easily understandable, breaking concepts down to manageable subject areas. They give you a great foundation to developing great, useful and amazing Power BI reports."
- Stephen Whitehead