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
Presented by Chris Webb at SQLBits XVI