PowerQuery Fundamentals

Holiday

OFFER EXPIRES IN

DAYS
HOURS
MINUTES
SECONDS

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 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

Expand All

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 PowerQuery 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

Recent changes to course

Scroll to Top