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