You are previewing Business Intelligence for the Enterprise.
O'Reilly logo
Business Intelligence for the Enterprise

Book Description

Making business intelligence work: Start-to-finish guidance for managers

This book offers a true enterprise view of business intelligence. IBM expert Mike Biere shows managers how to create a coherent BI plan that reflects the needs of users throughout the organization-and then implement that plan successfully. Biere explains how to objectively assess the business case for BI, and identifies proven solutions for the obstacles that lead many BI projects to fail. Coverage includes:

  • Setting appropriate expectations and goals for your BI project

  • Understanding how the key components of a complete BI solution fit together

  • Designing effective BI solutions-including content management, handling unstructured data, and end-user segmentation

  • Providing effective support for BI end users

  • Introducing Corporate Performance Management (CPM): an executive's view of BI

  • Previewing tomorrow's "next wave" in BI solutions

  • Comprehensive checklists for planning your BI project

Table of Contents

  1. Copyright
    1. Dedication
  2. IBM DB2 Certification Guide Series
  3. 1. Introduction to Business Intelligence
  4. 2. Defining Business Intelligence
    1. Query Tools
      1. The RFI/RFP Factor
    2. Data Warehouse Processes
    3. BI Biases and Internal Squabbles
    4. Establishing a More Global BI Perspective
    5. BI at the Business Unit and Departmental Levels
    6. BI at the Enterprise Level
    7. Hindsight “Rules”
    8. Intranets/Extranets—Data and Analysis Within You and Without You
    9. Know Your User Base
  5. 3. The History of Business Intelligence
    1. The Early End-User Computing Era
    2. The Information Center Era
    3. Charge-Back Systems
    4. Personal Computers
    5. The Client/Server Wave
    6. The Information Warehouse Concept
    7. The Data Warehouse Era of BI
    8. Advanced Analytics: Delivering Information to “Mahogany Row”
    9. BI Milestones
  6. 4. The Impact of Business Intelligence
    1. The IT Department and Business Intelligence
    2. Non-Technical End Users and Business Intelligence
    3. Business Analysts and Business Intelligence
    4. External End Users—The Extranet Environment
    5. Business Intelligence and the Enterprise
  7. 5. Content Management and Unstructured Data
    1. Industry-Related Content Management Areas
    2. Why a Relational Database Can't Solve This
  8. 6. End-User Segmentation
    1. End-User Segmentation
    2. End-User Attributes
    3. A Holistic View of the Users
  9. 7. Elements of Business Intelligence Solutions
    1. Data Warehouse versus Data Marts
    2. Setting Up Information for BI Processing
    3. Data Extraction, Transformation, and Cleansing
    4. The Data Side of BI
    5. The Analytics Tools
    6. End-User Assumptions about Tools
    7. The Spreadsheet's Role in BI
    8. The Three Major Categories of BI Analytics Tools
    9. Query and Reporting Tools
    10. Time and Date Elements in Reporting
    11. OLAP Tools
    12. Data Mining Tools
    13. Advanced Analytics—Executive Information Systems (EIS)
  10. 8. Justifying Business Intelligence Solutions
    1. ROI: Return on Investment
    2. Business Impact Justification
    3. The True Costs of BI
    4. Big Purchase with No Plan
    5. Bringing in the “Hired Guns”
    6. Your Justification Scenario
  11. 9. Corporate Performance Management (CPM) and the Executive View of Business Intelligence
    1. Data Readiness and Availability for CPM
    2. Role-Based Analytics
    3. Pushing Information: Proactive BI—Effective Communication
    4. Buy or Build CPM
    5. A Viable Approach to CPM
  12. 10. Platform Selection, Technology Biases, and Other “Traps”
    1. Traditional IT Traps
    2. The BI Trap
    3. Evaluating Analytics Usage for User Populations
    4. The Database Is the Most Critical Choice
    5. How Well Do Your Approved BI Tools Support the Database Decision?
    6. A “Typical” History Lesson
  13. 11. End-User Support and Productivity
    1. BI Products Are Still Computer-Based
    2. A “Straw Person” Scenario
    3. Setting Up BI Support
      1. Internal Support Issues
      2. Vendor Support Issues
      3. Internal Support Issues Addressed
      4. Vendor Support Issues Addressed
  14. 12. Implementation for Business Intelligence Solutions
    1. Back Up and Restore What You Have Already Done
    2. System Sizing, Measurements, and Dependencies
    3. Setting Early Expectations and Measuring the Results
    4. End-User Provisos
    5. Recap the First Project, and Tune Your Support and Implementation Models
    6. OLAP Implementations
    7. Expanding BI Based on What You Now Know
    8. Establishing a BI Competency Center (BICC)
  15. 13. Planning for the Future—What's the Next Wave of Business Intelligence?
    1. Advanced Analytics
    2. Database Enhancements and BI
    3. Thinner and Thinner Clients
    4. Data Formats with BI Aspects
    5. Portals
    6. BI Networks
    7. Conclusion
  16. A. Checklist for BI Planning
    1. Corporate BI Strategy
    2. End-User Support Strategy
    3. Database and Tools Strategy
    4. Intranet and Extranet Strategy
  17. About the Author