Microsoft Excel Power Query
|Target group:||Users who require comprehensive data analysis|
|Target:||Automated data queries and transformations for the creation of regular reports|
|Prior knowledge:||Good basic knowledge of Excel, understanding of data structure|
|Content:||Introduction to Power Query|
Power Query is a data query tool that allows you to access external data sources (SQL Server, Oracle, SAP Hana, etc.) to load data in the form of query results into the spreadsheet or data model of an Excel workbook. While querying the external data sources, their data can be filtered, ordered as well as “cleaned” without changing the data source.