Data loading and manipulation with Power Query

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

chriswebb

Trainer

Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of “Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”, and blogs at http://cwebbbi.wordpress.com/

Copyright 2018 Orange Man · RSS Feed · Log ind · Google+

Organic Themes