Data transformation with Power Query
Is this course relevant and interesting for more managers within your company? We organize this course in-company. Ask about the possibilities.
One of the more tedious tasks in Analytics is preparing data for analysis. Power BI offers a powerful tool for loading and transforming data called Power Query or, simply, Query Editor. Power Query is also available in Excel as ‘Get and Transform’, the default mechanism to load external data in Excel 2016 and later versions. Moreover, the same techniques can be used in SQL Server Analysis Services, Azure Analysis Services, and in the Dataflows component of the Power BI cloud service. If you can work in Power BI with this tool, you can reuse your knowledge in the other tools as well!
Power Query is a data preparation technology, connecting data sources and analytical models. It is the new standard for transforming source data into a workable format. When properly used, your analytical models will perform better and can be easier maintained. In this two-day course, you will not only learn how to work with Power Query but to apply best practices as well, to get the most of the technology.
The aim of this training is to let you work effectively and efficiently with Power Query. This will enable you to create efficient and fast Power BI or Excel models. After this training:
- You know how to load data from different data sources into the Power BI data model.
- You are able to perform both simple and complex transformations on data.
- You can combine data from multiple sources.
- You know about the M language, the script language behind Power Query, and how to use it to optimize data transformations.
The training starts with a walk-through of Power Query. We explore the underlying principles of Power Query and discover the features of Power Query. With a lot of exercises, you will gain hands-on knowledge on working with Power Query.
- Extracting data from data sources with the Query Editor: files, databases, web sources and much more.
- Data transformations in the query editor.
- Custom columns, the M language, and advanced queries.
- Creating functions with M.
- Optimization techniques.
- Using Dataflows to reuse and share data transformation logic.