Data Preparation and Transformation with Power Query

About Course

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.

Course Content

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

Add this certificate to your CV profile to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

Data Preparation and Transformation with Power Query

About Course

What Will You Learn?

Course Content

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

Assignments

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 Discovery via Power Query

Transform Data via Power Query, part 1

Transform Data via Power Query, part 2

Assignments

Topic 2 – Quiz 2

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

Getting to know M Query

Transforming Data via M Query

Creating Parameter and Function

Assignments

Topic 3 – Quiz 3

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 Manipulation with M Query

Using Parameter and Function in M Query

Assignments

Topic 4 – Quiz 4

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.

Data Modeling and How do we do it

Impact of Data Modeling

Assignments

Topic 5 – Quiz 5

Earn Your Certificates

PROGRAMS

COMPANY

COMMUNITY

About Course

What Will You Learn?

Course Content

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

Assignments

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 Discovery via Power Query

Transform Data via Power Query, part 1

Transform Data via Power Query, part 2

Assignments

Topic 2 – Quiz 2

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

Getting to know M Query

Transforming Data via M Query

Creating Parameter and Function

Assignments

Topic 3 – Quiz 3

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 Manipulation with M Query

Using Parameter and Function in M Query

Assignments

Topic 4 – Quiz 4

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.

Data Modeling and How do we do it

Impact of Data Modeling

Assignments

Topic 5 – Quiz 5

Earn Your Certificates

Student Ratings & Reviews

PROGRAMS

COMPANY

COMMUNITY

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.

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.