Transcript PerformancePoint Services using a SQL 2012 BI Semantic Model

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
 Business Intelligence
 Enterprise Application
Integration
 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 Practice Group and Blog
Recent Titles from RDA’s BI Blog
RDA’s BI Council
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
Chuck Rivel
Rich Cargile
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/enus/sharepoint/ee692578.aspx
 RDA Blog http://rdacorp.com/blog
 SharePoint 2010 Business Intelligence Unleashed
© 2012 RDA Corporation. All rights reserved.