OBIEE for Administrators
Course Description
Oracle Business Intelligence Enterprise Edition (OBIEE) is the solution that finally realizes the potential that business intelligence has promised for over a decade.

Traditionally, companies have measured BI projects in terms of months, or even years. You can deploy OBIEE in a matter of weeks, and this workshop gives you the skills you need to ensure that your company maximizes ROI in in this break through technology.

During the course you'll take a technical overview of the OBIEE Plus Platform, learn installation procedures for OBIEE, and gain hands-on experience using the Business Intelligence Administration tool’s features. You’ll also learn how to deploy OBIEE’s various applications. In addition to mastering the fundamentals of OBIEE administration, you'll benefit from studying with instructors who have deployed OBIEE in the field.

These workshops are hands-on. You will conduct all labs on your own BI Server with an OBIEE environment.
Course Overview
By the end of the course you will have:
  • Become acquainted with typical issues that occur when using OBIEE in the field
  • Learned advanced techniques for using BI Answers
  • Structured the OBI Business Model
  • Created and use calculation measures for use in BI Answers
  • Configured logical and physical table sources in Dimensions and Facts
  • Developed summary tables from Fact data
  • Gained familiarity with time series comparisons
  • Learned how to use Delivers and Scheduler
  • Built and configure iBot alerts
  • Integrated an OBI catalog into Microsoft Office
Prerequisite Knowledge and Skills:
  • A basic understanding of data warehouse concepts and reporting tools
Recommended Audience:
  • OBIEE developers
  • OBIEE administrators
  • BI Analysts
Course Materials
  • OBIEE for Administrators Student Guide
Course Agenda
  DAY 1  
  • An Overview of OBIEE
  • OBIEE architecture
  • BI Server design
  • Analytics
  • Installation and configuration of OBIEE tools

Oracle BI EE Answers and Dashboards – Getting Started

  • Introduction to BI Answers and Subject Areas
  • Developing initial BI Answers reports and filtering within BI Answers
  • Working with Views of data in Answers
  • Complex BI Answers calculations
  • Variables and advanced techniques
  • Dashboard Fundamentals
  • Dashboard Creation and Modification
  • Dash boarding and Navigation
  • Layout Concepts and Best Practices
  • Subject Areas
  • Navigation links
  • Prompts
  • View Types
  • Column Selectors
  • Drilling into report dimensions
  • Filtering requests
  • Formatting results
  • Compound Layout / Views
  • Pivot Tables
  • Analytical Formulas
  • Rank, Lead, Lag, TopN, Rolling
  • Adding Text, Folders, Guided Navigation Links
  • Briefing Book Navigation Links
  • Controlling Drill Down Display
  • Creating and modifying requests
  • Gauges
  • Charts
  • Bubble Chart
  • Time series Chart
  • Executing Direct Database Requests
  • Building iBots
  • Styles / Skins
  • Microsoft download
  • Advance SQL Clauses
  • Folder / Tab Best Practices
  • BI Publisher Integration
  • Catalog
  • Global Filters
  • View Selectors
  • Column Selectors
  • Legends
  • Narrative
  • Ticker
  • Creating an Interactive Dashboard

Labs, Day 1

  • Creating and configuring reports
  • Developing and configuring graphs
  • Creating and configuring Pivot Table reports
  • Adding content to Dashboards

  DAY 2  

Oracle BI EE Answers and Dashboards – Advanced Topics

  • Dashboard prompts
  • Presentation variables
  • Direct database requests
  • Guided navigation links
  • Dashboard Overview 
  • Creating Dashboards and Pages
  • Modifying Page structures 
  • Adding BI Answers, BI Publisher, and other  content to Dashboard Pages
  • Using "drop-down" filters in Dashboard Pages
  • Using session and user variables in Dashboard Pages
  • Developing links and navigations within Dashboards
  • Advanced Dashboard Techniques
Labs, Day 2
  • Creating and configuring dashboard prompts
  • Adding Filters to dashboards
  • Customizing graphing components
  • Using direct database requests
  • Using guided navigation
  DAY 3  

Oracle BI EE Server Administration – Administering the repository
  • Physical Layer
  • Business Model and Mapping Layer
  • Presentation Layer
  • Validating the repository
  • Using logs to validate sessions
