The Power Query Formula Language
The Power Query Formula Language
Microsoft Power Query for Excel includes a powerful query engine and a formula language that enables self-service data integration and shaping over a diverse set of data sources, ranging from simple text files to Big Data and Hadoop. In this session, we will go beneath the UI and learn how to unlock the full power of the underlying query engine and the formula language. You will learn how to conquer your data and data-shaping needs.
Speakers:
Matt Masson is a Program Manager on the Power Query team. Matt has worked with multiple products across SQL Server, including SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS), and the Data Management Gateway for the Power BI release. He has authored two books -- SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press), and is a frequent presenter at SQL conferences. You can find his blog at http://www.mattmasson.com/.
Theresa Palmer is a Program Manager in the Microsoft SQL Server Information Services Group. She is currently working on Microsoft Power Query for Excel, which offers end user experiences around data discovery, data consumption, and data mashups.
Join PASS DW/BI Virtual Chapter at http://bi.sqlpass.org
Follow us on Twitter @PASSBIVC