1 / 15

What’s New in Azure Analysis Services

What’s New in Azure Analysis Services. Christian Wade, Senior Program Manager. Demo: Azure Analysis Services user experience. Christian Wade. Azure Analysis Services Enterprise grade analytics engine as a service. Gain insights at the speed of thought

rudym
Download Presentation

What’s New in Azure Analysis Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s New in Azure Analysis Services Christian Wade, Senior Program Manager

  2. Demo: Azure Analysis Services user experience Christian Wade

  3. Azure Analysis Services Enterprise grade analytics engine as a service Gain insights at the speed of thought Gain instant insights with in-memory cache using your preferred visualization tools Provision and scale with ease Easy to deploy, scale, and manage as platform-as-a-service Build rich semantic models Transform complex data into business user friendly semantic models Proven technology • Based on powerful, proven SQL Server Analysis Services

  4. Azure Analysis Services Architecture Cloud data sources Cloud visualization tools Azure Analysis Services SQL Database Other data sources DirectQuery DAX Power BI Import MDX SQL Data Warehouse Gateway On-premises data sources Authoring and development tools On-premises visualization tools Other data sources Excel Visual Studio SQL Server DirectQuery Import Third partyBI tools Power BI Desktop Oracle, Teradata Note: not all capabilities available at public preview

  5. Demo: automation, monitoring & scale in Azure Christian Wade

  6. Demo summary • Server provisioning • Create model & refresh data • Application service principals • Azure Automation • Scale up/out • Diagnostic logging

  7. Engine Events

  8. Service Events

  9. 1200 Compatibility LevelAzure Analysis Services / SQL Server Analysis Services 2016 • Performance and scalability • Parallel partition processing • NUMA awareness and memory allocator (SP1) • Super DAX • Developer Tools • Tabular Model Explorer • Integrated workspace server • DAX formula editing • Modeling and analytics • Bi-directional cross filters • Calculated tables • Display folders • Translations • Over 50 new DAX functions • DirectQuery enhancements • Manageability • Tabular Object Model (TOM) • Tabular Model Scripting Language (TMSL)

  10. 1400 Compatibility LevelAzure Analysis Services / SQL Server Analysis Services 2017 • Data connectivity • Rich set of data sources • Data transformations and mashups with Power Query Formula Language • Modeling and analytics • Detail Rows • Object level security • Enhanced support for ragged hierarchies • Developer tools • SSDT for VS 2017 • DAX Editor for SSDT and SSMS

  11. Demo: modeling & analytics Christian Wade

  12. Just like Jimi Hendrix …  We love to get feedback Please complete the session feedback forms

  13. SQLBits - It's all about the community... Please visit Community Corner, we are trying this year to get more people to learn about the SQL Community, equally if you would be happy to visit the community corner we’d really appreciate it.

  14. Session resources • Azure BI Blog: https://aka.ms/AzureBIBlog • AS Team Blog: https://aka.ms/ASTeamBlog • Twitter: @_christianWade • ALM for Analysis Services (BISM Normalizer): https://aka.ms/ALMForAS

More Related