Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 368 pages [ 235mm x 191mm ]
Release Date : July 2012
ISBN : 1849685487
ISBN 13 : 9781849685481
Author(s) : John Heaton
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Cookbooks, Enterprise, Oracle

Table of Contents

Chapter 1: Defining a Program
Chapter 2: Establishing the Project
Chapter 3: Controlling the Project
Chapter 4: Wrapping Up the Project
Chapter 5: The Blueprint
Chapter 6: Analyzing the Requirements
Chapter 7: Architecture and Design
Chapter 8: Analyzing the Sources
Chapter 9: Analyzing the Data
Chapter 10: Constructing the Data Model
Chapter 11: Defining the ETL/ELT
Chapter 12: Enhancing the Data
Chapter 13: Optimizing the Access
Chapter 14: Security
  • 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 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

                              John Heaton

                              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.
                              Sorry, we don't have any reviews for this title yet.

                              Code Downloads

                              Download the code and support files for this book.

                              Submit Errata

                              Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                              Sample chapters

                              You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                              Frequently bought together

                              Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology +    Oracle 11g R1 / R2 Real Application Clusters Handbook =
                              50% Off
                              the second eBook
                              Price for both: $65.60

                              Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                              What you will learn from this book

                              • 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.


                              This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations.

                              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.

                              Code Download and Errata
                              Packt Anytime, Anywhere
                              Register Books
                              Print Upgrades
                              eBook Downloads
                              Video Support
                              Contact Us
                              Awards Voting Nominations Previous Winners
                              Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                              Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software