what's new in sql server 2016 for bi
TRANSCRIPT
Most BI Still On Premises
Agenda• What's new in SQL Server 16 for BI
• SQL Server
• Integration Services and MDS
• Analysis Services
• Reporting Services
• … with demos
• Targeting SQL Server 2016 CTP 3.2 with
the usual disclaimer that things could
change without notice
• Update later on at Atlanta BI Group
• Out of scope• Power BI
• Self-service BI
• Q&A at the end of the presentation
About me• Consultant, author, and mentor with focus on BI
• Microsoft Most Valuable Professional for 12 consecutive years
• Founder and leader of Atlanta MS BI and Power BI Grouphttp://atlantabi.sqlpass.org
• Owner of Prologika – boutique BI consulting and training company based in Atlanta (www.prologika.com)• Microsoft Gold Partner in Data Analytics
• Services: analytics, strategy, training, talent acquisition
• Flexibility and quality
• Value-based, fixed pricing
6
SQL Server Report Builder
SQL Server Reporting Services
• Mobile reports
• Paginated reports
• Power BI Desktop (after SQL 16)
Power BI
• Power BI Desktop
• Microsoft Excel
• Mobile reports
• Paginated reports
Power BI Web Portal
Power BI Desktop
CONSUMEMANAGECREATE
Microsoft Excel
SQL Server Mobile Report Publisher (used to be Datazen)
Report Designer inSQL Server Data Tools
Windows App
Android App
iOS App
Report Server Web portal(all BI report types)
SharePoint Web
Database Engine
Database Engine
Columnstore indexesUpdatable nonclustered columnstore indexes
Query performanceLive query statistics and Query Store
Temporal tablesAutomatic Type 2 changes on all columns
Integration with RLet data scientists analyze data with R from SQL Server
with constraints by IT
SQL Server 16 Database EngineBI-related Enhancements
Integration Servicesand Master DataServices
SSIS Improvements at Glance
SQL Server 16 Integration ServicesIncremental Deployment &
Templates
Master Data ServicesModeling improvements in MDS
Simplified hierarchies
Improved MDS model deployment
Do more. Faster.Massive improvements to performance and scale in MDS
15x
Do more. Achieve more.
MDS transaction log retention settings
Multiple administrator roles
Granular security permissions in MDS
SQL Server 16 Master Data ServicesEntity Sync and Excel add-in
Multidimensional models in Analysis Services
Tabular models in Analysis Services
{
"name": “Demo Model",
"description": “Demo model description",
"culture": "en-US",
"dataSources": [
....
],
"tables": [
{
"name": "Customer",
"description": "Customer information.",
"columns": [
{
"name": "ID",
"dataType": "int64",
"sourceColumn": "customer_id",
"sortByColumn": "Last Name"
},
Multidimensional Enhancements
Visualize and explore existing models with
Power BI and Power BI Desktop
Support for Netezza as a data source
Customization options for drill-through
behaviors for actions
Drill-through multi-selection support with
Excel 2016
Dev / Ops in SQL Server 2016
SQL Server 16Analysis Services TabularMany to many relationships
Reporting Services
New, modern web portal
Modern chart and gauge styles
Updated Report Builder look-and-feel
Visual Studio 2015 support
Plugin-free printing
Modern paginated reports
Customizable parameter layout
Export to PowerPoint
Generate slides including all report
content in seconds
Move and resize individual objects
Export manually, schedule for email
delivery, or generate
programmatically
Monitor the most important
metrics and trends in one place
Pin charts, gauges, maps, and
images as tiles to Power BI
dashboards
Microsoft confidential - NDA Required
Responsive experiences for phones and tablets
SQL Server 16 Reporting ServicesReport Design Improvements
Connect to on-premises SQL
Server Analysis Services models
Support for Tabular and
Multidimensional models
Summary• Significant BI investments in SQL 16
• On-premises
• Cloud
• For more information• [email protected]
• Twitter: @tlachev
• Subscribe to my newsletter at
www.prologika.com
• Follow blog on
http://prologika.com/cs/blogs