About the Course

Oracle Business Intelligence 11g is a market leading BI tool offering from Oracle. OBIEE11g has technical capabilities to implement end to end analysis requirements for the business. Since it is a niche technology and not many resources available in market, it’s a great opportunity to make a good career in BI with Oracle BI.


Course Objective

  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository
  • Use Oracle BI Answers to run queries to test and validate a repository
  • Build simple and calculated measures for a fact table
  • Create dimension hierarchies and level-based measures
  • Work with views to display request information
  • Create and modify Interactive Dashboards
  • Create guided navigation links within Interactive Dashboards
  • Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards using agents
  • Perform administrative tasks related to the development and configuration of Interactive Dashboards
  • Customize the Oracle BI Presentation Services user interface
  • Work with Oracle BI Presentation Services content in Microsoft Office applications
  • Build Oracle BI Publisher reports based on Answers requests and BI metadata subject areas
  • Integrate Oracle BI Publisher reports in Interactive Dashboards
  • Employ recommended design principles and best practices


Course pre-requisites

Basic knowledge of SQL is good but not mandatory


Course Content

Repository Basics
  • Oracle BI architecture components
  • Repository structure, features, and functions
  • Using the OracleBI 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 and select 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
Testing and Validating a Repository
  • Checking repository consistency
  • Turning on logging
  • Defining a repository in the initialization file
  • Testing a repository using Oracle BI Answers
  • Inspecting the query log
  • Adding Multiple Logical Table Sources
  • Adding multiple logical table sources to a logical table
  • Specifying logical content
Adding Calculations to a Fact Table
  • 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 Dimension Hierarchies and Level-Based Measures
  • Creating dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating rank measures
Using Aggregates
  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • 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
Using Partitions and Fragments
  • Purpose for segmenting data into partitions and fragments
  • Partition types
  • Modeling partitions in an Oracle BI repository
Using Repository Variables
  • Session variables
  • Repository variables
  • Initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters
Modeling Many-to-Many Relationships
  • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
  • Using helper tables to model many-to-many relationships for team-based hierarchies in a dimension
Setting an Implicit Fact Column
  • Adding fact columns automatically to dimension-only queries
  • Ensuring the expected results for dimension-only queries
  • Selecting a predetermined fact table source
  • Specifying a default join path between dimension tables
  • Creating users and groups
  • Setting permissions for users and groups
  • Authenticating using a external database
  • Authenticating using database authentication
  • Setting query limits and timing restrictions
  • Setting filters to personalize information
Cache Management
  • Restricting tables as non-cacheable
  • Using Cache Manager
  • Inspecting cache reports
  • Purging cache entries
  • Modifying cache parameters and options
  • Seeding the cache
Setting Up and Administering Usage Tracking
  • Tracking and storing Oracle BI Server usage at the detailed query level
  • Using usage tracking statistics to optimize query performance and aggregation strategies
  • Analyzing usage results using Oracle BI Answers and other reporting tools
Multi-user Development
  • Setting up a multi-user development environment
  • Developing a repository using multiple developers
  • Tracking development project history
  • Using Administration Tool wizards and utilities to manage, maintain, and enhance
  • Employing techniques to optimize Oracle BI query performance
  • Applying Oracle BI repository design principles
Working with Oracle Business Intelligence Answers
  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • Using advanced formatting
  • Filtering Requests in Oracle Business Intelligence Answers
  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters
Oracle Business Intelligence Answers: Advanced Features
  • Combining request criteria using set operations
  • Executing direct database requests
  • Editing logical SQL generated by a request
  • Showing Results with Pivot Tables
  • Introduction to pivot tables
  • Formatting pivot tables
  • Setting aggregation rules and building formulas
Building Views and Charts in Requests
  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks
Showing Results with Gauge Views
  • Introduction to Gauge views
  • Working with Gauge views
Creating Oracle Business Intelligence Interactive Dashboards
  • Introduction to Interactive Dashboards and pages
  • Dashboard Editor UI elements
  • Composing dashboard elements
Configuring Oracle Business Intelligence Interactive Dashboards
  • Types of dashboard content
  • Embedding content in Interactive Dashboards
  • Using bookmark links to distribute and save Interactive Dashboards
  • Customizing the Oracle Business Intelligence User Interface
  • Modifying cascading style sheets
  • Modifying XML message files
  • Making configuration changes using the instanceconfig file
Configuring Guided Navigation Links
  • Building guided navigation with static links
  • Building guided navigation with conditional links and sections
Administering the Oracle Business Intelligence Presentation Catalog
  • Maintaining the Oracle BI Presentation Catalog
  • Managing security
  • Understanding security inheritance
  • Describing the Presentation Catalog structure
  • Permission types
  • Setting permissions using the Manage Catalog screen Using Oracle Business Intelligence Delivers
  • Introduction to Oracle BI Delivers
  • Configuring delivery devices
  • Adding delivery profiles
  • Building alerts
  • Introduction to Oracle BI Scheduler
Using Oracle Business Intelligence Publisher
  • Introduction to Oracle BI Publisher
  • Creating a BI Publisher report from an Answers request
  • Creating a BI Publisher report from the BI Server
  • Data Warehouse Administration Console
  • Introduction to DAC
  • Installation of DAC
  • Configuration of Informatica in DAC
  • Creating container and modifying it
  • Create, modify and execute the sample project