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.
Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is 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", and blogs at http://cwebbbi.wordpress.com/