Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Structure
• Related Documents
• Oracle By Example Series
• Conventions

1 The Oracle Business Intelligence Solution

• What is Business Intelligence?
• • Business Intelligence and Transactional Data
  • Business Intelligence and Data Warehousing
  • Oracle Business Intelligence and Oracle Database
  • Oracle Business Intelligence Components
  • • Components for Structuring Data for Analysis
    • Components for Analyzing Data and Creating Reports
    • Components for Publishing and Interacting with Reports
    • Components for Building Custom Applications
• Answering Business Questions with Oracle Business Intelligence
• • How Is My Business Performing?
  • • Gauges
    • Conditional Formatting
    • Graphs
    • Sorting and Ranking
  • What Factors Are Influencing My Business?
  • • Displaying Exception Data
    • Interactive Drilling
    • Interactive Layout Changes
    • Data Mining: Attribute Importance
  • Where Is My Business Headed?
  • • Trend Analysis
    • Modeling and Planning
  • Where Should We Focus Our Efforts?
  • • What-If Analysis
    • Data Mining: Classification and Regression
    • Data Mining: Market Basket Analysis
  • Report Styles for Answering Business Questions
• Sharing Answers to Business Questions
• • Presenting Information in a Dashboard
  • Presenting Information in an Interactive Web Application
  • Presenting Information in Excel
  • • Exporting to Excel
    • Working Directly in Excel
  • Printing Reports
  • Publishing Data to Other Formats
  • Distributing Reports

2 Technical Fundamentals for Implementation

• Consolidating Data for Analysis
• • Data Sources
  • • Operational Data
    • External Data
  • Extraction, Transformation, and Loading
  • More Information
• Data Models
• • Transactional Model
  • Dimensional Model
  • • Facts or Measures
    • Dimensions
    • Hierarchies
    • Levels
• Data Structures
• • Relational Tables in Third Normal Form
  • Star Schemas
  • Analytic Workspaces
  • Data Structure and Preparation for Data Mining
• Metadata Models for Data Access
• • Relational Metadata
  • OLAP Metadata
  • Key Differences Between Relational and OLAP Metadata Models
  • • Hierarchies
    • Aggregation
    • Calculations
• Models for Data Mining
• Tools for Creating Reports
• • Oracle Reports
  • • Who Uses Oracle Reports
    • Source Data for Oracle Reports
    • More Information
  • OracleBI Discoverer Plus
  • • Who Uses OracleBI Discoverer Plus
    • Source Data for OracleBI Discoverer Plus
    • More Information
  • OracleBI Spreadsheet Add-In
  • • Who Uses OracleBI Spreadsheet Add-In
    • Source Data for OracleBI Spreadsheet Add-In
    • More Information
  • Oracle Spreadsheet Add-In for Predictive Analytics
  • • Who Uses Oracle Spreadsheet Add-In for Predictive Analytics
    • Data Sources for Oracle Spreadsheet Add-In for Predictive Analytics
    • More Information
• Custom Application Development Tool
• • Data Source for BI Beans
  • More Information
• Deploying Oracle Business Intelligence
• • OracleAS Portal and OracleBI Discoverer Portlet Provider
  • • More Information
  • OracleBI Discoverer Viewer
  • • More Information
  • Oracle Reports Output Options
  • • More Information

3 Example Implementations

• Implementing a Business Intelligence Solution
• • Planning a Business Intelligence System
  • Identify End-User Requirements
  • Identify the Data Sources
  • Design the Data Model
  • Create the Data Store
  • Generate the Summary Data
  • Prepare the Data for Client Access
  • Grant Access Rights
  • Distribute the Client Software and Documentation
  • Create and Distribute Reports
• Global Enterprises: Ad-Hoc Reporting and Advanced Analytics
• • Software Requirements
  • • Components for Delivering Reports
    • Components for Creating Reports
    • Components for Preparing Data
    • Component for Developing Custom Applications
    • Database
  • Getting Started With Analytic Workspaces
  • • Design the Data Model
    • Create the Data Store
    • Generate the Summary Data
    • Prepare the Data for Client Access
    • Grant Access Rights
    • Distribute the Client Software and Documentation
    • Define Advanced Analytics
    • Deploy Custom Applications
• Acme Corporation: Web-Based Access to Transactional Data
• • Software Requirements
  • • Components for Delivering Reports
    • Components for Creating Reports
    • Component for Preparing Data
    • Database
  • Getting Started With Discoverer
  • • Design the Data Model
    • Generate the Summary Data
    • Prepare the Data for Client Access
    • Grant Access Rights
    • Distribute the Client Software and Documentation

A Oracle Business Intelligence Packaging

• Oracle Business Intelligence
• Oracle Business Intelligence Tools
• Oracle Business Intelligence Warehouse Builder Installation
• Oracle Database

Index