Oracle BI Enterprise Edition (OBIEE) 11g: Boot Camp

Course:  OBIBC
Duration:  5 Days
Level:  I
Course Summary

This course will help students learn how to use Oracle Business Intelligence Enterprise Edition (OBIEE). It covers key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. Students will learn how to create tables, charts, narratives, and pivot tables.

Students begin by using the Oracle BI Administration Tool to construct repositories. They will import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. They also learn how to validate their work by creating and running analyses, and verifying query results using the query log.

Students will use the more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data.

« Hide The Details
Topics Covered In This Course

Oracle Business Intelligence Enterprise Edition Overview

  • Presentation Catalog
  • Signing In/Out
  • Navigation
  • Setting Preferences
  • Interacting with Other Products
  • Integration with Publisher
  • Integration with Microsoft Office

Creating Analyses

  • What Are Analyses?
  • How Are Analyses Processed?
  • Embedding an Analysis in a Dashboard
  • Understanding the Double Column Feature
  • Creating New Analyses
  • Specifying the Criteria for Analyses Editing the Formula for a Column

Adding Views for Display in Dashboards

  • Available Views
  • Editing Graph Views
  • Modifying Values and Performing Write Back
  • Interactions in Views
  • Drilling in Views
  • Sorting Data in Views Common Sort Functionality
  • Linking Views in Master-Detail

Building and Using Dashboards

  • Dashboard Overview
  • Dashboard Builder
  • Creating/Editing Dashboards
  • Adding Oracle BI Publisher Reports to Dashboard Pages
  • Changing the Properties of a Dashboard and its Pages

Filtering and Selecting Data for Analyses

  • Saving Objects as Inline or Named
  • Filters and Selection Steps
  • Creating or Editing Column Filters
  • Working with Groups and Calculated Items

KPIs and KPI Watchlists

  • Overview
  • Creating/Editing KPIs
  • Generating an Analysis from a KPI
  • Creating or Editing KPI Watchlists


  • Overview
  • Editor
  • Creating Scorecards
  • Vision Statements
  • Perspectives

Repository Basics

  • Exploring Oracle BI architecture components
  • Exploring a repository's structure, features, and functions
  • Using the Oracle BI Administration Tool
  • Creating a repository
  • Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

  • Importing data sources
  • Setting up connection pool properties
  • Defining keys and joins
  • Examining physical layer object properties
  • Creating alias tables

Building the Business Model and Mapping Layer of a Repository

  • Building a business model
  • Building logical tables, columns, and sources
  • Defining logical joins
  • Building measures
  • Examining business model object properties

Building the Presentation Layer of a Repository

  • Exploring Presentation layer objects
  • Creating Presentation layer objects
  • Modifying Presentation layer objects
  • Examining Presentation layer object properties

Adding Calculations to a Fact

  • Creating new calculation measures based on existing logical columns
  • Creating new calculation measures based on physical columns
  • Creating new calculation measures using the Calculation Wizard
  • Creating measures using functions

Working with Logical Dimensions

  • Creating logical dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating dimension-specific aggregation rules
  • Creating presentation hierarchies
  • Creating parent-child hierarchies
  • Using calculated members

Using Aggregates

  • Modeling aggregate tables to improve query performance
  • Setting the number of elements in a hierarchy
  • Testing aggregate navigation
  • Using the Aggregate Persistence Wizard

Modeling Time Series Data

  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data

Modeling Many-to-Many Relationships

  • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
What You Can Expect

At the end of this course, students will be able to:

  • Create BI queries
  • Create KPIs
  • Create multiple query views
  • Create BI Interactive Dashboards
  • Create Scorecards
  • Use filters
  • Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
  • Build a dimensional business model to address business intelligence requirements
  • Build and execute analyses to test and verify a dimensional business model analyses
  • Use the Oracle BI Administration Tool to administer Oracle BI Server
Who Should Take This Course

Business Users, Developers, Business Analysts, and OBIEE Administrators

Recommended Prerequisites

Students should know basic SQL and have some exposure to Data Warehouse concepts, Database modeling, and Dimensional modeling.

Training Style

Instructor led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
Oracle Physical Data Warehouse Design and Implementation
4 Days
Oracle BI Enterprise Edition (OBIEE) 11g: Reports and Dashboards
4 Days
Data Warehousing Fundamentals
3 Days
Oracle BI Enterprise Edition 11g: Reports, Dashboards and Repositories
5 Days
Oracle Database 11g: Administer a Data Warehouse
5 Days
Dimensional Modeling for Data Warehouse Projects
5 Days
Oracle BI Enterprise Edition (OBIEE) 11g: Building Repositories
5 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]