The Power Query Workshop - Part 1
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
Featured review
![Gregory Ian Felton](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Course content
- Preview01:44
- Preview01:21
- Preview05:26
Instructor
- 4.5 Instructor Rating
- 698 Reviews
- 4,502 Students
- 19 Courses
Microsoft Certified Professional:
Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 - 80% score)
Snowflake Core Certification Exam (April 2021 - 90% score)
Seasoned database architect (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence and Power BI. 20 years of software development using a variety of Microsoft technologies, mostly C#.
2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.
StackOverflow reputation of 42,200 (top 1%)