Oracle DB 11g Data Warehousing
Courses In The Certification
Duration 24 Hours
Oracle Warehouse Builder 10g: Implementation Part I
In this 3-day hands-on course, students learn how to implement a data warehousing solution using Oracle Warehouse Builder (OWB). The concepts, design issues, architecture, and terminology that underlie OWB are explored. Students use OWB client tools to create and maintain OWB design metadata, including source and warehouse target definitions, and ETL mappings to extract, transform, and load data into the targets. Students generate, deploy, and execute OWB design objects to create and populate a target warehouse.
  • Create Data Profile
  • Generate Data Rules and Run Correction Mappings
  • Define source-to-target mappings
  • Designing the target warehouse
  • Create Process Flows
  • Extracting, transforming, and loading data into the staging tables and an enterprise model warehouse
  • Create Schedules
  • Use the Dependency Manager to manage metadata
  • Deploy objects directly into Oracle Business Intelligence Discoverer EUL

Setting Up and Starting Warehouse Builder

  • Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup
  • Describe Oracle Warehouse Builder program group components
  • Log in to the Design Center
  • Create a design repository and users
  • Open a project and navigate the user interface

Introducing OWB 10g R2 Architecture and Configuration

  • Discuss various design and run-time configurations
  • Describe the Warehouse Builder repository architecture, users, and owners
  • Describe the OWB repository architecture, users, and owners
  • Explain the benefits of warehouse staging areas
  • Describe the course data sources and targets
  • Import metadata using tcl scripts

Defining Source Metadata

  • Define and create source modules
  • Specify source data from flat files
  • Specify source data from relational database tables
  • Import source object metadata into the source modules

Ensuring Data Quality Using Data Profiling

  • Create a data profile
  • Profile the data
  • View profile results
  • Analyze profile results

Defining Staging Metadata and Mapping Tables

  • Create a target module
  • Add a staging table to a staging area warehouse module
  • Define mappings between source objects and staging table columns

Deriving Data Rules and Running Correction Mappings

  • Derive data rules
  • Create a correction
  • Run the generated correction mappings

Defining a Relational Dimensional Model

  • Define dimensions and cubes
  • Navigate the Data Object Editor
  • Define ETL mappings to load the dimensions and cubes

Handling Slowly Changing Dimensions

  • Explain how OWB handles a slowly changing dimension
  • Define a type 2 slowly changing dimension
  • Use the type 2 policy dialog box

Using Process Flows

  • Navigate the process flow editor
  • Create process flow definitions
  • Define a schedule
  • Use process flow activity templates
  • Use process flow activities

Deploying, Loading, and Viewing Data

  • Use the Control Center Manager
  • Load data into tables
  • Use the Dependency Manager to manage metadata

Business Intelligence Integration

  • Define Oracle Discoverer structures
  • Derive Oracle Discoverer structures
  • Define cross-tab and graph presentation templates
Duration 16 Hours
Oracle Warehouse Builder 10g: Implementation Part II
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. Note: 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.
  • 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

Required Prerequisites:

  • Oracle Warehouse Builder 10g: Implementation Part 1
  • Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

