Oracle Business Intelligence Enterprise Edition (OBIEE)

1. Introduction about DWH and Business Intelligence

2. Build Repositories

a) 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  

b) 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  

c) 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  

d) Building the Presentation Layer of a Repository

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

e) 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  

f) Adding Multiple Logical Table Sources

  • Adding multiple logical table sources to a logical table
  • Specifying logical content  

g) 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  

h) Creating Dimension Hierarchies and Level-Based Measures

  • Creating dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating rank measures  

i) Using Aggregates

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation
  • Using the Aggregate Persistence Wizard  

j) Using Repository Variables

  • Session variables
  • Repository variables
  • Initialization blocks 
  • Using the Variable Manager
  • Using dynamic repository variables as filters  

k) Modeling Time Series Data

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

l) Security

  • 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  

m) Cache Management

  • Restricting tables as non-cacheable
  • Using Cache Manager
  • Inspecting cache reports
  • Purging cache entries
  • Modifying cache parameters and options
  • Seeding the cache  

n) 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  
  • Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories
  • Employing techniques to optimize Oracle BI query performance
  • Applying Oracle BI repository design principles  

3. Oracle BI Presentation Services -Create Reports/Dashboards  
a) Working with Oracle Business Intelligence Answers

  • Introduction to OracleBI Answers
  • Working with requests in OracleBI Answers  

b) Filtering Requests in Oracle Business Intelligence Answers

  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters  

c) Views and Charts in Requests

  • Introduction to Answers views and charts
  • Creating a column selector view  

d) Showing Results with Pivot tables

  • Introduction to pivot tables
  • Formatting pivot tables
  • Setting aggregation rules and building formulas  

e) Creating Interactive Dashboards

  • Introduction to Dashboards and pages
  • Dashboard Editor UI elements
  • Composing Dashboard elements  

f) Configuring Interactive Dashboards

  • Types of Dashboard content
  • Embedding content in Dashboards  

g) Customizing the Oracle Business Intelligence User Interface

  • Modifying cascading style sheets
  • Modifying XML message files  

h) Configuring Guided Navigation Links

  • Building guided navigation with static links
  • Building guided navigation with conditional links and sections  

i) Administering Oracle Business Intelligence Presentation Catalog

  • Maintaining the OracleBI Presentation Catalog
  • Maintaining security
  • Understanding security inheritance  

j) Using Oracle Business Intelligence Delivers

  • Building alerts
  • Building iBots
  • Introduction to OracleBI Scheduler  

k) Using Oracle Business Intelligence Briefing Books

  • Using OracleBI Briefing Books
  • Creating and editing OracleBI Briefing Books  

l) Interactive Dashboard Design Principles and Best Practices

  • Understanding Dashboard design principles  

    1. Exploring on BI Publisher
    2. Exploring on Data Warehouse Administration Console (DAC)

Duration: 25 Hours