Oracle data warehousing & business intelligence solutions

Author:

Language: English
Cover of the book Oracle data warehousing & business intelligence solutions

Subject for Oracle data warehousing & business intelligence solutions

Approximative price 51.91 €

Subject to availability at the publisher.

Add to cartAdd to cart
Publication date:
408 p. · Paperback
Written by Oracle insiders and well-known authors, this book shows business analysts how to use the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more. Demonstrates how to design and build the data warehouse, use Oracle's business intelligence tools to analyze data in order to solve business problems, and integrate specific database and business intelligence solutions from other vendors. Explores the best practices for using business intelligence tools to mine the data warehouse. The companion Web site provides all the sample code used throughout the book, plus links to related sites.
Acknowledgments.

Introduction.

Part I Oracle Business Intelligence Defined.

Chapter 1 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.

Chapter 2 Oracles Transactional Business Intelligence.

Transactional Business Intelligence.

Business Terminology.

Oracles 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?

Chapter 3 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.

Chapter 4 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.

Part II Custom Built Data Warehousing Solutions.

Chapter 5 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.

Chapter 6 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.

Chapter 7 Data Loading.

Oracle Database Data Loading Features.

Embedded ETL in the Oracle Database.

SQL*Loader.

Change Data Capture.

Transportable Tablespaces.

Data Pump.

Oracle Warehouse Builder.

OWB Packaging.

Typical...