4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Matt Masson

Matt Masson is a Senior 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/

http://www.mattmasson.com/ http://www.mattmasson.com/feed/

This session shows off the new features of Microsoft SQL Server Integration Services in SQL Server code-named “Denali”.
This demo intensive session will show off the new features and enhancements designed to ease adoption for new users and increase productivity for experienced SSIS developers
The SQL Server 2012 release of SQL Server Integration Services (SSIS) includes a broad range of new capabilities designed to improve the deployment, management and monitoring of SSIS solutions. The core of these capabilities is the new SSIS Catalog.
Exposing the lighter side of Business Intelligence. If you've never been to a Power Hour session before then you will definitely shouldn't miss this one.

Blog posts RSS

Azure Machine Learning 02 Dec 2014
At the PASS Summit last month, I showed off an Azure Machine Learning model which predicted how well a conference session would do based on its title. The model was part of my BI Power Hour demo, and unlike my usual Power Hour demos about cats and ponies, it bordered on actually being useful. ...

Parsing Binary data using Power Query formulas 11 Nov 2014
The Power Query formula language (M) contains a number of library functions that allow you to parse binary data. You can use these functions to build queries which parse custom binary file formats. This post contains two samples – a simple query which parses X & Y coordinate values from a ...

Iterating over an unknown number of pages in Power Query 10 Nov 2014
My previous blog post showed how to iterate over a set of web pages in Power Query using a parameterized function. The post contained two queries – the GetData function, and a query to invoke it over a set number of pages. GetData function [crayon-54c9b33b92b1e874547281/] Query to invoke it ...

Iterating over multiple pages of web data using Power Query 10 Nov 2014
This is one of my go-to demos for showing off the Power Query Formula Language (M). This approach works well with websites that spread data over multiple pages, and have one or more query parameters to specify which page or range of values to load. It works best when all pages have the same ...

Converting a Query to a Function in Power Query 09 Nov 2014
You can turn a query into a function by adding a single line before your M query: () => That is a pair of parenthesis ( () ), followed by a goes-to symbol ( => ). Any parameters for your function would go in between the parenthesis. Example In the Query Editor, click on the … Continued