Using M for data access in Analysis Services 2017 and Azure Analysis Services

When: Tuesday 10 July, 2018

Where: Tech Meetup Sapce - 8/9 Westmoreland Street

The biggest change in Analysis Services Tabular 2017 and Azure Analysis Services is the ability to use the M language and a Power Query-like UI to load data into your model. In this session you’ll learn why this is so important. Topics covered will include:* How the new functionality changes the way SSAS data loading works* New data sources that this supports* When you should transform data in M while loading and when you shouldn’t* Creating partitions* Migrating from Power BI to Analysis Services About Chris WebbChris Webb is an independent consultant and trainer ( specialising in Analysis Services and Power BI. 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”.