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