OBIEE

OBIEE 11g Course Topics:

Class 1: Data Warehousing Concepts

      • Data Warehouse
      • Basics of Data Warehousing
      • What is OLTP and OLAP?
      • Difference between OLTP and OLAP
      • Dimension, Fact, Aggregate tables
      • Star Schema, Snowflake schema
      • Star Schema vs Snowflake Schema

Class 2: OBIEE Overview

      • What is OBIEE?
      • Introduction to OBIEE 11G
      • Based on Fusion Middleware 11g Platform
      • End-to-End Life Cycle of OBIEE
      • Oracle BI Architecture 11g
      • Oracle BI Components 11g

Class 3: Installation of OBIEE

Class 4, 5: RPD & Catalog Basics

      • Repository Basics
      • Metadata & Catalog Basics
      • Physical, BMM, Presentation layers Overview
      • RPD Online Mode and Offline Mode
      • Answers, Dashboards, Administration
      • Repository & Catalog Deployment
      • Start/Stop Weblogic& BI Services
      • Administration files, Logs, Services, Folders
      • OPMN

Class 6: Building the Physical Layer of a Repository

      • Create a New Repository
      • Import Metadata
      • Verify Connection
      • Properties of Physical Layer Objects
      • Creating Aliases, Physical Keys and Joins

Class 7: Building the BMM Layer of a Repository

      • Creating Business Model
      • Properties of BMM Layer Objects
      • Examine Logical Joins, Logical Columns, LTS
      • Rename Logical Objects Manually
      • Rename Logical Objects Using the Rename Wizard
      • Delete Unnecessary Logical Objects
      • Create Simple Measures

Class 8: Building the Presentation Layer of a Repository

      • Creating Presentation Layer Objects
      • Properties of Presentation Layer Objects
      • Rename Presentation Columns
      • Reorder Presentation Columns
      • Creating Nested Structure

Class 9: Testing & Validating a Repository

      • Check Global Consistency
      • Load the Repository
      • Understanding Logging Levels
      • Set Up Query Logging
      • Validating Query Logging

Class 10: Managing LTS, Calculated Measures

      • Add a New Logical Table Source
      • Create Presentation Layer Objects
      • Validation of Multiple LTS
      • Create a Calculation Measure Derived from Existing Columns
      • Create a Calculation Measure Using a Function

Class 11: Dimension Hierarchies, Level Based Measures

      • Creating Dimension Hierarchies
      • Validating Drill Down feature
      • Creating Level Based Measures

Class 12: Aggregates, Ragged & Skipped Level Hierarchy

      • Modelling Aggregate Tables
      • Validating Aggregate Navigation
      • Creating Ragged & Skipped Level Hierarchy

Class 13: Functions (Part 1)

      • Calendar Date/Time Functions
      • Conversion Functions
      • Display Functions
      • Evaluate Functions
      • Lookup Functions

Class 14: Functions (Part 2)

      • Mathematics Functions
      • String Functions
      • System Functions
      • Time Series Functions

Class 15: Variables

      • Understanding Variables
      • Creating Session Variables
      • Creating Repository Variables
      • Creating Initialization Blocks
      • Referencing Variables

Class 16: Working with Analytics

      • Introduction to Analytics
      • Creating a Report
      • Using Analysis Editor
      • Saving Reports

Class 17: Formatting, Sorting, Filters

      • Formatting & Sorting the Reports
      • Creating Filters
      • Creating Saved Filters

Class 18, 19: Working with different Report Views

      • Title View
      • Table, Pivot View
      • Graphs, Gauges
      • Legend
      • Narrative View
      • Static Text
      • Column/View Selector

Class 20: Creating Dashboards, Prompts, Presentation Variables

      • Creating Prompts
      • Creating Dashboards
      • Running a Dynamic Report on a Dashboard
      • Working with Presentation Variables

Class 21: Dashboard Pages, Union Reports, Examples

      • Creating Dashboard Pages
      • Advanced Dashboard Properties
      • Creating Union Reports
      • Practical Scenarios

Class 22: Action Links

      • Understanding Action Links
      • Navigating to a Report
      • Navigating to a Web Page

Class 23: Scorecards & KPI’s

      • Creating KPIs, KPI Watchlist, Scorecards
      • Displaying Scorecards on a Dashboard

Class 24: Securities