PacktLib: Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology


About the Author


About the Reviewers


Defining a Program


Program or a project

Mapping your business culture

Adapting your project delivery methodology

Assessing your project team

Organizing your project team

Establishing the Project


Creating Definition work practice

Creating Data Discovery work practice

Creating Development work practice

Creating Testing work practice

Creating Promote work practice

Creating Production work practice

Building a standard work breakdown structure

Identifying and quantifying the effort drivers

Creating your estimation tool

Controlling the Project


Requirements Traceability Matrix

Creating an effective risk register

Creating an effective issue management register

Creating a defect and enhancement register

Creating a cyclical build and test process

Setting up a collaborative environment

Installing client tools for a collaborative environment

Wrapping Up the Project


Creating OWB code artifacts

Creating OBIEE code artifacts

Creating APEX code artifacts

Creating ODI code artifacts

Creating script artifacts

Building a continuous development capability for enhancements

Creating a constant feedback and communications loop

The Blueprint


Outlining your business processes

Categorizing your metrics, analysis, and reports within the business process

Decomposing your analysis and reports to define business entities

Developing your semantic data model

Identifying your source of record for your business entities

Building the blueprint

Analyzing the Requirements


Decomposing the reports and requirements

Defining the business rules

Categorizing the business requirements by business drivers

Prioritizing the business requirements

Adding hierarchies to your semantic data model

Adding metrics to your semantic data model

Defining your data dictionary

Defining your security requirements

Defining your data retention requirements

Architecture and Design


Choosing your database type

Defining your database layout

Selecting the Third Normal Form or a Dimensional model

Analyzing the Sources


Validating and enhancing a conceptual data model

Creating a business process matrix

Creating a report requirements matrix

Creating a source matrix

Developing the data lineage

Defining the detailed transformations

Analyzing the Data


Building high and low data profiling scripts

Building domain/distinct values profiling

Building record count profiling scripts

Building density data profiling scripts

Building hierarchy data profiling scripts

Building data lengths data profiling scripts

Building significant columns data profiling scripts

Building changing information data profiling scripts

Building automated data profiling with Oracle Warehouse Builder

Constructing the Data Model


Connecting Oracle SQL Data Modeler to Subversion

Importing data models into Subversion

Checkout data models from Subversion

Synchronizing data model changes with Subversion

How to import data models

How to reverse engineer your relational data model to a logical data model

Creating your domains

Creating your glossary

Adding Standard columns to your data model

How to forward engineer your logical data model to a relational data model

Creating your enterprise data models

Defining the ETL/ELT


Abstracting your source system

Separating your extraction from your loading and transforming routines

Adding additional columns to facilitate error trapping and correction

Designing ETL error trapping and detection routines

Designing ETL data reconciliation routines

Designing a notification routine

Enhancing the Data


Creating your application schema

Creating your application tables

Developing the journal tables to track changes

Defining the audit triggers

Defining the APEX Upload application

Creating the Upload interface

Optimizing the Access


Developing your standards and guidelines

Abstracting your tables using aliases

Developing level-based hierarchies

Creating multi-table hierarchies

Consolidating reports using the column selector

Enabling dynamic column headings

Enabling dynamic descriptions

Enabling multi-language for the shared captions



Creating an APEX custom authentication procedure

Creating a row-level Virtual Private Database (VPD)

Creating a column-level Virtual Private Database

Creating Virtual Private application context

Configuring OBIEE for multiple security providers

Integrating Microsoft Active Directory into OBIEE

Creating and configuring OBIEE roles

Configuring OBIEE privileges

Configuring OBIEE catalog security

Enabling Virtual Private Database in OBIEE