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
© Copyright 2024