Speaker Name SQL Server 2016 Comprehensive EnterpriseReady BI

[Speaker Name]

SQL Server 2016 Comprehensive, Enterprise-Ready BI Platform Pin paginated report items to Power BI dashboards Visualization Mobile and paginated reports Power BI Modeling Access Tabular ON-PREMISES Multidimensional on-premises data CLOUD

SQL Server 2016 Core Investment Areas in Analysis Services and Reporting Services Modern reports Mobile reports Enhanced analysis Rich tools Hybrid BI Share. Point 2016 support

One Semantic Model—Two Ways to Develop Tabular models Multidimensional models Tables and relationships Dimensions and measure groups Fast by design with in-memory Highly scalable and mature Easy to get started and simple Feature rich and complex

CLIENT TOOLS BI SEMANTIC MODEL Queries Data model Business logic Data access DATA SOURCES Use SSDT to create BI semantic models

SQL Server 2016 New Features

SQL Server 2016 Support by Edition

Resources https: //msdn. microsoft. com/en-us/library/bb 522607. aspx https: //msdn. microsoft. com/en-us/library/bb 522628. aspx https: //msdn. microsoft. com/en-us/library/cc 645993. aspx? #SSAS https: //blogs. msdn. microsoft. com/analysisservices/

Resources https: //technet. microsoft. com/en-us/virtuallabs

Web portal d mobile reports aginated report items ms. BItodashboards Power BI er Share. Point

SQL Server 2016 New Features

SQL Server 2016 Support by Edition Native mode only Share. Point mode only 1 2

Resources https: //msdn. microsoft. com/en-us/library/ms 159106. aspx https: //msdn. microsoft. com/en-us/library/ms 170438. aspx https: //msdn. microsoft. com/en-us/library/cc 645993. aspx? #SSRS https: //blogs. msdn. microsoft. com/sqlrsteamblog/

Resources https: //technet. microsoft. com/en-us/virtuallabs

Hybrid BI Comprehensive, Enterprise-Ready BI Platform Pin paginated report items to Power BI dashboards Visualization Mobile and paginated reports Power BI Modeling Access Tabular ON-PREMISES Multidimensional on-premises data CLOUD

Power BI Gateways

Azure Analysis Services

Resources https: //powerbi. microsoft. com/en-us/gateway/ https: //azure. microsoft. com/en-us/services/analysis-services/

Resources https: //technet. microsoft. com/en-us/virtuallabs

Summary • Analysis Services (multidimensional and data mining mode, and tabular mode) • Reporting Services

© 2016 Microsoft Corporation. All rights reserved. Microsoft, Windows, Microsoft Azure, and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION