Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology -- Table of Contents -- Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology -- Credits -- About the Author -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Defining a Program -- Introduction -- Program or a project -- Getting ready -- How to do it... -- How it works... -- There's more... -- Mapping your business culture -- Getting ready -- How to do it... -- How it works... -- There's more... -- Organizations that have grown through acquisition -- Organizations that have grown organically -- Organizations and growth phases -- Metric driven organizations -- Report managed organizations -- See also -- Adapting your project delivery methodology -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Assessing your project team -- How to do it... -- How it works... -- See also -- Organizing your project team -- How to do it... -- There's more... -- See also -- 2. Establishing the Project -- Introduction -- Creating Definition work practice -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating Data Discovery work practice -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating Development work practice -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating Testing work practice -- Getting ready -- How to do it... -- How it works...

There's more... -- Creating Promote work practice -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating Production work practice -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building a standard work breakdown structure -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying and quantifying the effort drivers -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating your estimation tool -- Getting ready -- How to do it... -- How it works... -- There's more... -- 3. Controlling the Project -- Introduction -- Requirements Traceability Matrix -- Getting ready -- How to do it... -- How it works... -- There's more... -- Oracle Application Express and a Requirements Traceability Matrix -- Creating an effective risk register -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating an effective issue management register -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a defect and enhancement register -- Getting ready -- How to do it... -- How it works... -- There's more... -- Oracle Application Express and bug tracking -- Creating a cyclical build and test process -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting up a collaborative environment -- Getting ready -- How to do it... -- How it works... -- Installing client tools for a collaborative environment -- Getting ready -- How to do it... -- How it works... -- 4. Wrapping Up the Project -- Introduction -- Creating OWB code artifacts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating OBIEE code artifacts -- Getting ready -- How to do it... -- How it works... -- Creating APEX code artifacts -- Getting ready -- How to do it... -- How it works...

There's more... -- Creating ODI code artifacts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating script artifacts -- Getting ready -- How to do it... -- How it works... -- Building a continuous development capability for enhancements -- Getting ready -- How to do it... -- How it works... -- Creating a constant feedback and communications loop -- Getting ready -- How to do it... -- How it works... -- 5. The Blueprint -- Introduction -- Outlining your business processes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Categorizing your metrics, analysis, and reports within the business process -- Getting ready -- How to do it... -- How it works... -- There's more... -- Decomposing your analysis and reports to define business entities -- Getting ready -- How to do it... -- How it works... -- There's more... -- Developing your semantic data model -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying your source of record for your business entities -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building the blueprint -- Getting ready -- How to do it... -- How it works... -- There's more... -- 6. Analyzing the Requirements -- Introduction -- Decomposing the reports and requirements -- Getting ready -- How to do it... -- How it works... -- There's more... -- Defining the business rules -- Getting ready -- How to do it... -- How it works... -- Categorizing the business requirements by business drivers -- Getting ready -- How to do it... -- How it works... -- There's more... -- Prioritizing the business requirements -- Getting ready -- How to do it... -- How it works... -- Adding hierarchies to your semantic data model -- Getting ready -- How to do it... -- How it works... -- There's more...

Adding metrics to your semantic data model -- Getting ready -- How to do it... -- How it works... -- Defining your data dictionary -- Getting ready -- How to do it... -- How it works... -- There's more... -- Defining your security requirements -- Getting ready -- How to do it... -- How it works... -- There's more... -- Defining your data retention requirements -- Getting ready -- How to do it... -- How it works... -- 7. Architecture and Design -- Introduction -- Choosing your database type -- Getting ready -- How to do it... -- How it works... -- There's more... -- Defining your database layout -- Getting ready -- How to do it... -- How it works... -- Advantages -- Disadvantages -- There's more... -- Selecting the Third Normal Form or a Dimensional model -- Getting ready -- How to do it... -- How it works... -- There's more... -- 8. Analyzing the Sources -- Introduction -- Validating and enhancing a conceptual data model -- Getting ready -- How to do it... -- How it works... -- Creating a business process matrix -- Getting ready -- How to do it... -- How it works... -- Creating a report requirements matrix -- Getting ready -- How to do it... -- How it works... -- Creating a source matrix -- Getting ready -- How to do it... -- How it works... -- Developing the data lineage -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enforcing standards -- Defining the detailed transformations -- Getting ready -- How to do it... -- How it works... -- 9. Analyzing the Data -- Introduction -- Building high and low data profiling scripts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building domain/distinct values profiling -- Getting ready -- How to do it... -- How it works... -- Building record count profiling scripts -- Getting ready -- How to do it... -- How it works...

Building density data profiling scripts -- Getting ready -- How to do it... -- How it works... -- Building hierarchy data profiling scripts -- Getting ready -- How to do it... -- How it works... -- Building data lengths data profiling scripts -- Getting ready -- How to do it... -- How it works... -- Building significant columns data profiling scripts -- Getting ready -- How to do it... -- How it works... -- Building changing information data profiling scripts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building automated data profiling with Oracle Warehouse Builder -- Getting ready -- How to do it... -- How it works... -- 10. Constructing the Data Model -- Introduction -- Connecting Oracle SQL Data Modeler to Subversion -- Getting ready -- How to do it... -- How it works... -- Importing data models into Subversion -- Getting ready -- How to do it... -- How it works... -- Checkout data models from Subversion -- Getting ready -- How to do it... -- How it works... -- Synchronizing data model changes with Subversion -- Getting ready -- How to do it... -- How it works... -- There's more... -- How to import data models -- Getting ready -- How to do it... -- How it works... -- How to reverse engineer your relational data model to a logical data model -- Getting ready -- How to do it... -- How it works... -- Creating your domains -- Getting ready -- How to do it... -- How it works... -- Creating your glossary -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding Standard columns to your data model -- Getting ready -- How to do it... -- How it works... -- How to forward engineer your logical data model to a relational data model -- Getting ready -- How to do it... -- How it works... -- Creating your enterprise data models -- Getting ready -- How to do it... -- How it works...

11. Defining the ETL/ELT.