Data Preparation and Transformation with Power Query

  • Course level: Intermediate


Power BI is a business intelligence tool that allows you to share and build reports and dashboards with various sources that help increase a company’s productivity by delivering useful, time-sensitive, and dynamic information for monitoring and decision-making process. This is great for those who want to quickly learn and upskill on reporting, building dashboards, and data visualization not only user-friendly, Power BI offers numerous complimentary applications, easy access from any location, and have a large and thriving community for forum discussion and development.

The first part of the Intermediate Power BI course focus in-depth on topics such as creating and getting data, learning how to perform data discovery, exploring a different way of data transformation via Power Query built-in features and M query, an introduction to M query language and its applications and lastly, understanding data modeling and how it impacts on the report.

Each topic is designed and layout to give a comprehensive understanding of how each component in Power BI works and impacts each other as well as a hands-on practical exercise and quiz to help familiarize with the tools and application.

What Will I Learn?

  • Able to import and connect data to the report
  • Perform data discovery and apply the different methods to transform data
  • Learn data modelling, comprehensive usage

Topics for this course

18 Lessons

Getting Your Data?

In this topic, we will learn about different data sources and how to import them into our report including how to create our own data, understanding how it works, what to expect, being aware of the common error and mistakes when importing data.
Creating your own data
Getting your data, part 1
Getting your data, part 2
Topic 1 – Quiz 1

Data Discovery and Transformation via Power Query?

In this topic, we will review the basic features of data discovery and transformation via Power Query then explore more in-depth on each topic respectively why it is important and how it can help us build our report

Data Transformation via M Query, part 1?

In this topic, we will do a quick overview on M query on how it works, learn and practice transforming data with M query and number of ways to create parameters and function in Power Query

Data Transformation via M query, part 2?

Learn how to manipulate data with M Query including best practices on how to structure a clean query code, incorporate other languages with M Query such as SQL language, and apply parameter and custom function

Data Modeling?

In this topic, we will get to know and understand data modeling and the relationship of data and how it will impact aspects of our report such as DAX calculation, measurement, and logic of how our data is visually presented.

About the instructors

5.00 (2 ratings)

6 Courses

17 students

0 (0 ratings)

2 Courses

0 students


Material Includes

  • Content docs
  • Quizzes
  • Assignments


  • Basic knowledge and usage of Power BI (referred course: Introduction to Power BI), Power BI Desktop Installed

Target Audience

  • Learners with basic Power BI knowledge who want to rapidly increase their skill in applying Power BI and learn to build reports for their work