sql server 2016 ssrs and bi
TRANSCRIPT
SQL Server 2016What’s new in BI
Benjamin LerouxData Platform Solution Architect
SQL Server 2016
Visualization
Modeling
Power BI
Tabular Multidimensional
ON-PREMISES CLOUD
Mobile and paginated reports
Pin paginated report items to
Power BI dashboards
Access
on-premises data
Power BI
• Power BI Desktop
• Microsoft Excel
• Mobile reports
• Paginated reports
DELIVER
CLOUD
PIN PAGINATED REPORT ITEMS
SQL Server Reporting Services
• Power BI Desktop
• Mobile reports
• Paginated reports
ON-PREMISES
Power BI Web Portal
CONSUME
ONE SET OF MOBILE APPS
Windows App
Android App
iOS App
Web portal
SharePointEMBED
SQL Server Report Builder
Power BI Desktop
POWER BI REPORTS
ANALYZE & AUTHOR
ANALYTICAL REPORTS
Microsoft Excel
MOBILE REPORTS
SQL Server
Mobile Report Publisher
PAGINATED REPORTS
Report Designer inSQL Server Data Tools
Pin paginated report items
to Power BI dashboards
CONSUME
SharePoint
Web portal(paginated and mobile reports)
iOS App
Android App
Windows Phone App
ONE SET OF MOBILE APPS
SQL Server
Reporting Services
Native mode
Mobile Reports now a
component of SSRS
DELIVER
SQL Server 2016 Reporting Services
SQL Server
Reporting Services
SharePoint
integrated mode
MOBILE REPORTS
ANALYZE & AUTHOR
SQL Server
Mobile Report Publisher
PAGINATED REPORTS
SQL Server Report Builder
Report Designer inSQL Server Data Tools
SQL Server 2016
Enhanced analysis
Modern reports
Rich tools
Mobile reports
Hybrid BISharePoint 2016 support
SQL Server Reporting Services
Paginated reportsDesign beautiful documents using updated
tools and new features
Mobile reportsCreate responsive, interactive reports
optimized for mobile devices
New web portal Consume both types of reports in one web
portal using modern browsers
Modern paginated reports
Modern chart and gauge styles
Updated Report Builder
look-and-feel
Visual Studio 2015 support
Plugin-free printing
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
Pin report items to Power BI dashboards
Monitor the most important
metrics and trends in one place
Pin charts, gauges, maps,
and images as tiles to
Power BI dashboards
Pin report items to Power BI dashboards
Monitor the most important
metrics and trends in one place
Pin charts, gauges, maps,
and images as tiles to
Power BI dashboards
Pin report items to Power BI dashboards
Monitor the most important
metrics and trends in one place
Pin charts, gauges, maps,
and images as tiles to
Power BI dashboards
Create interactive mobile reportsResponsive experiences for phones and tablets
Consume mobile reportsNative apps for all major mobile platforms
One mobile app for Power BI and
SSRS mobile reports
Native mobile experience
optimized for touch
Keep data up-to-date with real-time
query or scheduled data refresh
Interact with mobile reports even
when disconnected
New, modern web portal for reports
Web APIs
Report server
database
Web portalWeb browsers
Power BI Mobile
Report Builder
Mobile Report Publisher
Visual Studio
SQL ServerSQL Server
Analysis Services
Oracle Teradata
ODBC, OLE DB More/custom
Processing and
rendering
Scheduling and
delivery
Email File share
SharePoint Power BI
Custom
REPORT VIEWING (PCs, mobile)
REPORT DESIGN (PCs)
REPORT SERVER DATA SOURCES
REPORT DELIVERY DESTINATIONS
Custom apps/LOB
Demo
SSRS complete list of new features
SSRS complete list of new features (Cont.)