| OWB10gII - Oracle Warehouse Builder 10g: Implementation Part II |
| |
| Objetivo |
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
|
| |
| Descrição |
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.
|
| |
| Público
Alvo |
Administrador de Banco de Dados
Administrador de Data Warehouse
Analista de Data Warehouse
Business Analysts
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Database Administrators
|
| |
| Conteúdo
Programático |
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
|
| |
| Pré-Requisitos |
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
|
|
|
| |
| Carga
Horária |
16 horas |
| |
| Material
Didático |
Material Didático Oficial da Oracle. |
| |
|
