1 / 13

Create a stunning dashboard and keep your job

Create a stunning dashboard and keep your job. Patrik Sundqvist. Patrik Sundqvist patrik.sundqvist@gridpro.se www.gridpro.se. Agenda. Goal. Ways of getting there…. SQL Reporting Services. Excel. PerformancePoint Excel Services. Data Warehouse. OLAP Cubes. Goal.

sunila
Download Presentation

Create a stunning dashboard and keep your job

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Create a stunningdashboard and keepyourjob Patrik Sundqvist

  2. Patrik Sundqvist patrik.sundqvist@gridpro.se www.gridpro.se

  3. Agenda Goal Ways of getting there… SQL Reporting Services Excel PerformancePoint Excel Services Data Warehouse OLAP Cubes

  4. 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

  5. Ways of getting there • SQL Reporting Services • SharePoint PerformancePoint • Excel Workbook (PowerPivot)

  6. SQL Reporting Services • Online • Static • Scheduled • Near real time • Database near development = Complex

  7. Excel and Excel Services • Self-Service BI • Portable - “Analytics on-the-go” • Analytics Library • PerformancePoint • Familiar tool!

  8. 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

  9. Data Warehouse • Offline Data StoreDoesn’t impact performance • Long Term StorageOnline data store is faster since there is less data to query • High Volume StorageStorage for multiple SM instance + other data from the rest of System Center • Optimized StorageData is stored in a format optimized for fast querying • Extensible StorageStore any kind of data from anywhere

  10. 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

  11. Demo Reporting Services, PerformancePoint Dashboard, Excel with PowerPivot, Analytic Library, Excel Services

  12. patrik.sundqvist@gridpro.se B blogs.litware.se #gridpatrik www.gridpro.se

  13. UTVÄRDERING KVÄLLSMINGEL Best of MMS avslutas med ett gigantiskt mingel på närliggande Dubliner direkt efter dagens sista session! 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? • 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 • Tävla samtidigt om en HP Elitepad 900 (Vinnaren presenteras i Utställarfoajén direkt efter sista sessionen).

More Related