Oracle BI EE Server Administration – Physical layer
  • Calculation measures and logical columns
  • Calculation measures using BI Answers
  • Creating database connections in Administrator
  • Connecting to flat files and other data sources in Administrator
  • Development of Physical meta data layer
  • Adding  joins to Physical meta data layer
  • Advanced Administrator techniques 
  • Physical Repository Design
  • Metadata Layer Design
  • Importing data sources
  • Setting up connection pool properties
  • Defining keys and joins
  • Creating alias and select tables
Labs, Day 3 - The OBIEE Physical Layer
  • Managing physical joins
  • Managing data sources
  • Working with flat files
  • Connecting to non-Oracle databases
Oracle BI EE Server Administration – Business Model and Mapping
  • Creating Ago and ToDate measures
  • Dimensions, Facts and Measures Overview
  • Aggregates
  • Repository Variables
  • Time Series Data
  • Dimension Hierarchies and Level-Based Measures
  • Calculations on Fact Tables
  • Adding measures to an existing repository
  • Delivers Configuration and Interface
  • Developing calculations and Dimensional Hierarchies 
  • Joining different data sources
Labs, Day 3 - OBIEE Business Model and Mapping
  • Creating a Business Model 
  • Creating Logical Columns, Logical Joins plus crearting Logical Tables and adding to dimensions
  • Renaming Business Model Objects 
  • Deleting Unnecessary Business Model Objects 
  • Building Dimension Hierarchies
  • Working with partitioned data sources
  • Creating and managing aggregate tables
  • Configuring time based keys
  • Defining and using repository variables
  DAY 4  

Oracle BI EE Server Administration – Presentation Layer
  • Building the Presentation layer
  • Managing the Oracle BI Presentation Catalog
  • Specifying sources for partitioned data
  • Using repository variables
  • Handling data structure anomalies and difficulties 
  • Developing Presentation meta data layer 
  • Organizing the Presentation layer for maximum utilization
Labs, Day 4 -The Presentation Layer
  • Creating Presentation layer objects
  • Creating a Subject Area
  • Using Administrator Logging
Oracle BI EE Server Administration – Advanced Topics 
  • Oracle BI Security Goals
  • Checking repository consistency
  • Cache and Catalog Management
  • Oracle BI Security Goals
  • Scheduler Server
  • Server Shutdown / Startup overview
  • Log file troubleshooting and reviews
  • Customizing the Oracle Business Intelligence User Interface
  • Custom Login screen
  • Style sheets for views and portal
  • Inspecting the query log
  • Usage logging
  • OBIEE Performance Tuning Concepts

Labs, Day 4 - OBIEE Advanced Topics

  • Running and diagnosing Consistency Checks
  • Working with Cache
  • Creating user and group security
  • Configuring Scheduler server and database objects
  • Customizing the login screen
  • Changing OBIEE's look and feel
  • Turning on usage logging

Oracle BI EE Delivers – Sending Alerts using iBots

  • Creating conditional iBot
  • Creating unconditional iBot
  • Understanding BI scheduler

Labs, Day 4 -Sending Alerts Using iBots

  • Creating a conditional iBot
  • Creating an unconditional iBot
  • Configuring delivery options for iBots

Oracle BI EE Office Add-In 

  • Installing the Office Add-In
  • Configuring the Office Add-In in Excel
  • Using BI catalog to create Excel reports and PowerPoint slides

Labs, Day 4 - OBIEE Office Add-Ins

  • Installing Office Add-in
  • Configuring connection to BI Server presentation layer
  • Working with different report and graphing formats in Excel
  • Connecting Excel reports to PowerPoint 
  • Working with static and refreshable reports
Course Location/s
New York
55 Broadway, 21st Floor
New York, NY 10006

San Francisco
450 Sansome, 13th Floor
San Francisco, CA 94111
Course Cost

$ 1,125 for OAUG members
$ 1,500 for non-members
Course Date/s
San Francisco - Registration Closed
June 28th to July 1st, 2010
9:00 am to 5:00 pm
New York
August 23th to 25th, 2010
9:00 am to 5:00 pm
San Francisco
September 27th to 29th, 2010
9:00 am to 5:00 pm
San Francisco
October 18th to 20th, 2010
9:00 am to 5:00 pm
New York
December 20th to 22nd, 2010
9:00 am to 5:00 pm

Continue checking other workshops