Business intelligence cookbook : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / John Heaton.

Format:

Book

Author/Creator:

Heaton, John.

Series:

Enterprise : professional expertise distilled

Language:

English

Subjects (All):

Oracle (Computer file).

Relational databases.

Open source software.

Database management.

Physical Description:

1 online resource (368 p.)

Edition:

1st edition

Place of Publication:

Birmingham : Packt Pub., 2012.

Language Note:

English

System Details:

text file

Biography/History:

Heaton John: John Heaton graduated top of his class with a Diploma in Information Technology from Technikon Witwatersrand in South Africa (equivalent to Bachelors in computer science). He has 10+ years with Oracle Corporation, including as a Practice Manager. John has been co-managing the North Business Intelligence and Warehouse Consulting practice delivering business intelligence solutions to Fortune 500 clients. During this time he has steadily added business skills and business training to his technical background. This experience gives John a great background and insight into the requirements of differing businesses and how to design and develop technical solutions enabling clients to realize their requirements. John's strengths include the ability to communicate the benefits of introducing a business intelligence solution into a client's architecture. He has consistently become a trusted advisor to our clients. John's philosophy is based on responsibility and mutual respect. He relies on the unique abilities of individuals to ensure success in different areas and strives to foster a team environment of creativity and achievement. Today, John specializes as a Solution Architect assisting customers in designing large complex data warehouses. Through his years John has worked in numerous industries with differing technologies. This broad experience base allows John to bring a unique perspective and understanding when designing and developing a data warehouse. The strong business background, coupled with technical expertise and his professional certification in Project Management makes John a valued asset to any project or organization. John frequently presents at Business Intelligence conferences on a variety of subjects.

Summary:

Over 80 quick and advanced recipes that focus on real world techniques and solutions to manage, design, and build data warehouse and business intelligence projects with this book and ebook.

Contents:

Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; 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 structureIdentifying 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 artifactsCreating 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 requirementsDefining 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 modelCreating 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

Notes:

"Quick answers to common problems."

Includes index.

ISBN:

9786613832115

9781283519663

1283519666

9781849685498

1849685495

OCLC:

802882491