PerformancePoint Services using a SQL 2012 BI Semantic Model

Agenda

     RDA – Who We Are PerformancePoint Services Overview New SSAS Model – BI Semantic Model Demo       BISM Model Querying the BISM Database in Management Studio Create a PPS Data Connection to the BISM Database Build PPS Objects – Reports, Filters, Scorecards Create\Deploy Dashboard Interact with Dashboard Additional Info © 2012 RDA Corporation. All rights reserved.

Who is RDA?

 Great people  Thought leaders   .NET Application Development Enterprise Application Integration   Business Intelligence Communication and Collaboration   Know how and what to communicate  Interpersonal skills Technical experience     100 full time, highly experienced specialists Invest > $1 million in training 1,100+ technical certifications Average 14 years of industry experience © 2012 RDA Corporation. All rights reserved.

BI Thought Leadership

RDA’s BI Council

Chuck Rivel Rich Cargile

RDA’s BI Practice Group and Blog

Recent Titles from RDA’s BI Blog Creating a Performance Dashboard using a SQL 2012 SSAS Tabular Instance Best Practices to create Effective User Experience Dashboards Lifecycle of the Corporate Information Factory Developing Tabular Models in SQL Server Data Tools Using FOR XML PATH to Combine Multiple Records Values into One Column Database Partitioning with the Entity Framework

Jim Klein Ray Barley

30+ RDA Consultants belong to our BI Practice Group

© 2012 RDA Corporation. All rights reserved.

Microsoft Business Intelligence

© 2012 RDA Corporation. All rights reserved.

Microsoft SharePoint 2010

the web INSIGHTS

Performance Point Services Excel Services Visio Services Chart Web Parts & Status Indicators Business Connectivity Services

PerformancePoint Services

 Context-driven dashboards across systems  Provides transparency and accountability  Interactive access using browser  Can be created/updated by power users & IT professional © 2012 RDA Corporation. All rights reserved.

Dashboard Designer

 Aggregate Data Sources and Content to create rich, dynamic, and context-drive dashboards  Create content once and reuse across Dashboards  One-click deploy and publish  Common infrastructure within SharePoint © 2012 RDA Corporation. All rights reserved.

BI Semantic Model

 New Version in SQL 2012 for SSAS  Development can be done in Visual Studio or Excel Power Pivot  Uses the xVelocity Engine for Calculations  Data Source for Power View © 2012 RDA Corporation. All rights reserved.

DEMO

© 2012 RDA Corporation. All rights reserved.

Additional Info

 SQL Server Blog: http://blogs.technet.com/b/dataplatforminsider  SharePoint Business Intelligence TechCenter http://technet.microsoft.com/en us/sharepoint/ee692578.aspx

 RDA Blog http://rdacorp.com/blog  SharePoint 2010 Business Intelligence Unleashed © 2012 RDA Corporation. All rights reserved.