100 likes | 199 Views
System Center Reporting Through the BI Stack. Agenda. General Overview System Architecture Data Architecture SharePoint Site Architecture Demo Questions. General Overview. The Microsoft BI Stack enhances reporting from System Center.
E N D
Agenda • General Overview • System Architecture • Data Architecture • SharePoint Site Architecture • Demo • Questions
General Overview • The Microsoft BI Stack enhances reporting from System Center. • We will layout the advantages of using the BI Stack included in SharePoint 2013 and SQL 2012 to build very comprehensive dashboards.
System Architecture Server Architecture Software Microsoft SQL 2012 Database service Analysis Service SharePoint 2013 Application service PowerPivot service Excel service SQL Reporting Service Visio Service • Database servers • SharePoint content • Data Mart • Tabular databases • SharePoint servers • Foundation Server • Application Server
Data Architecture Service Manager DW IT Data Warehouse Warranty information Hardware Details User Information (HR System load) Network Architecture (Infoblox) • Configuration Manager Cube • Operations Manager Cube SSAS Tabular • Hardware / Software Tabular
SharePoint Site Architecture Site Settings PowerView Library Can have multiple per site Organize by data being analyzed Security by User or Group • Performance Point Services • PowerPivot Services • Excel Services • SQL Reporting Services • BI Data Services • Add BI Semantic Model content type to Library Settings
Contact Info • Kim Hughes – Kim.Hughes@live.com • John Parker – Parker155@Hotmail.com