Power Query Fundamentals Course
This course is for you if:
-
You regularly use VLOOKUP 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 which 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.
Instructor
Krešimir Ledinski
More than 6 years of experience with PowerBI
Holds Microsoft MCSA Certificate in the field of BI reporting.
Learn more about Krešimir
Included in Power Query Fundamentals Course
-
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
Recent changes to course
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.
This course is for you if:
- You regularly use VLOOKUP 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 which 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
More than 6 years of experience with PowerBI
Holds Microsoft MCSA Certificate in the field of BI reporting.
Learn more about Krešimir
Included in Power Query Fundamentals Course
- 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
Recent changes to course
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.
