Power Query Fundamentals
This course is for you if:
- You regularly use VLOOKUP or other lookup functions in your daily Excel tasks.
- You spend hours preparing the data to be analyzed in Excel or other spreadsheet tools.
- You consider yourself an advanced Excel or PowerBI user.
- You need to combine multiple data sources into a single big table of data.
- You are tired of using VBA to create automated scripts, or waiting for someone else to create them for you.
- You want an easy, fun, and optimized way of handling your messy company data.
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:
- Clear understanding when and where to use PowerQuery.
- How to clean and transform the most known types of data sources, accompanied by comprehending the logic behind connecting to any data source.
- Lots of simple and useful tricks to speed up data preparation.
- How to combine multiple data sources into a single solution (both with merging or appending tables)
- Understanding of M language and its most important building blocks (queries, parameters, functions)
- Techniques to utilize functions that can transform and clean hundreds of different sources, no matter how dirty the source data is.
Course Content
Instructor
Krešimir Ledinski
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
- 8+ Hours of Videos
- Downloadable Files and Handouts
- 150+ Questions
- 3 Lab Assignments
- Subtitles option for better understanding
- Discussion Groups
- Ask an Instructor option
- Certificate upon course completion
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
You must be logged in to submit a review.
*Only verified purchases are allowed to submit reviews.
Reviews
Excellent
Clear, concise and well delivered
Good Course
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.
Came from Youtube, glad I did 🙂
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!
If you can stand the editing, the course is excellent!
Editing quality could be better (especially sound), but the knowledge is just wow!
So much depth in explaining, especially on M language internals. Nice
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.
