Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
Adapting your project delivery methodology
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
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
Building a continuous development capability for enhancements
Creating a constant feedback and communications loop
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
Decomposing the reports and requirements
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 security requirements
Defining your data retention requirements
Selecting the Third Normal Form or a Dimensional model
Validating and enhancing a conceptual data model
Creating a business process matrix
Creating a report requirements matrix
Defining the detailed transformations
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
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 reverse engineer your relational data model to a logical data model
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
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
Creating your application schema
Creating your application tables
Developing the journal tables to track changes
Defining the APEX Upload application
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 multi-language for the shared captions
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