Data Extraction with Power Query

PowerQueryBookThis course will teach you how you can use Power Query to load data into Excel when building a self-service BI solution, and what advantages it offers over traditional methods of data loading.

Prerequisites

  • This course is aimed at Excel users and BI professionals who want to learn how to use Power Query to load data into Excel and use it with Power Pivot and the rest of the Power BI stack.
  • A laptop with Excel 2013 and Power Query installed

Agenda

  • Understanding where Power Query fits in with the rest of the Power BI stack
  • Extracting data with Power Query: relational databases, text files, OData feeds and more
  • Creating Power Query transformations in the user interface
  • Loading data to Excel tables and the Excel Data Model/Power Pivot
  • Writing expressions and queries in M
  • Working with multiple queries and data sources, and understanding data privacy settings
  • Sharing queries via the Power BI Data Catalog

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 2017 Orange Man · RSS Feed · Log ind · Google+

Organic Themes