Oracle Warehouse Builder 10g: Implementation Part II

Seminar

In Braunschweig, Gummersbach und München

1.180 € zzgl. MwSt.

Beschreibung

  • Kursart

    Seminar

  • Niveau

    Anfänger

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 fun.. Gerichtet an: Businessanalytiker, Data Warehouse-Administratoren, Data Warehouse-Analytiker, Datenbankadministratoren

Standorte und Zeitplan

Lage

Beginn

Braunschweig (Niedersachsen)

Beginn

auf Anfrage
Gummersbach (Nordrhein-Westfalen, NRW)

Beginn

auf Anfrage
München (Bayern)

Beginn

auf Anfrage

Hinweise zu diesem Kurs

- "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"

Empfohlene Vorkenntnisse:
- Introduction to Business Intelligence Products-estudy - Introduction to Oracle Warehouse Builder 10g Release 2 -ODE - Hands-on experience on earlier version of Warehouse builder

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Inhalte

Seminarziel

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.

Zielgruppe

Businessanalytiker, Data Warehouse-Administratoren, Data Warehouse-Analytiker, Datenbankadministratoren

Seminarinhalte

- 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
Sachgebiete:

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

Voraussetzungen

- "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"

Empfohlene Vorkenntnisse:
- Introduction to Business Intelligence Products-estudy - Introduction to Oracle Warehouse Builder 10g Release 2 -ODE - Hands-on experience on earlier version of Warehouse builder

Hinweis

The current version of this course is presented using OWB 10gR2, however this course is also suitable for OWB 11gR1 customers. The user interface differences between OWB 10gR2 and 11gR1 are very minor and hence are not included in this course''s lab practices.

Oracle Warehouse Builder 10g: Implementation Part II

1.180 € zzgl. MwSt.