
Table of Contents
The Power Query Workshop – Part 1 Free Tutorial Download
What you’ll learn
-
This is a hands-on course. You will learn how to perform many types of transformations by working through real-world exercises
-
Gain a better understanding of the basic operation of M via 13 lectures in the M Primer section
-
Work through 30 real-world exercises and questions and then watch as we work through each one, emphasizing the M functions used to solve the transformation
-
Build a basic Power BI report showing information about every M function
-
Learn the basics of pivoting and unpivoting data through our Pivoting Basics lecture and several related exercises
Requirements
-
Some basic knowledge or experience with M and Power Query
Description
The Power Query workshop is a unique course that allows the student to gain experience with Power Query by practicing on all sorts of common transformation scenarios. The course contains, among other things, 30 real-world exercises that will help you gain experience with many types of transformations you will perform in your day-to-day work. The course is targeted towards those students who have some experience with Power Query and M but not enough to really feel proficient.
Who this course is for:
- Anyone using Power Query to transform data