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