Transcript SQL Reporting Services SharePoint PerformancePoint Excel

Create a stunning dashboard and
keep your job
Patrik Sundqvist
Patrik Sundqvist
[email protected]
www.gridpro.se
Agenda
Goal
SQL Reporting
Services
Excel
PerformancePoint
Excel Services
Ways of getting
there…
Data Warehouse
OLAP Cubes
Goal
 Learn about options for creating a System Center dashboard
 Learn how we can observe trends in the data warehouse
 Learn how to find possible savings
 Learn how to achieve transparency
Ways of getting there
 SQL Reporting Services
 SharePoint PerformancePoint
 Excel Workbook (PowerPivot)
SQL Reporting Services
 Online
 Static
 Scheduled
 Near real time
 Database near development = Complex
Excel and Excel Services
 Self-Service BI
 Portable - “Analytics on-the-go”
 Analytics Library
 PerformancePoint
 Familiar tool!
SharePoint PerformancePoint
 Requires SharePoint 2010/2013
 Score Cards, KPIs, Reports, Dashboards, Excel Services
 Secure Storage Service
 Interactive – Drilldown, Filter, Connected parts
 One-stop-shop for BI
Data Warehouse
 Offline Data Store
Doesn’t impact performance
 Long Term Storage
Online data store is faster since there is less data to query
 High Volume Storage
Storage for multiple SM instance + other data from the rest of System Center
 Optimized Storage
Data is stored in a format optimized for fast querying
 Extensible Storage
Store any kind of data from anywhere
Online Analytic Processing Cubes
“Pros”
 Optimized for large read transactions
 Optimized for analyzing data from multiple perspectives
 Pre-calculated
 Predefined elements to slice and dice
 Self-Service BI
“Cons”
 Resource demanding update process
 Slower refresh rate
Demo
Reporting Services, PerformancePoint Dashboard, Excel with PowerPivot,
Analytic Library, Excel Services
www.gridpro.se
[email protected]
B
blogs.litware.se
#gridpatrik
UTVÄRDERING
KVÄLLSMINGEL
 Fyll i utvärderingen så att vi kan bli ännu
bättre till nästa gång!
 Antigen via länken du fick med din
biljett eller vid någon av datorerna i
TrueSec:s monter
 Best of MMS avslutas med ett gigantiskt
mingel på närliggande Dubliner direkt
efter dagens sista session!
 Tävla samtidigt om en HP Elitepad 900
(Vinnaren presenteras i Utställarfoajén
direkt efter sista sessionen).
 Microsoft och LabCenter bjuder på god öl
och ett unikt tillfälle för experter,
branschkollegor och eventdeltagare att
mingla tillsammans.
 Vi ses väl där?