Sitemap | Search


 
Training > Courses > Oracle > Oracle Warehouse Builder 10g: Implementation Part II

Oracle Warehouse Builder 10g: Implementation Part II

What you will learn:

This 2-day course in Oracle Warehouse Builder provides students information to successfully implement new projects and extend existing projects to include OLAP (multi-dimensional) data models.
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.

Schedule/Purchase
Training Formats
Price
Duration
View Schedule(Link)
Instructor-Led Training
SAR 7031.25
2 Days

 
  Audience:
  • Business Intelligence Developer
  • Business Analysts
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Database Administrators
Prerequisites:
Required Prerequisites:
  • Oracle Warehouse Builder 10g: Implementation Part 1
  • Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL
  • Oracle Database 10g: Using OLAP
Suggested Prerequisites:
  • Introduction to Business Intelligence Products-estudy
  • Introduction to Oracle Warehouse Builder 10g Release 2 -ODE
  • Hands-on experience on earlier version of Warehouse builder
Course Objectives:
  • Model multi-dimensional dimensions and cubes
  • Populate the Oracle database analytic workspace by using OWB
  • Build an Expert
  • Manage multiple named configurations
  • Debug your mappings using the Mapping Debugger
  • Use OracleBI Spreadsheet Add-In Microsoft Excel to connect to your Oracle OLAP data source
  • Use OWB Change Manager to take “snapshot” versions of metadata, compare them, and restore them if necessary
Course Topics:
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