Power Query and Data Modeling

with Dimitar Shutev
4.8/5
(631)

Microsoft’s universal data transformation tool Power Query enables you to prepare data for reporting. It comes with a graphical interface and allows to get data from multiple sources.

2 hours 21 lessons
Start course
21 High Quality Lessons
1 Practical Tasks
2 Hours of Content
Certificate of Achievement

Course Overview

Data needs to be transformed and reshaped to meet our reporting needs. This process is called data modeling and one of the best ways to perform it is with Power Query. Power Query is a data preparation and transformation engine, originally introduced as an Excel 2010 add-on. It is widely available within Microsoft products, such as Power BI, Excel, Azure, and Dataverse. Power Query connects to multiple data sources, including SQL DB, Rest API, csv, JSON, Google Analytics, Web, etc. It provides the same user experience and data transformations regardless of the source. In this course, you will learn how to use Power Query to perform data modeling to prepare your data for analysis with BI tools like Power BI.

Topics covered

Business IntelligenceData modelingdata preprocessingPower Query

What You'll Learn

Learn how to use Power Query to perform the essential Extract, Transform, and Load (ETL) tasks necessary to process data from different sources. Then, you can use that data in Microsoft Azure, Microsoft Excel, Microsoft Power Bi, etc.

How to import data
Work with different data types
Importing data
Data preprocessing
Date functions
Merge queries

Curriculum

Student feedback

4.8/5

631 ratings
5 stars
518 (82%)
4 stars
99 (16%)
3 stars
13 (2%)
2 stars
1 (0%)
1 star
0 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
23.07.2023
It was fine but a basic level. I thought it could be an advanced level course. Would be great if there is advance level course using the APIs, Creating the Dataflows, merging the dataflows and so on.
12.05.2023
Power Query as a very powerful tool for ETL process at data analysis. This course helps me to gain valuable insight into how to operate through power query and transform my data for analysis.
08.01.2024
This course was beneficial and informative. I enjoyed it and want to thank the teacher. I highly recommend taking this course before starting with Power BI.
23.01.2023
The course content gave me the necessary knowledge and skills to a good start for my Data Science projects.
21.11.2022
Very good introduction to Power BI for someone who had zero experience to start with.
  • 1
  • 2
  • 3
  • ...
  • 11
  • ...
  • 20
Dimitar Shutev

“Data needs to be reshaped before it is ready for reporting. This is why Power Query is so powerful. It provides a guided user interface and is so easy for users to interact, shape, and transform their data—it’s literally done within a click of a button.”

Dimitar Shutev

Worked at Amadeus, DXC Technology

Power Query and Data Modeling

with Dimitar Shutev

Start Course