scom bi dashboard integration l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SCOM / BI – Dashboard Integration PowerPoint Presentation
Download Presentation
SCOM / BI – Dashboard Integration

Loading in 2 Seconds...

play fullscreen
1 / 30

SCOM / BI – Dashboard Integration - PowerPoint PPT Presentation


  • 703 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SCOM / BI – Dashboard Integration' - issac


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
scom bi dashboard integration

SCOM / BI – Dashboard Integration

Bernd Schneider

Technical Solution Professional - BI

Microsoft Schweiz

agenda
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
you can do more with your systemcenter data
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
scorecards and dashboards
Scorecardsand Dashboards

Monitor State Detail

Daily Trends

Hourly Data

Availability Metrics

Performance Counters

microsoft bi offering
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

this solution
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

sql server analysis services advantages
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
moss pps integration
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
operations manager data warehouse facts dimensions
Operations Manager Data WarehouseFacts & Dimensions

Alerts

Events

Entities

Performance

State

sql server analysis services
SQL Server Analysis Services
  • Data Source View
  • UDM structure
    • Measures
    • Dimensions
    • Calculations
data source view
Data Source View
  • Diagrams of star schemas – state cube, perf cube
measure groups
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
entity monitors dimension
Entity Monitors Dimension

Hierarchy and attributes for availability, health, and performance monitors

• Top Level Group

• • Type

• • • Path

• • • • Entity Name

• • • • • Monitor Name

performance counters dimension
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

state dimension
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

time and date dimensions
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)
period calculations
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
demo flow
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
conclusion
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
more possibilities
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…
more information
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
y our msdn resources check out these websites blogs more
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

y our technet resources check out these websites blogs more
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

save the date for tech days next year

Save the date for tech·days nextyear!

7. – 8. April 2010Congress Center Basel

slide29

Premium Sponsoring Partners

Classic Sponsoring Partners

Media Partner