Advanced data loading in Power BI

This course will teach how to extract and load data in Power BI when you build a prototype or a self-service BI solution. The course is aimed at BI professionals and analysts who already have some experience with Power BI. The course is based on Power BI Desktop but the concepts can also be done in Excel with Power Query. There will be several hands-on labs.

Be sure to also check out the Introduction to Power BI and Advanced modelling in Power BI courses that is held in extension to this course.

Prerequisites

  • Attendees should bring along a laptop with Power BI Desktop.

Agenda

  • Using the built-in transformations
  • The M language
  • Writing expressions
  • Privacy levels
  • Parameters and functions
  • Sharing queries via the Azure Data Catalog
  • Working with multiple queries and data sources
  • Loading data to the Data Model

Trainer

Chris Webb is the owner of Crossjoin Consulting, and is a consultant specializing in Analysis Services, MDX, Power Query, Power Pivot 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 “Power Query for Power BI and Excel”, and blogs at https://blog.crossjoin.co.uk/

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

Organic Themes