Introduction to Power Query

This course will delve into the depths of the Power Query Editor in Power BI and the Data Cleansing & Preparation stage of Power BI development.

If you use Power BI and have experienced the challenges of data preparation, you'll know why it's so important to understand how to deal with the quagmire of errors, formatting issues and the struggles of bringing data together from multiple sources. If you can't resolve these data issues, you end up with bad data that leads to flawed insights. The vital foundation for all great reports is well-prepared data, this course will teach you how to get your data report ready.

You will learn:

• How to use Power Query Editor

• How to approach Data Mashup & Transformation using M Script and R Script.

• How to use more advanced tools to assist with data preparation.

This is a hands-on course and will take you through a variety of realistic lab scenarios and data preparation challenges. By the end of this course you will be fully prepared to solve your own data quality issues and produce high quality report ready data.

This Power BI training course is offered in a face to face classroom or virtual setting and can be tailored to your needs.

What Next?

With your data preparation complete you'll now need to create your tabular model. Take the next step on your Power BI journey with our Tabular Modelling For Power BI Course.