ssrs and power bi - · pdf fileweb portal sharepoint embed sql server ... analytical reports...
TRANSCRIPT
THANK YOU TO OUR SPONSORSPLATINUM
GOLD SILVER
PARTICIPATING COMMUNITIESCLOUD PRO PT
About me – Wolfgang Strasser
Consultant
Software, Business Intelligence and DWH
SQL Server, SSIS, SSAS, SSRS, Power BI, Azure, …
SQL Pass Austria
SQLSaturday Vienna Organizer
@wstrasserwolfgang.strasser_AT_gmx.atworkingondata.wordpress.com
Changing Technologies, Change of Working Culture
Past, Present, Future
Productivity Today
Past Productivity
Tools
History of Business Intelligence
Change in Usage Types: Mobile
Professionals Only Professionals & Consumers
The World Of Data is Changing
State of the Union..
- More and more data
- Number of Mobile User growths
- System complexity increases
- Reporting needs change- from lists to self-service
- from PC to tablet, mobile, smartwatches
- from reports to data stories
- Reporting gets faster- Real-Time Reporting
- Alerting
More Data
Mobile users
Complexity
Changes
Pace
Microsoft Reporting
SSRS History
Quo vadis SSRS?
But…
https://blogs.technet.microsoft.com/dataplatforminsider/2015/10/29/microsoft-business-intelligence-our-reporting-roadmap/
http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=40378http://www.gds-business-intelligence.de/de/2016/03/29/was-gibts-neues-bei-den-reporting-services-2016/
https://workingondata.wordpress.com/category/ssrs/
Reporting Roadmap
• On-Premises Enterprise applications & databases
• Websites , Mobile Apps, Social Media, SaaS applications
• Internet of ThingsData Origin
• Standard Reports, Self-Service, Mobile, KPIs, ..Diverging Reporting
Requirements
• Cloud ParityHarmonization of Cloud Reporting
• “One-Stop Shop”
• Report Portal
Focus on SQL Server Reporting Services
Report Types
Power BI
Interactive Reports
Excel
Spreadsheet
Report Builder / VS
Paginated Reports
Mobile Reports
Mobile Reports
Power BI
• Power BI Desktop
• Microsoft Excel
• Mobile reports
• Paginated reports
Prepare
CLOUD
PIN PAGINATED REPORTS
SQL Server Reporting Services
• Power BI Desktop
• Mobile reports
• Paginated reports
ON-PREMISES
Power BI Web Portal
Use
MOBILE APPS
Windows App
Android App
iOS App
Web portal
SharePointEMBED
SQL Server Report Builder
Power BI Desktop
POWER BI Reports
Analyse & Prepare
ANALYTICAL Reports
Microsoft Excel
MOBILE Reports
SQL Server
Mobile Report Publisher
PAGINATED Reports
Report Designer inSQL Server Data Tools
The Future of MS Reporting
Reporting Portal
SSRS Styler
• https://github.com/Frank-Geisler/SSRS_Styler
Power BI Evolution
Power BI v1
• Excel Add-Ins
Power BI v2
• powerbi.com
Power BI vNext
• On-Premises
Power BI Evolution (as of 2017-05)
Power BI v1
• Excel Add-Ins
Power BI v2
• powerbi.com
Power BI vNext
• On-Premises
Power BI Premium
• Dedicated ressources
• Power BI Report Server
Power BI Report Server
Current State SSRS (May 2017)
> SQL Server 2017 CTP 2.1Own SSRS Setup
SQL Server vNext (NO Update for SQL 2016)
January 2017 Technical Preview
Separation of Installation SSRS & DB-EngineNo DB-Engine required during SSRS installation
Power BI Reports on-premises
Compatible with SSRS (PBI Report Server = SSRS+)
Consume in multiple ways (browser, mobile app, embedded in apps)
Modern Lifecyle Policy (more frequent releases)
Power BI Premium
Power BI Premium
• https://powerbi.microsoft.com/en-us/power-bi-premium/
• Whitepaper• https://aka.ms/pbipremiumwhitepaper
Power BI Premium Capacities
Power BI Premium whitepaper v1a(as of 2017-05)
Power BIOn-Premises
PBI Report Server
Power BI On-Premises (PBI Report Server)Technical Preview
JAN 2017PBI
Report Server
Power BI Reports
Data Sources• Direct SSAS (MultiDim & Tabular)
Data Sources• Power Query Support• Cached Data, Scheduled Refresh
*
Custom Visuals
Power BI Mobile Apps
Power BI Dashboards
Q & A
Quick Insights
Edit report online
Power BI On-PremisesTest Drive
Azure VM TemplateIncl. sample reports, PBI Desktop, ..
SSRS Standalone Installer
Better TogetherHybrid Scenarios
Hybrid Scenarios
Better Together ?
It depends..
PaginatedReports
Interactive Reports
(Power BI)
Mobile Reports
Excel
Standard Reports / Lists
Pixel Perfect Reports
Self-Service BI
Mobile Reports
Export in Excel / PowerPoint
SSRS & Power BI – Better Together
Reporting Services as central reporting base“Cloud-Free Power BI”
License/Costs
Cloud und On-Premises parity“it takes some time”
“The right tool for each use case”
PLEASE FILL IN EVALUATION FORMSFRIDAY, MAY 19th SATURDAY, MAY 20th
https://survs.com/survey/cprwce7pi8 https://survs.com/survey/l9kksmlzd8
YOUR OPINION IS IMPORTANT!
THANK YOU TO OUR SPONSORSPLATINUM
GOLD SILVER