1 / 24

Business Intelligence (BI)

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.

amaris
Télécharger la présentation

Business Intelligence (BI)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence (BI) PerformancePoint in SharePoint 2010 • Sayed Ali – SharePoint Administrator

  2. Agenda Defining Business Intelligence Introducing PerformancePoint Services 2010 BI Architecture Demo Multidimensional Database Questions & Thank you

  3. 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

  4. Continued Defining Business Intelligent Or put simply… It is the application of knowledge derived from analyzing an organization’s data to effect a more positive outcome

  5. Continued Defining Business Intelligent Or put even more simply… It transforms data into knowledge

  6. 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 Defining Business Intelligent Why?

  7. Web Apps CRM Finance BI Architecture Simple One Data Warehouse Multidimensional Database User Access Client Access ETL Integration Services Analysis Services Data Sources

  8. ETL BI Architecture Data Warehouse Extract data from the source systems Transform the data to convert it to a desired state Load the data into the data warehouse

  9. Multidimensional Database Relational Database

  10. Continued Multidimensional Database Multidimensional Database

  11. 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 Multidimensional Database Multidimensional Database (Continued)

  12. Continued Multidimensional Database ADDING DIMENSIONS

  13. Introducing PerformancePoint Services 2010 Introducing the PPS Elements Monitoring Analytics

  14. Introducing PerformancePoint Services 2010 SharePoint PPS Fundamentals

  15. Introducing PerformancePoint Services 2010 Dashboard Designer

  16. Introducing PerformancePoint Services 2010 Data Source & KPI

  17. 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

  18. Introducing PerformancePoint Services 2010 Scorecard(Example) KPI Toolbar Metrics Hierarchy Variance Indicators

  19. Introducing PerformancePoint Services 2010 Report Element • Analytic Chart • Analytic Grid • Excel Services • KPI Details • ProClarity Analytics Server Page • Reporting Services • Strategy Map • Web Page

  20. Custom Table • MDX Query • Member Selection • Named Set • Time Intelligence (TI) • Time Intelligence Connection Formula Introducing PerformancePoint Services 2010 Filter Element

  21. 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

  22. 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

  23. Demo

  24. Thank You

More Related