Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Table of Contents

• Preface

• Chapter 1: Defining a Program
• Introduction
• Program or a project
• Mapping your business culture
• Adapting your project delivery methodology
• Assessing your project team
• Organizing your project team

• Chapter 2: Establishing the Project
• Introduction
• 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

• Chapter 3: Controlling the Project
• Introduction
• 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

• Chapter 4: Wrapping Up the Project
• Introduction
• 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

• Chapter 5: The Blueprint
• Introduction
• 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

• Chapter 6: Analyzing the Requirements
• Introduction
• 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

• Chapter 7: Architecture and Design
• Introduction
• Choosing your database type
• Defining your database layout
• Selecting the Third Normal Form or a Dimensional model

• Chapter 8: Analyzing the Sources
• Introduction
• 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

• Chapter 9: Analyzing the Data
• Introduction
• 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

• Chapter 10: Constructing the Data Model
• Introduction
• 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

• Chapter 11: Defining the ETL/ELT
• Introduction
• 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

• Chapter 12: Enhancing the Data
• Introduction
• 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

• Chapter 13: Optimizing the Access
• Introduction
• 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

• Chapter 14: Security
• Introduction
• 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

• Index