business intelligence (bi) performancepoint in sharepoint 2010 sayed ali – sharepoint...
TRANSCRIPT
![Page 1: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/1.jpg)
Business Intelligence (BI)PerformancePoint in SharePoint 2010
Sayed Ali – SharePoint Administrator
![Page 2: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/2.jpg)
AgendaDefining Business Intelligence
Introducing
PerformancePoint Services
2010
Demo
BI Architecture
Multidimensional Database
Questions & Thank you
![Page 3: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/3.jpg)
Defining Business Intelligent
“A broad category of applications and technologies for gathering, storing, analyzing, sharing and providing access to data to help
enterprise users make better business decisions.”
– Gartner
![Page 4: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/4.jpg)
Defining Business Intelligent
It is the application of knowledge derived from
analyzing an organization’s data to effect a more positive
outcome
Or put simply…
Continued
![Page 5: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/5.jpg)
Defining Business Intelligent
It transforms data into knowledge
Or put even more simply…
Continued
![Page 6: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/6.jpg)
Why?
Defining Business Intelligent
• 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
![Page 7: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/7.jpg)
BI Architecture
Simple One
Finance
CRM
Web Apps
Multidimensional Database
Data Sources
User Access
Data Warehouse
ETLIntegration Services
Analysis Services
Client Access
![Page 8: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/8.jpg)
BI Architecture
Data Warehouse
ETL
1. Extract data from the source systems2. Transform the data to convert it to a desired state3. Load the data into the data warehouse
![Page 9: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/9.jpg)
Multidimensional DatabaseRelational Database
![Page 10: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/10.jpg)
Multidimensional DatabaseMultidimensional DatabaseContinued
![Page 11: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/11.jpg)
Multidimensional DatabaseMultidimensional 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!
Continued
![Page 12: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/12.jpg)
Multidimensional DatabaseADDING DIMENSIONSContinued
![Page 13: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/13.jpg)
Introducing PerformancePoint
Services 2010
Introducing the PPS Elements
Analytics Monitoring
![Page 14: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/14.jpg)
SharePoint PPS Fundamentals
Introducing PerformancePoint
Services 2010
![Page 15: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/15.jpg)
Dashboard Designer
Introducing PerformancePoint
Services 2010
![Page 16: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/16.jpg)
Data Source & KPI
Introducing PerformancePoint
Services 2010
![Page 17: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/17.jpg)
Scorecard
Introducing PerformancePoint
Services 2010
• 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
![Page 18: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/18.jpg)
Scorecard(Example)
Introducing PerformancePoint
Services 2010
Toolbar
Hierarchy
Metrics
KPI
Indicators
Variance
![Page 19: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/19.jpg)
Report Element
Introducing PerformancePoint
Services 2010
• Analytic Chart• Analytic Grid• Excel Services• KPI Details• ProClarity Analytics Server Page• Reporting Services• Strategy Map• Web Page
![Page 20: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/20.jpg)
Filter Element
Introducing PerformancePoint
Services 2010
• Custom Table
• MDX Query
• Member Selection
• Named Set
• Time Intelligence (TI)
• Time Intelligence Connection Formula
![Page 21: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/21.jpg)
Dashboard Element
Introducing PerformancePoint
Services 2010
Dashboard pages consist of zones
Zones can be configured:
Name Size Orientation
Horizontal, Vertical, StackedFilters, 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
![Page 22: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/22.jpg)
Dashboard Element(Connection)
Introducing PerformancePoint
Services 2010
• Filters send values• Scorecards receive and send values• Reports receive values• Different items have different values to send
![Page 23: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/23.jpg)
Demo
![Page 24: Business Intelligence (BI) PerformancePoint in SharePoint 2010 Sayed Ali – SharePoint Administrator](https://reader036.vdocuments.us/reader036/viewer/2022062620/551bbabb550346b4588b4674/html5/thumbnails/24.jpg)
Thank You