Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Take your data warehousing and business intelligence to the next level with this practical guide to Oracle Database 11g. Packed with illustrations, tips, and examples, it has over 80 advanced recipes to fine-tune your skills and knowledge.

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Cookbook
John Heaton

Take your data warehousing and business intelligence to the next level with this practical guide to Oracle Database 11g. Packed with illustrations, tips, and examples, it has over 80 advanced recipes to fine-tune your skills and knowledge.
$35.99
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free Sample

Book Details

ISBN 139781849685481
Paperback368 pages

About This Book

  • Full of illustrations, diagrams, and tips with clear step-by-step instructions and real time examples to perform key steps and functions on your project
  • Practical ways to estimate the effort of a data warehouse solution based on a standard work breakdown structure.
  • Learn to effectively turn the project from development to a live solution
  • Best practices to create a blueprint for the business intelligence solution

Who This Book Is For

If you are Project Managers or IT professionals looking to design and develop a data warehouse and business intelligence solution, then this is the best guide for you.

This book assumes that you have a fundamental knowledge of data warehouse and business intelligence projects.

Table of Contents

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

What You Will Learn

  • Master some of the key techniques and components to enable you to visualise and interrogate information effectively
  • Understand additional and advanced techniques to enhance your ETL/ELT solution
  • Learn to build the data model using Oracle SQL Data Modeller and the Oracle Database to build your logical and physical data model and OBIEE to build the presentation data model.
  • Develop data discovery scripts to uncover data issues and gaps
  • Learn to reverse engineer source data models and map data sources to business requirements using Oracle SQL Data Modeller.
  • Get to grips with mapping information into semantic definitions
  • Understand the ways to define a security model

In Detail

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.

Authors

Table of Contents

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

Book Details

ISBN 139781849685481
Paperback368 pages
Read More

Recommended for You

Real-world Business Intelligence with Microsoft Dynamics GP
$ 43.99
Oracle Primavera Contract Management, Business Intelligence Publisher Edition v14
$ 20.99
Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
$ 29.99