Oracle Warehouse Builder 10g: Implementation Part II

start > courses and registration > training feature sheet

code.

10g-WH2

length.

2 days

type.

Instructor-Led

partner.

Oracle

price.

$1,200 :: contact for GSA GOV.

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.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

	Business Analysts
	Business Intelligence Developer
	Data Warehouse Administrator
	Data Warehouse Analyst
	Database Administrators

prerequisites

	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 builder
	Oracle Database 10g: Using OLAP

skills gained

	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 content details

	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