Data loading and manipulation with Power Query

13.500 DKK

Ikke på lager


Power Query is the data loading engine inside Power BI (and also Excel 2016+ and SQL Server Analysis Services Tabular models), and M is the language behind Power Query. On this 3-day workshop you’ll get a comprehensive introduction to all of the functionality of the Power Query engine, including how to connect to data sources and output data in a format suitable for your Power BI dataset. You’ll also learn about the M language and also new features such as dataflows.


Day 1

  • Data loading and transformation basic concepts: Power Query, queries and steps
  • Connecting to different data sources: text files, Excel files, relational databases, web services and web pages
  • Using the UI to transform data and add new columns
  • Working with multiple queries
  • Best practices for loading data into Power BI

Day 2

  • Using parameters
  • Introduction to the M language
  • Using functions to combine data from multiple sources
  • Solving problems with M code
  • Taking advantage of query folding
  • Data privacy and the formula firewall

Day 3

  • Working with web services in M
  • Performance tuning and diagnostics
  • Using dataflows for advanced data preparation
  • Using Power Query in Microsoft Flow
  • Creating and using custom data connectors in M

Yderligere information


3 dage