Current Status
Not Enrolled
Price
58
Get Started
This course is currently closed

Power Query Fundamentals

Play Video

This course is for you if:

No previous knowledge is required to enroll in this course, only to have a PowerBI desktop application installed.

We scripted the whole course (video lectures also) and found that passing all topics and receiving a certificate is equal to learning approx. 400 pages of a PowerQuery specific book.

The course is created upon a highly successful on-site course that was held more than 20 times and taught more than 200 attendees.

After completing the course you will be equipped with:

Course Content

Expand All

Instructor

PowerBI counselor, a business consultant for FMCG and lecturer, PowerBI/Excel trainer, has been using PowerBI/Excel extensively for the last 8 years in his everyday work.
Holds Microsoft MCSA Certificate in the field of BI reporting.
Learn more about Krešimir

Included in Power Query Fundamentals

FAQ

Power Query is a Microsoft ETL tool for data transformation and data preparation. It is available in Excel, PowerBI and other Microsoft products and provides the ability to connect to data sources, transform the data into correct structures and then load the data into the data model. This tool is a great improvement for the data analytics process because it gives a faster and easier approach to solve major business problems associated with messed data structures.

The course is for novice Power Query users that are interested in improving their knowledge about Power Query and the M Language. It starts with the basics of Power Query and soon upgrades to the advanced level of M scripting. It is ideal for those who want to understand the range of abilities of Power Query and learn how to use the most powerful data transformation tool.

The course is a quick way to learn the main concepts of Power Query from novice to expert. As soon as you finish the course you will be familiar with the Power Query interface and feel comfortable using it. You will also get the advanced knowledge of the M Language that is the programming language of Power Query and you will be able to read it, write it or understand it.

It contains 9 chapters, 3 LAB Assignments and short quizzes after every finished chapter to help you testify your skills. The course is progressive, meaning you can’t skip chapters, but upgrading your knowledge step by step.

After receiving the payment confirmation, we grant you access to the course and you can start with your learning experience.

The course is based mostly on videos showing and explaining the features of Power Query that are easy to follow. Other materials are LAB Assignments that are downloadable at the beginning of every LAB Assignment chapter.

Yes. Quizzes at the end of the chapters are required and you need to have at least 50% to pass the quiz. If not, you can always retake the quiz. At the end of the quiz, you will receive your result with the possibility to see your answers as well as the correct answers if answered wrong.

Yes, you can access your certificate on My Account page of the site and download it after you have completed the course.

We offer you a 100% refund within 30 days if you are unsatisfied with the course, under the condition that you have completed less than 25% of the course. After that period, we don’t offer refunds. We would appreciate it if you let us know the reason why you don’t like the course so that we can continue with the improvement in such case.

Course rating Summary

4.6
Rated 4.6 out of 5
4.6 out of 5 stars (based on 7 reviews)
Excellent72%
Very good14%
Average14%
Poor0%
Terrible0%

*Only verified purchases are allowed to submit reviews.

Reviews

Excellent

Rated 5 out of 5
September 6, 2021

Clear, concise and well delivered

Avatar for Klaus G
Klaus G

Good Course

Rated 5 out of 5
August 31, 2021

Very quality course! It helped me solve some basic business problems I face when transforming messy data structures. Not only educational but also very interesting topics! Would recommend this course to anyone who works within Excel or PowerBI.

Avatar for Vladimir V
Vladimir V

Came from Youtube, glad I did 🙂

Rated 5 out of 5
August 20, 2021

It’s all nice and easy until you hit the functions’ part! That part solely helped me automatize half of my daily Excel tasks. Well worth the money!

Avatar for Dennis H
Dennis H

If you can stand the editing, the course is excellent!

Rated 4 out of 5
July 12, 2021

Editing quality could be better (especially sound), but the knowledge is just wow!
So much depth in explaining, especially on M language internals. Nice

Avatar for Tommy G
Tommy G

Recent changes to course

New topic added – Using lists to dynamically change column names (part of the M language lesson).

Minor lab document fixes based on students reviews. 

Adding visual elements in lessons Data Transformation and Joining Tables.

Adding additional textual explanations to the first part of the course.

Fundamentals Course

Course Content

Expand All
Scroll to Top

BUY THIS COURSE TODAY FOR €58