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.

Once you purchase the course, the access is Life-Time.

 

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.7
Rated 4.7 out of 5
4.7 out of 5 stars (based on 10 reviews)
Excellent80%
Very good10%
Average10%
Poor0%
Terrible0%

*Only verified purchases are allowed to submit reviews.

Reviews

Easygoing but thorough.

Rated 5 out of 5
March 15, 2021

Have taken some online courses before and I must say Krešo’s stands out. The one I’ve taken started as beginner-paced but advanced and opened up when you’d expect it to. He left no stones unturned, and I had all my questions answered by the end of each lesson. Found the tests tiresome but that’s what makes lessons settle in after all.
Cheers!

Avatar for Tin T
Tin T

Value for money

Rated 3 out of 5
November 8, 2020

Unlike other Power Query courses, this one really focuses on the M language (I would even say that it’s not novice course but intermediate level). Like the subs under the videos. Few topics could be more explained, but overall good course!

Avatar for Gaston F
Gaston F

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