Power Query and Data Modeling

with Dimitar Shutev

4.8/5
(307)

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.

21 lessons 2h
Start course

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.

21 High Quality Lessons
1 Practical Tasks
2 Hours of Video
Certificate of Achievement

Skills you will gain

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

307 ratings
5 stars
256 (83%)
4 stars
46 (15%)
3 stars
5 (2%)
2 stars
0 (0%)
1 star
0 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
21.11.2022
Very good introduction to Power BI for someone who had zero experience to start with.
14.11.2022
awesome & perfect instructor I am so happy to learn power BI with this master
17.11.2022
All the lectures were too good, it was explained very clearly
17.11.2022
Thank you for the opportunity, its beyond my expectation!
18.11.2022
This course I love it so much, very nice courses.
  • 1
  • 2
  • 3
  • ...
  • 6
  • ...
  • 11

“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