Transcript demo title - Mostafa Absy

Business Intelligence (BI)
PerformancePoint in SharePoint 2010
Sayed Ali – SharePoint Administrator
Agenda
Defining Business Intelligence
Introducing PerformancePoint
Services 2010
BI Architecture
Demo
Multidimensional Database
Questions & Thank you
Defining Business Intelligent
– Gartner
Defining Business Intelligent
Continued
Or put simply…
It is the application of
knowledge derived from
analyzing an organization’s
data to effect a more positive
outcome
Defining Business Intelligent
Continued
Or put even more simply…
It transforms data into
knowledge
Defining Business Intelligent
Why?
• Variety of data systems, often in different formats
• Data systems may not:
Be optimized for analytical queries
 Manage historical context
 Be available or accessible

• Employees may not have sufficient skills, tools, or permissions
to query data systems
• Systems may not have universal definitions
• Decision makers need:
Reliable, secure access to data to do their job effectively
 Tools to browse and analyze data and view reports
 Low time-to-impact; low latency query results

BI Architecture
Simple One
Finance
CRM
Web Apps
Data Warehouse
Multidimensional
Database
User Access
Data Sources
ETL
Integration
Services
Analysis
Services
Client
Access
BI Architecture
Data Warehouse
1.
2.
3.
Extract data from the source systems
Transform the data to convert it to a desired state
Load the data into the data warehouse
ETL
Multidimensional Database
Relational Database
Multidimensional Database
Continued
Multidimensional Database
Multidimensional Database
Continued
Multidimensional Database (Continued)
• A user wants to know the Sales Volume figure when
CAR TYPE=SEDAN, COLOR=BLUE, and
DEALERSHIP=GLEASON.
• This is a maximum of 30 position searches for the array
versus a maximum of 1000 record searches for the
table.
• 3300% improvement in performance!
Multidimensional Database
Continued
ADDING DIMENSIONS
Introducing PerformancePoint Services 2010
Introducing the PPS Elements
Analytics
Monitoring
Introducing PerformancePoint Services 2010
SharePoint PPS Fundamentals
Introducing PerformancePoint Services 2010
Dashboard Designer
Introducing PerformancePoint Services 2010
Data Source & KPI
Introducing PerformancePoint Services 2010
Scorecard
• Depicts organizational performance by displaying a
collection of KPIs together with performance targets for
those KPIs
• Can be organized hierarchically using:
 Objectives and non-leaf KPIs
 Multi-level hierarchies
Introducing PerformancePoint Services 2010
Scorecard(Example)
KPI
Toolbar
Metrics
Hierarchy
Variance
Indicators
Introducing PerformancePoint Services 2010
Report Element
•
•
•
•
•
•
•
•
Analytic Chart
Analytic Grid
Excel Services
KPI Details
ProClarity Analytics Server Page
Reporting Services
Strategy Map
Web Page
Introducing PerformancePoint Services 2010
Filter Element
•
Custom Table
•
MDX Query
•
Member Selection
•
Named Set
•
Time Intelligence (TI)
•
Time Intelligence Connection Formula
Introducing PerformancePoint Services 2010
Dashboard Element
Dashboard pages consist of zones
Zones can be configured:



Name
Size
Orientation

Horizontal, Vertical, Stacked
Filters, Scorecards, and Reports are
added to the zones
Connections and display conditions are
configured between the items
Each page, when deployed, will
produce a Web Part page in
SharePoint
Introducing PerformancePoint Services 2010
Dashboard Element(Connection)
•
•
•
•
Filters send values
Scorecards receive and send values
Reports receive values
Different items have different values to send
Demo
Thank You