| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Oracle Business Intelligence Defined | |
| |
| |
| |
| Oracle Business Intelligence | |
| |
| |
| Business Intelligence and Transactional Applications | |
| |
| |
| Daily Business Intelligence | |
| |
| |
| Balanced Scorecard | |
| |
| |
| Enterprise Planning and Budgeting | |
| |
| |
| Activity-Based Management | |
| |
| |
| Oracle Integration Components Enabling Business Intelligence | |
| |
| |
| Data Hubs | |
| |
| |
| Business Activity Monitoring | |
| |
| |
| BPEL Process Manager | |
| |
| |
| Enterprise Messaging Service | |
| |
| |
| Custom Data Warehouse Solutions | |
| |
| |
| The Role of the Oracle Database | |
| |
| |
| Oracle Warehouse Builder | |
| |
| |
| Oracle Business Intelligence Standard Edition | |
| |
| |
| Oracle Business Intelligence Enterprise Edition | |
| |
| |
| BI (XML) Publisher | |
| |
| |
| Oracle Portal | |
| |
| |
| Spreadsheet Add-ins | |
| |
| |
| Building Custom Business Intelligence Applications | |
| |
| |
| Emerging Trends | |
| |
| |
| |
| Oracle's Transactional Business Intelligence | |
| |
| |
| Transactional Business Intelligence | |
| |
| |
| Business Terminology | |
| |
| |
| Oracle's Daily Business Intelligence | |
| |
| |
| How DBI Works | |
| |
| |
| Varieties of DBI | |
| |
| |
| Balanced Scorecards | |
| |
| |
| Oracle Balanced Scorecard Structure | |
| |
| |
| OBSC Architecture | |
| |
| |
| Creating an Oracle Balanced Scorecard | |
| |
| |
| Data Hubs | |
| |
| |
| The Oracle Customer Data Hub | |
| |
| |
| How Data Hubs Work | |
| |
| |
| Other Oracle Data Hubs | |
| |
| |
| Is Transactional Business Intelligence Enough? | |
| |
| |
| |
| Introduction to Oracle Data Warehousing | |
| |
| |
| Oracle Data Warehousing Basics | |
| |
| |
| Oracle Database Analysis and Schema Considerations | |
| |
| |
| Managing an Oracle-based Data Warehouse | |
| |
| |
| Where to Start? | |
| |
| |
| Oracle/PeopleSoft EPM | |
| |
| |
| Oracle/Siebel Business Analytics Applications | |
| |
| |
| Choosing Completely Custom | |
| |
| |
| |
| Choosing a Platform | |
| |
| |
| Scaling Up Platforms Versus Scaling Out | |
| |
| |
| Hardware Platforms | |
| |
| |
| Cost Considerations | |
| |
| |
| Availability Considerations | |
| |
| |
| Manageability Considerations | |
| |
| |
| Sizing the Platform | |
| |
| |
| Information Needed for Warehouse Hardware Sizing | |
| |
| |
| Benchmarking | |
| |
| |
| Sizing Hardware for Business Intelligence Tools | |
| |
| |
| Your Strategy | |
| |
| |
| |
| Custom-Built Data Warehousing Solutions | |
| |
| |
| |
| Designing for Usability | |
| |
| |
| Approaches for Design | |
| |
| |
| Key Design Considerations | |
| |
| |
| Features for Design - Enhancing Performance | |
| |
| |
| Business Scenario | |
| |
| |
| Normalized Design | |
| |
| |
| Dimensional Design | |
| |
| |
| Hybrid Design | |
| |
| |
| Online Analytical Processing Design | |
| |
| |
| Other Considerations | |
| |
| |
| Selecting the Best Approach | |
| |
| |
| |
| Business Intelligence Tools | |
| |
| |
| Oracle Portal and Portal Products | |
| |
| |
| Using Oracle Portal | |
| |
| |
| Building and Deploying Oracle Portal and Portlets | |
| |
| |
| Reporting | |
| |
| |
| BI/XML Publisher | |
| |
| |
| Oracle Reports | |
| |
| |
| Oracle BI Reporting Workbench (Actuate) | |
| |
| |
| Ad hoc Query and Analysis | |
| |
| |
| Business Intelligence Enterprise Edition | |
| |
| |
| Discoverer and Business Intelligence Standard Edition | |
| |
| |
| Oracle Spreadsheet Add-ins | |
| |
| |
| Building Business Intelligence Applications | |
| |
| |
| JDeveloper and BI Beans | |
| |
| |
| Data Miner | |
| |
| |
| Other Tools | |
| |
| |
| |
| Data Loading | |
| |
| |
| Oracle Database Data Loading Features | |
| |
| |
| Embedded ETL in the Oracle Database | |
| |
| |
| SQLa?? | |
| |
| |
| Loader | |
| |
| |
| Change Data Capture | |
| |
| |
| Transportable Tablespaces | |
| |
| |
| Data Pump | |
| |
| |
| Oracle Warehouse Builder | |
| |
| |
| OWB Packaging | |
| |
| |
| Typical Steps when using OWB | |
| |
| |
| ETL Design in OWB | |
| |
| |
| OWB and Dimensional Models | |
| |
| |
| The OWB Process Editor | |
| |
| |
| Balancing Data Loading Choices | |
| |
| |
| |
| Managing the Oracle Data Warehouse | |
| |
| |
| Oracle Enterprise Manager Grid Control | |
| |
| |
| Database Performance Monitoring | |
| |
| |
| Database Administration | |
| |
| |
| Database Maintenance | |
| |
| |
| Database Topology | |
| |
| |
| Management and Management Options | |
| |
| |
| |
| Data Warehouse Performance Tuning and Monitoring | |
| |
| |
| Understanding Performance Challenges | |
| |
| |
| Who Is Responsible? | |
| |
| |
| Causes of Poor Performance | |
| |
| |
| Successful Approaches to Performance Tuning | |
| |
| |
| Critical Tasks for Performance Tuning Lifecycle | |
| |
| |
| Hardware Configuration | |
| |
| |
| Software Configuration | |
| |
| |
| Database Application Design | |
| |
| |
| Business Scenario: Tuning Our Sample Solution | |
| |
| |
| Where To Start | |
| |
| |
| Enterprise Manager Advisory Framework | |
| |
| |
| Approaches for Success | |
| |
| |
| |
| Best Practices | |
| |
| |
| |