Suggested Prerequisites:

  • Introduction to Business Intelligence Products-estudy
  • Introduction to Oracle Warehouse Builder 10g Release 2 -ODE
  • Hands-on experience on

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
Duration 16 Hours
Oracle BI Publisher 10gR3: Fundamentals
Oracle BI Publisher (formerly known as XML Publisher) is a revolutionary reporting and document output management solution from Oracle. In this course participants gain expertise with Oracle BI Publisher 10g R3 ( by gaining a foundation in the fundamentals, and underlying standards. By the end of the course, attendees will be able to create reports based on various data sources such as Oracle Database, Web Services, RSS feeds, and Files. Oracle BI Publisher can be used as a stand-alone reporting product or integrated with the Oracle Business Intelligence Suite Enterprise Edition, and also with Oracle BI Discoverer. So, participants will also learn about these integrations, and be able to create BI Publisher reports based on Oracle BI Server subject area, and Oracle BI Answers. This course also teaches how to install BI Publisher Desktop (an MS-Word add-in to create report templates), how to create and publish multiple templates for the BI Publisher reports. Students will also perform various administrative tasks such as configuring the scheduler, configuring report delivery media, and setting up Excel analyzer. This course also covers advanced features of BI Publisher such as creating reports with hyperlinks, scheduling and managing scheduled reports, bursting the reports, using online and Excel analyzers to analyze the data in BI Publisher reports, and creating reports from data templates. Hands-on exercises reinforce concepts taught in class. Learn To: Understand the basic concepts and uses of Oracle BI Publisher, Understand the underlying X standards, Create and use an RTF template, Create and use a PDF template, Set up, configure, and use Oracle BI Publisher Enterprise server.
Create BI Publisher reports based on Oracle Database, and other Data Sources
Create and use a rich text format (RTF) templates
Create reports using Extensible Markup Language (XML)
Explain integration points with Oracle BI Enterprise Edition and Oracle BI Discoverer
Explain the use of a portable document format (PDF) template
Explain the uses of Oracle BI Publisher
Explore advanced features such as bursting, scheduling, and email
Set up, configure, and use the Oracle BI Publisher Enterprise server
Introduction to BI Publisher
Oracle BI Publisher: Business Document Requirements
Functions of Reporting Systems
Oracle BI Publisher Paradigm
End-to-End View and Salient Features of BI Publisher
Oracle BI Publisher: Technology and Architecture
Describe the components of Oracle BI Publisher
Describe the architecture of Oracle BI Publisher
Describe the Oracle BI Publisher Underlying Technology
Introduction to XML Standards
Describe Extensible Markup Language (XML), Extensible Stylesheet Language (XSL), and other X Standards objects
List the components of an XML document
Create a well-formed XML document
Describe XML namespaces, document type definition (DTD), XML Schema, and XML Path Language (Xpath)
Describe XSL and XSL Transformations (XSLT) 
Getting Started with BI Publisher: Creating a Simple Report
Describe the sample schemas used in course practices (HR,OE, and SH)
Set up a database connection in BI Publisher
Opening and viewing a Predefined Report
Create a BI Publisher Report Based on Oracle Database
Edit the Properties of a Report
Upload an existing template for the report and view data
Export or download a BI Publisher report 
Creating Simple RTF Templates
Describe the functions and features of BI Publisher Desktop
Describe how to install BI Publisher Desktop
Create RTF templates for a sample report
Create and publish RTF templates for BI Publisher reports
Create RTF templates by using the basic, form field methods
Insert tables, forms, and charts in RTF templates
Preview results
Advanced RTF Template Techniques 
Use native MS Word features to format RTF templates
Use other advanced features 
Creating Parameters, List of Values (LOVs), and Hyperlinks
Create a report with parameters and a list of values
Create a report with a hyperlink to another report
Working with PDF and eText Templates
The Basics of PDF Templates
The advanced capabilities of PDF templates
The basics of eText templates
Using Oracle BI Publisher Enterprise Administration
Copyright © 2013, Oracle. All rights reserved. Page  2
Describe BI Publisher–supported security models
Configure the data sources, users, roles and permissions, and delivery options
Perform other administrative tasks
Defining Report Repository
Scheduling Reports and Analyzing Data
Configure BI Publisher Scheduler
Schedule BI Publisher Reports 
View the saved output and history
Manage scheduled reports
Schedule reports to be burst to: a file location, and email
Analyze data in reports
Translating Reports
Describe the type of translations and options for translating reports by using BI Publisher
Create translation files by using BI Publisher Desktop
Create translation files by using the BI Publisher Enterprise Server
Creating Reports by Defining XML Data Templates
Describe the BI Publisher XML data template
Create an XML data template
Associate that data template with a rich text format (RTF) template
View the report
Integration with Oracle BI Enterprise Edition
Create a BI Publisher report from a BI Answers request 
Create a BI Publisher report from the BI Server
Create a BI Publisher report from the BI Discoverer worksheet content
Add BI Publisher reports to BI Interactive Dashboards
Creating Reports Based on Other Data Sources
Creating a BI Publisher Report Based on Web Services
Creating a BI Publisher Report Based on RSS Feeds
Creating a Report Based on a File
Duration 16 Hours
Oracle Database 10g: Using OLAP
In Day 1 of the course you will learn Oracle’s OLAP technology, terminology, and concepts. By the end of day 1, you will have built a simple Analytic Workspace (AW) with the basic cubes and dimensionality. You will view elements of your data model using preview tools that are built into the Analytic Workspace Manager tool. You will begin to build a more sophisticated AW by the end of the day. On Day 2, you will work on more sophisticated OLAP objects and analysis. You will and add objects of more complexity to the AW. Using the BI Spreadsheet Add-In and Discoverer Plus OLAP tools, you will view and analyze the data in the AW, including calculated measures. The last lesson is intended to introduce you to more strengths of the OLAP calculation engine.
  • Define Oracle’s OLAP terminology
  • Describe the OLAP option and components
  • Explain Oracle’s business intelligence end-user and administrative tools
  • Create and populate an AW in the Oracle database
  • Load data into the multidimensional cubes from a provided set of tables
  • Describe how attributes are used
  • Describe advanced cube-processing techniques, such as partitioning and aggregation methods
  • Describe how to manage sparse data by applying Oracle OLAP compression technology
  • Refresh data
  • Create calculated measures based on basic arithmetic, advanced arithmetic, prior and future comparisons, and time frames
  • Install and use the BI Spreadsheet Add-In tool
  • Create worksheets that contain cross tabs and graphs of OLAP data, and use many Discoverer Plus OLAP analytic techniques
  • Create and use saved selections
  • Create reports of OLAP data based on trend analysis and ranking data
  • Add visual cues (stoplights) to the report that highlight specific data ranges
  • Discuss how OLAP DML can be used to enhance calculated measures

Required Prerequisites:

  • Familiarity with Microsoft Windows applications
  • Familiarity with Web browsers
  • SQL Basic Knowledge

    Suggested Prerequisites:

    • A basic understanding of OLAP concepts
    • Introduction to Oracle's Business Intelligence Solution

    Defining OLAP Concepts

    • Reviewing business requirements
    • Understanding the dimensional model
    • Historically, how has OLAP been done?
    • Handling Multidimensional Needs with Oracle OLAP 10g

    Understanding Oracle’s OLAP Technology

    • Server
    • Tools for the end user
    • Tools for the administrator

    Building an Analytic Workspace

    • What is an Analytic Workspace?
    • Using the AWM 10g interface
    • Creating an AW
    • Understanding Cubes
    • Creating Dimensions
    • Using templates for dimensions
    • Creating a Cube
    • Creating Measures

    Applying Advanced Dimensional Design and Cube Processing Techniques

    • Adding Attributes to the dimensional model
    • Using Partitioning
    • Understanding aggregation methods
    • Examining dimensional design considerations
    • Performing ongoing maintenance: refreshing data

    Creating Calculated Measures and Applying Data Refresh Options

    • Calculated measures
    • Modify calculated measures
    • Refreshing data

    Using the BI Spreadsheet Add-In to Query OLAP Data in Excel

    • Installing the BI Spreadsheet Add-In tool
    • Connecting to an Oracle OLAP data source
    • Using the OLAP Query Wizard
    • Creating a ranking report
    • Using saved selections
    • Creating OLAP calculations
    • Applying Excel formatting to OLAP data

    Building Analytical Reports with Discoverer Plus OLAP

    • Enabling the Discoverer Plus OLAP user
    • Creating a Connection, Workbook, and Worksheet
    • Using the OLAP Query Wizard
    • Using the Discoverer Plus Work Area
    • Understanding Query Steps
    • Applying User Attributes in Query Steps
    • Revisiting OLAP Calculations
    • Viewing and modifying the graph

    Enhancing Analytic Content

    • Understanding the difference between Model and Object View
    • Using the OLAP Worksheet interface
    • Entering OLAP DML commands
    • Examining Oracle OLAP Calculation Engine Capabilities

    Order Now
    Your Name    
    Your Job Title    
    Phone / Mobile    
    Your Mail