The Agenda

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