OBIEE 11 Training

Syllabus

Module 1

  • OBIEE Overview
  • OBIEE Architecture
  • Clients
  • OBIEE 11 BI Services
  • OBIEE Weblogic Admin
  • OBIEE Repository (rpd)
  • Data Sources

Module 2

  • OBIEE Components
  • OBIEE Administration Tool
  • OBIEE Analysis
  • Intelligence Dashboards
  • BI Publisher-BI Agents/Actions-KPI/Scorecard
  • BI Office

Module 3

  • Repository Basics
  • Oracle Business Analysis Warehouse
  • Weblogic Server
  • Enterprise Manager
  • Sample Request Processing
  • Using the OracleBI Administration Tool
  • Repository Directory
  • Repository Files ( Initialization files and log files)
  • Loading a repository into Oracle BI Server memory
  • Creating a repository
  • Connection Pool
  • Repository Modes ( ONLINE and OFFLINE )
  • Physical Layer
  • Business Model & Mapping Layer
  • Presentation Layer
  • Presentation Catalogs, Folders and Columns
  • Error Messages

Module 4

  • Building the Physical Layer of a Repository
  • Defining an ODBC System DSN
  • Setting up connection pool properties
  • Importing data sources ( Physical Schema )
  • Verifying the import
  • Defining physical keys and joins
  • Creating alias and select tables

Module 5

  • Building the Business Model and Mapping Layer of a Repository
  • Creating the logical business model
  • Creating the logical tables, columns, and sources
  • Defining logical joins
  • Adding Calculation to a Fact Table
  • Building measures

Module 6

  • Building the Presentation Layer of a Repository
  • Creating a new Presentation Catalog
  • Modifying Presentation layer objects
  • Rename tables
  • Reorder Table
  • Testing and Validating a Repository
  • Checking repository consistency
  • Defining a repository in the initialization file
  • Testing a repository using Oracle BI Answers
  • 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

Module 7

  • Creating & Using Aggregates
  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation
  • Using Initialization Blocks Repository Variables
  • Creating Dynamic Repository Variables
  • Execute Direct Database Requests
  • Accessing database directly
  • Creating Time series Measures
  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data
  • BI Analysis and Dash board & Publisher
  • Creating and Editing Analysis
  • Creating Interactive Dashboards using Analysis
  • Creating query and chart

Module 8

  • Working with Filters
  • Working with Pivot Table
  • Building Views and Charts in Requests
  • Creating and Configuring Interactive Dashboards
  • Creating and Configuring Dashboard Prompts
  • Configuring Action Links
  • Creating and understanding KPI,KPI Watchlists and Scorecards
  • Oracle BI for MS Office
  • Sending Alerts Using Delivers
  • Using Job Manager
Developed by God Particles
Back to Top