Loading And Transforming Data In Power BI And Power Query

Anyone who is serious about building BI and reporting solutions using Power BI or Excel needs to know how to load and transform data. This pre-con will focus on the “Get Data” functionality in Power BI that is also shared by Power Query and Excel 2016’s “Get & Transform” feature. You will learn how to use it to connect to multiple data sources and how to shape your data appropriately for Power BI/Power Pivot.

Topics covered will include:
  • Basic concepts
  • Differences between Power BI and different versions of Excel
  • Building a dimensional model - or not
  • Connecting to data sources
  • Using the Query Editor window to transform data
  • Working with multiple queries
  • Writing queries and calculations in the M language
  • Working with parameters and functions
  • Working with web services
  • Sharing queries with Azure Data Catalog
  • Making sure your queries refresh when they are deployed to PowerBI.com


Wednesday 5 April 2017