Monday, March 2, 2015

SCOM Dashboard created with PowerPivot

System Center Operations Manager (SCOM) is a cross-platform data center management system that provides health and performance monitoring of systems and services.

PowerPivot and Power View, included in Microsoft Excel 2013, is a first-class business intelligence (BI) tool that's capable of storing, processing, and visualizing vast amounts of data.

I developed a dashboard using these tools to collect data from the SCOM Data Warehouse, giving a birds eye view of client environments.  SQL queries underly all the information and it updates every few minutes.


This is the view displayed simultaneously overhead for every managed client and corresponds to alerts and scheduled reports which are sent to engineers and management from SCOM and SQL Server Reporting Services(SSRS).

No comments:

Post a Comment