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
KR
Very good to brush up on all available functions and also to review your skills or learn a new one.
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
Exceptionally well, the walk through process is very precise and the hands on exercises challenges your brain to think through.
SR
Course was well stuctured in small "bite size" parts. Everything was very clear and well explained. A very nice learning experience.
TR
This will help me get into depth of Excel power and automate my daily trackers and dashboards with more data visualization and analytics
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.
JC
Good, quick intro course that touches upon a number of different aspects of Power Query.
KL
This course needs a written guide after each module.
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.
AK
Great course, wonderful overview, clear instructor
Showing: 19 of 33
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.
It was explained very well, and having the ability to do the work along with the instructor helped make the lessons stick in the head easier. At the same time, the concepts progressed in difficulty well so it provided a sense of accomplishment when the course was finished.
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.
This will help me get into depth of Excel power and automate my daily trackers and dashboards with more data visualization and analytics
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.
Great course. Learning through practice is best way to learn.
Great course, wonderful overview, clear instructor
Step by step , a practical guide
Great tool for Finance people
very helpful for beginners!!!