Oracle - Course Details

OraWBI10g:P11 Oracle Warehouse Builder 10g: Implementation Part II

Oracle Course Description:
Students learn to deliver on the knowledge requirements of their organization by encapsulating expertise. This is done in the form of a feature called Experts – empowering broader audiences to use OWB functionality to accomplish particular task flows, and also to help implement/enforce standards and best practices.
Oracle Course Duration:
2 Days Training
Oracle Course Target Audience:
Business Analysts,Business Intelligence Developer,Data Warehouse Administrator,Data Warehouse Analyst,Database Administrators
Oracle Course Prerequisite:
Oracle Warehouse Builder 10g: Implementation Part 1,Introduction to Business Intelligence Products-estudy,Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL,Introduction to Oracle Warehouse Builder 10g Release 2 -ODE,Hands-on experience on earlier version of Warehouse
Course Content:
Understanding Oracle OLAP Concepts and Technology
  • Benefits of using OLAP for end users and for information technology (IT) in general
  • Key advantages of Oracle OLAP
  • Main features of a dimensional model
  • Role of an analytic workspace in the Oracle database
OWB OLAP Modeling and Deployment
  • Use additional dimension-modeling capabilities –Value-based, ragged-level, skip-level hierarchies
  • Design the multi-dimensional modeling
Using Spreadsheet Add-In to Query OLAP Data
  • Use OracleBI Spreadsheet Add-In in Microsoft Excel
  • Connect to your Oracle OLAP data source
  • Create OLAP queries
  • Use Excel features on OLAP data
Managing OWB Life-Cycle Changes
  • Use OWB Change Manager to take “snapshot” versions of metadata, compare them, and restore them if necessary
  • Use Metadata Dependency Manager to perform impact and lineage analysis
Using the Mapping Debugger
  • Initialize a mapping debugging session
  • Prepare the testing environment and test data
  • Set breakpoints and watch points
  • Run a test mapping
  • Evaluate the flow of data to detect mapping errors
Managing the Warehouse Builder Environment
  • Use OWB security management user interface
  • Manage deployment and loading in a variety of configurations
Creating Experts
  • Explain the benefits of Warehouse Builder Experts for novice users
  • Use the Expert Editor to define an Expert