In this online Power Query Fundamentals course, we’ll explore the world of data transformation and automation. You’ll learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, we’ll end by looking at how to deal with common errors. Power Query is absolutely essential for any Excel focused analyst, and is a powerful asset to any Business Intelligence analyst. These skills will help you spend less time on data manipulation, and more time on your analysis projects. By the end of this course, you will be able to: ● Identify the characteristics of good and bad data using the principles of data normalization ● Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot ● Extract information from fields that combine two or more values ● Transform datasets by grouping or combining data from different tables, or even multiple files from the same folder ● Avoid, interpret, and fix errors and exceptions that you experience in Power Query ● Load transformed data into Excel for use as automated data feeds
MM
Very easy to follow and covers a wide variety of uses. Loses a star because some course material in incomplete, so you couldn't properly answer some questions.
DC
Excellent and well paced! Practical and interesting examples. Really the best course I've done!
CL
Its to the point, hands-on, bite-sized, useful real-world scenarios and techniques. Its a great course.
KL
This course needs a written guide after each module.
EW
The hands on practice was great for me, as I tend to letter better that way. Recommend for this with basis excel knowledge, and zero power query knowledge.
JC
Good, quick intro course that touches upon a number of different aspects of Power Query.
VS
Great course. Learning through practice is best way to learn.
KR
Very good to brush up on all available functions and also to review your skills or learn a new one.
EC
Excellent course for beginners who want to get really familiar with Power Query through examples and practice.
JC
Exceptionally well, the walk through process is very precise and the hands on exercises challenges your brain to think through.
AK
Great course, wonderful overview, clear instructor
SR
Course was well stuctured in small "bite size" parts. Everything was very clear and well explained. A very nice learning experience.
Showing: 20 of 28
Course was well stuctured in small "bite size" parts. Everything was very clear and well explained. A very nice learning experience.
Excellent and well paced! Practical and interesting examples. Really the best course I've done!
This course needs a written guide after each module.
Good class and instructor. My only comment is that this class is for PC users, not Mac. It would be beneficial to have this disclosed in the class description. Some functions covered in the class are not supported by Mac - there are work arounds, but you need to find them yourself.
The hands on practice was great for me, as I tend to letter better that way. Recommend for this with basis excel knowledge, and zero power query knowledge.
Definite the best course if you want to improve your skill with large data bases, is a challenge and all the task and all tasks enhance knowledge.
Exceptionally well, the walk through process is very precise and the hands on exercises challenges your brain to think through.
I love this course!! It was so perfectly and easily explained and the instructor's voice is perfect. Thank you!!
Excellent course for beginners who want to get really familiar with Power Query through examples and practice.
Its to the point, hands-on, bite-sized, useful real-world scenarios and techniques. Its a great course.
Very good to brush up on all available functions and also to review your skills or learn a new one.
Good, quick intro course that touches upon a number of different aspects of Power Query.
It is perfect and very practical I enjoyed the course thoroughly
Great course. Learning through practice is best way to learn.
Great course, wonderful overview, clear instructor
Great tool for Finance people
very helpful for beginners!!!
thanks! Very good Course!
love it very good basic
Best couse i ever found