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.
Power Query and Data Modeling
with
Dimitar Shutev
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 Video
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
- Intro to Power Query18 Lessons 115 Min
We will cover some of the most common data transformations inside Power Query, such as importing data from multiple sources, replacing and extracting values, merging columns, and removing columns and duplicates. You will also learn all about filters, date functions, conditional columns, pivoting and unpivoting, merging tables, parameters, query properties, data profiling, web scraping, and mathematical functions.
What is Power Query FreeImporting Data FreeData Types FreeReplacing ValuesMerge ColumnsExtract ValuesRemove DuplicatesRemove ColumnsFiltersDate FunctionsConditional ColumnsUnpivotMerge QueriesParametersQuery PropertiesData ProfilingWeb ScrapingMathematical Functions - Data Modeling3 Lessons 23 Min
Data comes in all sizes, shapes, and forms. By default, it is often disorganized, difficult to analyze, and may contain information that is not required for our reporting needs. This is why we need to perform data modeling to transform and reshape our data.
Data modelingRelationshipsRole Level Security
Student feedback
Filter by rating
- 5 stars
- 4 stars
- 3 stars
- 2 stars
- 1 stars
Sort
- Newest
- Oldest
- 1
- 2
- 3
- ...
- 7
- ...
- 13
“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.”
Worked at Amadeus, DXC Technology
Power Query and Data Modeling
with Dimitar Shutev