Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 42 Minute(s)
Language
English
Taught by
Randy Minder
Rating
2 views
Course Overview
Learn Power Query by working through real-world transformation scenarios via 30 exercises and questions
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.
Course Content
- 4 section(s)
- 51 lecture(s)
- Section 1 Introduction
- Section 2 Did you know Power Query is self-documenting?
- Section 3 An M Primer
- Section 4 Time for some fun
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
Skills covered in this course
Reviews
-
BBhavnish Mohla
This course started off well, with some good custom functions in Power query, but all the exercises felt very underwhelming, I didn't need any help or referring to instructor's solution for a single one, and they all were solved by just using the GUI.
-
RRadek Slezinger
Personally, I have found this course pretty helpful, especially the last part of this course focused on particular common scenarios. But as it was said by the tutor at the beginning, this is not intended to be a comprehensive PQ or M-language course. Still recommend to buy mainly for beginners.
-
MMichael Smith
Informative. Nice to see coding in editor; however some steps can be achieved with "buttons" in query editor. For example the Expanding records can be accomplished by clicking on icon in header.
-
NNarendra Nath Dey
Examples are appropriate to my day to day work
