Power Query: Beyond The Basics

You already know that you can accomplish a lot within the Power Query user interface. If you are a data steward, however, you may be asked to deliver complex data sets in Power Query that require knowledge of advanced functionality, including the M language. This session will examine what these requirements
might be, how to implement them, and how best to deploy them to end users. 

In this session you will learn how to create common types of calculations and transforms in M, how to best use functions, how to work with multiple data sources, how to call web services, what the best practices for loading data into Power Pivot with Power Query are, and lots more. 
Presented by Chris Webb at SQLBits XII
  • Downloads
    Slide deck available Slide deck 238 KB
    Video available MP4 Video HD 557 MB
  • SpeakerBIO
    Chris Webb is an independent consultant specialising in Analysis Services, MDX, Power BI, Power Pivot and Power Query. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: 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". He blogs at http://blog.crossjoin.co.uk
    http://blog.crossjoin.co.uk http://feeds.feedburner.com/wordpress/Cpjz
  • Video