1 / 30

SCOM / BI – Dashboard Integration

SCOM / BI – Dashboard Integration. Bernd Schneider Technical Solution Professional - BI Microsoft Schweiz. Agenda. Solution Overview and Architecture Collect the Source Data Operations Manager Data Warehouse SQL Server Integration Services Build the Cube SQL Server Analysis Services

issac
Download Presentation

SCOM / BI – Dashboard Integration

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. SCOM / BI – Dashboard Integration Bernd Schneider Technical Solution Professional - BI Microsoft Schweiz

  2. Agenda • Solution Overview and Architecture • Collect the Source Data • Operations Manager Data Warehouse • SQL Server Integration Services • Build the Cube • SQL Server Analysis Services • Put it all Together • SharePoint Server 2007 & PerformancePoint Server 2007 • Solution Walk-Through & Creating SCOM Dashboards

  3. You Can Do More With Your SystemCenter Data! • Integrated (balanced) view of IT Performance • Roll up disparate metrics in a single scorecard – Server capacity, Transactions, SLA measurement • Ad-hoc analytics • Help determine root cause for usage spikes, application downtime • Predictive analytics • What will my capacity needs look like next year? • Leverages existing infrastructure • SQL Server, Operations Manager, SharePoint, Office

  4. Scorecardsand Dashboards Monitor State Detail Daily Trends Hourly Data Availability Metrics Performance Counters

  5. Root-cause Analysis andTrending

  6. Microsoft BI Offering* DELIVERY COLLABORATION CONTENT MANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services * Technical productline

  7. Thissolution DELIVERY COLLABORATION CONTENT MANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services

  8. SQL Server Analysis Services Advantages • “Sandbox” environment for business users to: • Formally integrate data from other systems • View data models that reflect how the business side sees the world (custom hierarchies, new groupings, friendly naming, calculations) • Consume “temporal” or one-off data models • Provides an ad-hoc experience optimized for end-user query performance, trending and drill-down analysis • Ad-hoc queries and frequent monitoring of KPIs will not load down the transactional database

  9. MOSS/PPS Integration • Interactive dashboards in SharePoint • Linked filters, scorecards, and analytics (keep everything in-context) • Scorecards • Aggregate disparate metrics on a single scorecard, or “balanced scorecard” • Measure and monitor data from virtually any tabular (Excel, ODBC) or multi-dimensional data source (SSAS) • Flexible, user-defined KPI targets, thresholds, and scoring • Trend analysis

  10. Solution Architecture

  11. Operations Manager Data WarehouseFacts & Dimensions Alerts Events Entities Performance State

  12. SQL Server Analysis Services • Data Source View • UDM structure • Measures • Dimensions • Calculations

  13. Data Source View • Diagrams of star schemas – state cube, perf cube

  14. Measure Groups • State • Amount of time that monitors are in a particular state, and percent of total • Performance Counters • Average, minimum, and maximum performance counter values • Standard deviation

  15. Entity Monitors Dimension Hierarchy and attributes for availability, health, and performance monitors • Top Level Group • • Type • • • Path • • • • Entity Name • • • • • Monitor Name

  16. Performance Counters Dimension Hierarchy and attributes for entity performance counters (% free space, CPU, etc.) • Top Level Group • • Type • • • Path • • • • Object Name • • • • • Instance Name • • • • • • Counter Name

  17. State Dimension Monitor states, grouped by up/down time. Default monitor grouping may be re-configured with a T-SQL CASE statement. • Up Down Key • • State Description

  18. Time and Date Dimensions Calendar dates and hours of day, with separate attributes for time-folded analysis (values by hour for the past week, for example) • Date by Month (Year, Quarter, Month, Date) • Date by Week (Year, Week, Date) • Time (Hours, in 12 hour or 24 hour format)

  19. Period Calculations A dimension that contains dynamic, time-based calculations • Month-to-date • Quarter-to-date • Year-to-date • Prior Period • Year-to-date, Prior Year • Percentage change

  20. PPS Dashboard Designer

  21. Creating SCOM Dashboard demo

  22. Demo Flow • Navigation through SCOM Dashboards • Dashboard Designer walkthrough • Create SCOM Dashboard • Datasource • KPI „Availability” • KPI „Disk free space” • Scorecard and Objective KPI • Analytic Grid „Performance Counter“ • Analytic Chart „Disk freespacetrendline“ • Dashboard Deployment

  23. Conclusion We have… • Discussed the need for IT Operations scorecards, dashboards, analytics • Discussed building an Analysis Services cube • Created Key Performance Indicators (KPIs), scorecards, dashboards, and analytic reports

  24. More Possibilities • Data Mining Add-In for Excel • Event correlation! • Data-driven diagrams with Visio • Show KPI status in a topology diagram • Predictive trend lines with PerformancePoint Trend Charts • More…

  25. More information • SQL Server Datawarehouse Overviewhttp://technet.microsoft.com/en-gb/sqlserver/dd421879.aspx • PerformancePoint Webhttp://www.microsoft.com/business/performancepoint/ • SCOM/PPS Whitepaper & Sampleshttp://www.microsoft.com/business/performancepoint/downloads/default.aspx • Operations Manager Report Guidehttp://blogs.technet.com/momteam/archive/2008/02/26/operations-manager-report-authoring-guide.aspx

  26. Your MSDN resourcescheck out these websites, blogs & more! PresentationsTechDays: www.techdays.chMSDN Events: http://www.microsoft.com/switzerland/msdn/de/presentationfinder.mspxMSDN Webcasts: http://www.microsoft.com/switzerland/msdn/de/finder/default.mspx MSDN EventsMSDN Events: http://www.microsoft.com/switzerland/msdn/de/events/default.mspxSave the date: Tech•Ed 2009 Europe, 9-13 November 2009, Berlin MSDN Flash (our by weekly newsletter)Subscribe: http://www.microsoft.com/switzerland/msdn/de/flash.mspx MSDN Team BlogRSS: http://blogs.msdn.com/swiss_dpe_team/Default.aspx Developer User Groups & CommunitiesMobile Devices: http://www.pocketpc.ch/Microsoft Solutions User Group Switzerland: www.msugs.ch.NET Managed User Group of Switzerland: www.dotmugs.chFoxPro User Group Switzerland: www.fugs.ch

  27. Your TechNet resourcescheck out these websites, blogs & more! PresentationsTechDays: www.techdays.ch TechNet EventsTechNet Events: http://technet.microsoft.com/de-ch/bb291010.aspx Save the date: Tech•Ed 2009 Europe, 9-13 November 2009, Berlin TechNet Flash (our by weekly newsletter)Subscribe: http://technet.microsoft.com/de-ch/bb898852.aspx Schweizer IT Professional und TechNet BlogRSS: http://blogs.technet.com/chitpro-de/ IT Professional User Groups & CommunitiesSwissITPro User Group: www.swissitpro.chNT Anwendergruppe Schweiz: www.nt-ag.chPASS (Professional Association for SQL Server): www.sqlpass.ch

  28. Save the date for tech·days nextyear! 7. – 8. April 2010Congress Center Basel

  29. Premium Sponsoring Partners Classic Sponsoring Partners Media Partner

More Related