Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

By : John Heaton

Buy this Book

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

By: John Heaton

Buy this Book

Overview of this book

Oracle Database 11g is a comprehensive database platform for data warehousing and business intelligence that combines industry-leading scalability and performance, deeply-integrated analytics, and embedded integration and data-quality all in a single platform running on a reliable, low-cost grid infrastructure. This book steps through the lifecycle of building a data warehouse with key tips and techniques along the way. Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology outlines the key ways to effectively use Oracle technology to deliver your business intelligence solution. This is a practical guide starting with key recipes for project management then moving onto project delivery. Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology is a practical guide for performing key steps and functions on your project. This book starts with setting the foundation for a highly repeatable efficient project management approach by assessing your current methodology to see how suitable it is for a business intelligence program. We also learn to set up the project delivery phases to consistently estimate the effort for a project. Along the way we learn to create blueprints for the business intelligence solution that help to connect and map out the destination of the solution. We then move on to analyze requirements, sources, and data. Finally we learn to secure the data as it is an important asset within the organization and needs to be secured efficiently and effectively.

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

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

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

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

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

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

Architecture and Design

Introduction

Choosing your database type

Defining your database layout

Selecting the Third Normal Form or a Dimensional model

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

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

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

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

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

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

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

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Creating a column-level Virtual Private Database

In addition to row-level security, the same Oracle packages also provide the ability to create column-level security.

Getting ready

Oracle also supports column masking as an option with VPD. This allows the database to apply a security function to determine whether a column within a row being returned should be masked or not. Log into SQL Developer as the schema owner from the previous recipe.

How to do it...

Column masking or column-level VPD is very useful to mask and hide sensitive information within a row. For example, Social Security numbers, and so on. The rules that enforce column masking are enforced the same way as row-level security with the business rules in a function and a policy to enforce the function:

1. Create a function which will secure the columns:

CREATE OR REPLACE FUNCTION USAGE_COL_SEC
( p_schema IN VARCHAR2 DEFAULT NULL, P_object IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2
IS
CURSOR GET_GROUP IS
SELECT GROUP_CODE FROM LDAP_USER_GROUP...

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

By : John Heaton

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

By: John Heaton

Overview of this book

Related Content you might be interested in

Current Title:

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Creating a column-level Virtual Private Database

Getting ready

How to do it...