Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 58 Minute(s)
Language
English
Taught by
Krešimir Ledinski
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Become an advanced data analyst! Learn more about Power Query (including M) and take your knowledge to the next level!
Power Query is a Microsoft ETL tool for data transformation and data preparation. It is available in Excel, Power BI 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.
This course is for 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.
If you need more assistance in training, feel free to check our website at exceed hr or our youtube channel Exceed Learning !
Course Content
- 13 section(s)
- 70 lecture(s)
- Section 1 Course Intro and Setup
- Section 2 Introduction to Power Query
- Section 3 Connecting to Data
- Section 4 Data transformations
- Section 5 LAB 1 Assignment: Data Transformations
- Section 6 Joining Tables
- Section 7 LAB 2 Assignment: Joining Tables
- Section 8 M Language
- Section 9 Power Query Parameters
- Section 10 Power Query Functions
- Section 11 LAB 3 Assignment: Functions and M Language
- Section 12 Optimizing Power Query for Speed
- Section 13 Power Query Advanced Techniques
What You’ll Learn
- Clear understanding when and where to use Power Query.
- 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.
Skills covered in this course
Reviews
-
GGeoff McKeon
So far, it's a good match. I'm looking forward to the rest of the content.
-
TThomas Donohue
This is pretty cool useful information
-
BBartosz Wincek
Quite interesting and useful, especially once the chapters M Coding, Functions, and Advanced PQ features start. The part on transforming was pretty limited in terms of contents. Dynamic M coding for handling changing number of columns very useful. Indeed, zooming while walking through the examples would make the materials more clear, transparent and easier to follow. List Generate function video - thanks a lot!
-
YYue W
Overall a good course. Could benefit from simple pan and zoom video editing.
