Business Intelligence with Microsoft® Office PerformancePoint™ Server 2007

Business Intelligence with Microsoft® Office PerformancePoint™ Server 2007

by Craig Utley
Released February 2008
Publisher(s): McGraw-Hill
ISBN: 9780071589437

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to live online training experiences, plus books, videos, and digital content from O’Reilly and nearly 200 trusted publishing partners.

Start your free trial

Book description

Deliver BI Solutions with Microsoft Office PerformancePoint Server 2007

Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monitor progress, analyze performance, distribute dynamic reports, and create maintainable projects and forecasts. Business Intelligence with Microsoft Office PerformancePoint Server 2007 provides full details on creating scorecards and dashboards, performing advanced analysis on data, and setting up business plans. You will also learn how to integrate PerformancePoint with ProClarity, Excel 2007, and SQL Server Reporting Services.

  • Configure, deploy, and secure all the PerformancePoint components
  • Create KPIs, scorecards, reports, and dashboards with the Dashboard Designer
  • Create business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007
  • Enable advanced data analysis with PerformancePoint Server and ProClarity tools
  • Take advantage of the enhanced analytic capabilities of Excel 2007
  • Use SQL Server Reporting Services for analytics
  • Align performance with organizational objectives

Table of contents

  1. Contents
  2. Acknowledgments
  3. Introduction
  4. Part I: Business Intelligence
    1. Chapter 1 The Case for Business Intelligence
      1. What Is Business Intelligence?
      2. The Consumers of Business Intelligence
      3. Delivering Data to Business Intelligence Consumers (1/2)
      4. Delivering Data to Business Intelligence Consumers (2/2)
      5. Real World Examples
      6. Summary
    2. Chapter 2 Introducing PerformancePoint Server 2007
      1. What Is PerformancePoint Server 2007? (1/2)
      2. What Is PerformancePoint Server 2007? (2/2)
      3. Summary
    3. Chapter 3 Data Warehousing and Business Intelligence
      1. Designing to Solve the Problem (1/2)
      2. Designing to Solve the Problem (2/2)
      3. Extracting, Transforming, and Loading Data
      4. Building Cubes (1/3)
      5. Building Cubes (2/3)
      6. Building Cubes (3/3)
      7. Delivering Data to Consumers
      8. Summary
    4. Chapter 4 Scorecards and Key Performance Indicators
      1. Key Performance Indicators (1/2)
      2. Key Performance Indicators (2/2)
      3. Scorecards and Dashboards (1/2)
      4. Scorecards and Dashboards (2/2)
      5. Summary
  5. Part II: Monitoring, Analysis, and Planning
    1. Chapter 5 Monitoring in PerformancePoint Server
      1. Data Sources and Scorecards (1/3)
      2. Data Sources and Scorecards (2/3)
      3. Data Sources and Scorecards (3/3)
      4. Creating and Modifying KPIs (1/4)
      5. Creating and Modifying KPIs (2/4)
      6. Creating and Modifying KPIs (3/4)
      7. Creating and Modifying KPIs (4/4)
      8. Reports and Strategy Maps (1/3)
      9. Reports and Strategy Maps (2/3)
      10. Reports and Strategy Maps (3/3)
      11. Dashboards—Putting it All Together (1/2)
      12. Dashboards—Putting it All Together (2/2)
      13. Summary
    2. Chapter 6 Analysis with PerformancePoint Server and ProClarity
      1. Analysis with PerformancePoint Server (1/6)
      2. Analysis with PerformancePoint Server (2/6)
      3. Analysis with PerformancePoint Server (3/6)
      4. Analysis with PerformancePoint Server (4/6)
      5. Analysis with PerformancePoint Server (5/6)
      6. Analysis with PerformancePoint Server (6/6)
      7. Analysis with ProClarity (1/10)
      8. Analysis with ProClarity (2/10)
      9. Analysis with ProClarity (3/10)
      10. Analysis with ProClarity (4/10)
      11. Analysis with ProClarity (5/10)
      12. Analysis with ProClarity (6/10)
      13. Analysis with ProClarity (7/10)
      14. Analysis with ProClarity (8/10)
      15. Analysis with ProClarity (9/10)
      16. Analysis with ProClarity (10/10)
      17. Summary
    3. Chapter 7 Planning Module in PerformancePoint Server
      1. Planning Administration Console (1/3)
      2. Planning Administration Console (2/3)
      3. Planning Administration Console (3/3)
      4. Planning Business Modeler (1/8)
      5. Planning Business Modeler (2/8)
      6. Planning Business Modeler (3/8)
      7. Planning Business Modeler (4/8)
      8. Planning Business Modeler (5/8)
      9. Planning Business Modeler (6/8)
      10. Planning Business Modeler (7/8)
      11. Planning Business Modeler (8/8)
      12. PerformancePoint Add-in for Excel (1/2)
      13. PerformancePoint Add-in for Excel (2/2)
      14. Summary
  6. Part III: Additional Tools and Security
    1. Chapter 8 PerformancePoint Deployment and Security
      1. Deploying PerformancePoint Server (1/2)
      2. Deploying PerformancePoint Server (2/2)
      3. Security Considerations for PerformancePoint Server
      4. Summary
    2. Chapter 9 Analysis with Excel 2007
      1. Performing Analysis with Excel 2007 (1/4)
      2. Performing Analysis with Excel 2007 (2/4)
      3. Performing Analysis with Excel 2007 (3/4)
      4. Performing Analysis with Excel 2007 (4/4)
      5. Summary
    3. Chapter 10 SQL Server Reporting Services
      1. Creating Reports with Reporting Services (1/5)
      2. Creating Reports with Reporting Services (2/5)
      3. Creating Reports with Reporting Services (3/5)
      4. Creating Reports with Reporting Services (4/5)
      5. Creating Reports with Reporting Services (5/5)
      6. Summary
  7. Index
    1. A
    2. B
    3. C
    4. D
    5. E
    6. F
    7. G
    8. H
    9. I
    10. K
    11. L
    12. M
    13. N
    14. O
    15. P
    16. Q
    17. R
    18. S
    19. T
    20. U
    21. V
    22. W
    23. X
    24. Y
    25. Z

Product information

  • Title: Business Intelligence with Microsoft® Office PerformancePoint™ Server 2007
  • Author(s): Craig Utley
  • Release date: February 2008
  • Publisher(s): McGraw-Hill
  • ISBN: 9780071589437