Skip Headers
Oracle® Business Intelligence Concepts Guide
10
g
Release 2 (10.1.2.1)
B16378-01
Library
Product
Index
Next
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