Business Intelligence Cookbook：A Project Lifecycle Approach Using Oracle Technology

coverpage

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Support files eBooks discount offers and more

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

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