Book description
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.
- 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
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: A Project Lifecycle Approach Using Oracle Technology Cookbook 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: A Project Lifecycle Approach Using Oracle Technology Cookbook 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.
Table of contents
-
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
- Preface
- 1. Defining a Program
-
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
-
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
- 4. Wrapping Up the Project
-
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
-
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
- 7. Architecture and Design
- 8. Analyzing the Sources
-
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
-
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
-
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
- 12. Enhancing the Data
-
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
-
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
- Index
Product information
- Title: Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
- Author(s):
- Release date: July 2012
- Publisher(s): Packt Publishing
- ISBN: 9781849685481
You might also like
book
Oracle Business Intelligence 11g Developers Guide
Master Oracle Business Intelligence 11 g Reports and Dashboards Deliver meaningful business information to users anytime, …
book
Oracle Business Intelligence Applications
Implement Oracle Business Intelligence Applications Provide actionable business intelligence across the enterprise to enable informed decision-making …
book
Oracle Business Intelligence Enterprise Edition 12c - second Edition
A comprehensive guide from Oracle experts, that will act as your single point of reference for …
video
OBIEE (Oracle Business Intelligence Enterprise Edition) 11g Reports and Dashboards
Overview OBIEE 11g (Oracle Business Intelligence Enterprise Edition) Reports and Dashboards LiveLessons introduces students to the …