Creating Stunning Dashboards with Patrik Sundqvist
Explore various ways of creating a stunning dashboard using Excel, SQL Reporting Services, Data Warehouse, PerformancePoint, and Excel Services. Learn from Patrik Sundqvist how to achieve transparency, observe trends, and find possible savings.
- Uploaded on | 0 Views
-
reggina
About Creating Stunning Dashboards with Patrik Sundqvist
PowerPoint presentation about 'Creating Stunning Dashboards with Patrik Sundqvist'. This presentation describes the topic on Explore various ways of creating a stunning dashboard using Excel, SQL Reporting Services, Data Warehouse, PerformancePoint, and Excel Services. Learn from Patrik Sundqvist how to achieve transparency, observe trends, and find possible savings.. The key topics included in this slideshow are Patrik Sundqvist, dashboard, Excel, SQL Reporting Services, Data Warehouse, PerformancePoint, OLAP Cubes, system center, observe trends, transparency, find savings,. Download this presentation absolutely free.
Presentation Transcript
1. Create a stunning dashboard and keep your job Patrik Sundqvist
2. Patrik Sundqvist patrik.sundqvist@gridpro.se www.gridpro.se
3. Agenda Excel Excel SQL Reporting Services SQL Reporting Services Data Warehouse Data Warehouse PerformancePoint Excel Services PerformancePoint Excel Services OLAP Cubes OLAP Cubes Ways of getting there Ways of getting there Goal Goal
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 Store Doesnt 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
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 patrik.sundqvist@gridpro.se B B blogs.litware.se blogs.litware.se #gridpatrik #gridpatrik www.gridpro.se www.gridpro.se
13. UTVRDERING Fyll i utvrderingen s att vi kan bli nnu bttre till nsta gng! Antigen via lnken du fick med din biljett eller vid ngon av datorerna i TrueSec:s monter Tvla samtidigt om en HP Elitepad 900 (Vinnaren presenteras i Utstllarfoajn direkt efter sista sessionen). KVLLSMINGEL Best of MMS avslutas med ett gigantiskt mingel p nrliggande Dubliner direkt efter dagens sista session! Microsoft och LabCenter bjuder p god l och ett unikt tillflle fr experter, branschkollegor och eventdeltagare att mingla tillsammans. Vi ses vl dr?
