Visualizing System Center Data with PowerBI and PowerView

Visualizing Your System Center Data with
PowerView and PowerBI
Nathan Lasnoski
@nlasnoski
Concurrency
MMS Minnesota 2014
Goals of Business Intelligence… for you
• Get relevant data out
• Useful for audience
• Beautiful and touch-centric
• Easy to use for anyone
… sound like your reports / dashboards?
MMS Minnesota 2014
System Center BI Use Cases
Executive or IT Leadership:
• Service Availability and Cost
• Service Quality Dashboards
• Service Billing and Cloud Chargeback
Manager:
• Service Management Aging Report (Incident, SR)
• Change Management Statistics
• Availability Planning and Capacity
Analyst / Manager:
• Service Management Operations (Incident, SR)
• Change Management Advisory Boards (CAB)
• Configuration Data Relationships, ex. DSC configs
• Asset Data for Software, Service, and Hardware
MMS Minnesota 2014
Two Excellent Choices… and a demo
PowerView
• SharePoint 2013 on-premise
• Pulls data from analysis services or tabular model
• Easily refresh <5 minutes
• Silverlight only, no apps
PowerBI
• Office365 subscription with PowerBI
• Direct query and caches
• Automated refreshes <5 minutes
• HTML5 + Native Apps
MMS Minnesota 2014
System Center + PowerView Architecture
User Experience
Database Services
SQL Server Database
CMDB or DW
SharePoint DBs
Analysis Services
SQL Server Analysis
Tabular Configuration
Tabular Model
SharePoint 2013
Web + PowerView
System Center + PowerBI Architecture
User Experience
Database Services
SQL Server Database
Analysis Services
SQL Server Analysis
Tabular Configuration
Software
Gateway
CMDB or DW
Tabular
Model
(Future)
Office365 SharePoint
PowerBI
How to get the data…
• Existing Analysis Services Model
• SCSM DW Cubes
• SCOM DW Cubes
• Known Query to Data Warehouse
• SCSM and SCOM DW
• Known Query to Operational Database
•
•
•
•
•
•
SCSM Operational DB
SCCM Databases
SCOM Operational DB
SCCM Operational DB
VMM Operational DB
WAP Operational DB
MMS Minnesota 2014
Let’s do this! …on to the demo!
• Build out a PowerView on-premise environment
• Your first PowerView view of your incidents
• Give to your manager…
MMS Minnesota 2014
Let’s do this! …more demos!
• Sign-up for a free PowerBI trial
• Your first PowerBI view of your incidents
• Your first PowerQA site for your incidents
• Give to your manager…
… sound good?
MMS Minnesota 2014
Next Steps and Questions…
• Check out our online walkthrough and queries…
http://www.concurrency.com/infrastructure/system-centervisualization-powerbi-powerview/
• [email protected]
• @nlasnoski
MMS Minnesota 2014
Evaluations
Please provide session feedback by clicking the
Eval button in the scheduler app. One lucky
winner will get a free ticket to the next MMS!
Session Title
Platinum Sponsors:
Gold Sponsors:
Visit all of our sponsors in the expo area and online!
MMS Minnesota 2014