Book Image

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

By : John Heaton
Book Image

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

By: John Heaton

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.

Related Content you might be interested in

Current Title:

Small book image
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
John Heaton
Jul, 2012 | 368 pages
No titles found
Table of Contents (21 chapters)
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
Credits
Credits
About the Author
About the Author
Acknowledgement
Acknowledgement
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Defining a Program
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
2
Establishing the Project
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
3
Controlling the Project
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
4
Wrapping Up the Project
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
5
The Blueprint
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
6
Analyzing the Requirements
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
7
Architecture and Design
Architecture and Design
Introduction
Choosing your database type
Defining your database layout
Selecting the Third Normal Form or a Dimensional model
8
Analyzing the Sources
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
9
Analyzing the Data
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
10
Constructing the Data Model
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
11
Defining the ETL/ELT
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
12
Enhancing the Data
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
13
Optimizing the Access
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
14
Security
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

About the Reviewers

Chandan Banerjee is the Director and Principal Consultant at BA IT Consulting Pvt. Ltd. (www.baconsultinggroup.com), and also a Partner and Principal Consultant at Beetra Consulting ( www.beetraconsultancy.com).

He has more than 20 years of experience in leading and deploying IT solutions, out of which he has spent 18 years in the field of Business Intelligence (BI). He provides consulting services in BI Education, Data Integration, and Solution Architecture design. Managing deployments of common BI tools and applications is his forte. He is an expert in all the phases of lifecycle development for business intelligence projects. He has also been the architect of two BI-based, pre-built application products.

He has been one of the reviewers of "Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting".

Ajay Kalia, P.M.P., Director at iSeerix, is one of the co-founders of iSeerix, a software development company based in Pittsford, New York. Ajay has a BSc degree in Computer Science from the University of Toronto. He has 26 years of experience in the IT industry, focusing primarily on software development and on-site client consulting services. During his years in the industry, Ajay has established a successful track record delivering high-quality projects to numerous satisfied customers. This is indicative of his understanding of client IT requirements, and his ability to adapt, understand, and efficiently utilize the fast-changing technologies involved.

Toon Loonen, has specialized in Data Modeling (logical and physical) for OLTP and OLAP/DW/BI systems, Database Design, and Data Warehousing. He has broad experience with several databases, of which over 10 years is with Sybase, 10 years with Oracle/Oracle Spatial, and a few years with other relational databases (Informix, Mimer, MS SQL Server, and others).

An important part of Mr. Loonen's work is coaching junior colleagues, so they can take over his task on the projects, and he can move on to a new challenge.

After his study in Physics, Mr. Loonen joined Capgemini in 1975. He followed a technical path, from a programmer, tester, technical and functional designer, to data modeling and database designing. As an employee of Capgemini, he worked on projects for many organizations, both public and private, such as DHL, Philips, KPN, AHOLD, and many departments of the Dutch Government.

In the period between 1982-1985, he worked in Montreal, Canada, as a Manager of Software Quality Assurance for Philips, and as a Consultant for Coopers and Lybrand.

Mr. Loonen wrote a book on Data Modeling and Database Design, which covered the very start of this process (selection of the data domain), through conceptual, logical, and physical data modeling, up to the implementation in a database management product such as Oracle.

Mr. Loonen gave presentations on these topics, both within Capgemini as well as at international conferences. He has written many articles that are published on the Capgemini intranet, and 25 articles that are published in a Dutch magazine for DBAs—Database Magazine.

Clive Seymour has been implementing and using data warehouses for business intelligence and organisational performance management for more than 15 years. He advises organisations on business intelligence and information management strategies, governance, cultural change, solution and technical architecture, tool selections, and implementation options.

Clive has advised and worked for organisations in the financial services, mining, utilities, media, consumer goods, and manufacturing industries. He has led teams from small domestic to large multi-country international implementations, using Oracle's BI and IM capabilities and other leading vendor's solutions.

Michael Verzijl is a Business Intelligence Consultant, specialized in Oracle Business Intelligence, Oracle Data Warehousing, and Oracle GoldenGate.

Michael has a wide experience in the financial, utilities, and government industries, which include BI technologies such as Oracle, IBM Cognos, and SAP Business Objects.

Currently he is employed as a BI Consultant for Aorta Business Intelligence in the Netherlands, specializing in Business Intelligence and Data Warehousing.

Previous Section
Next Chapter