OBIEE Online Training

OBIEE (Oracle Business Intelligence Enterprise Edition) online training by United Training’s. OBIEE is reporting tool, OBIEE online training is a customized course content prepared by our well industry experts. ¬†

Demo Session:-

Course Content РOBIEE online training

Data warehouse Concepts

  • DATA AND TYPES OF DATA
  • OLTP (ONLINE TRANSACTION PROCESSING)
  • OLAP(Online Analytical Processing)
  • Difference between OLAP and OLTP
  • Data warehouse
  • Data Mart
  • Basics of Data Warehousing
  • Dimensional Modeling Overview
  • Types of Tables
    • Dimensional table
    • Fact Table
    • Aggregate Table
  • Difference between Fact and Dimension Tables
  • Difference between Fact and Aggregate Tables
  • Schema and Types of Schema
    • Star Schema
    • Snowflake Schema
  • Mixed or Fact Contellation
  • Difference between Star and SnowFake Schema
  • Types of Facts
  • Types of Fact Tables
  • Types of Dimensions
  • Factless Fact Table
  • Level of Granularity
  • Grain
  • SCD TYPE’S

OBIEE Overview

  • Introduction to Nquire
  • Introduction to Siebel Analytics
  • Introduction to OBIEE 10 G
  • Introduction to OBIEE 11 G
  • What is Obiee?
  • End to End Life Cycle of Obiee
  • Advantages of Obiee
  • End to End Life Cycle of Obiee
  • Types of Reports
  • Types of Applications
  • Components OF Obiee
  • Client Components Of Obiee
  • Types of Servers
  • Obiee Architecture
  • Difference between Obiee 10g and Siebel Analytics
  • Difference between Obiee 10g and Obiee 11g
  • Obiee11.1.1.7 new features

Repository Basics

  • What is Meta data?
  • Creating a Repository using BI Administration Tool
  • Physical, Business Model Mapping, and presentation layers
  • Properties of repository objects
  • Online Mode and Offline Mode

Physical Layer

  • Physical Layer from Relational Data Sources
  • Database Objects
  • Properties of Connection Pools
  • Physical Tables
  • Alias Tables
  • Physical Layer Folders
  • Physical Joins
  • Complex Joins
  • Defining Physical Foreign Keys and Joins
  • Viewing Data in Physical Tables or Columns
  • Creating and Editing a Column in a Physical Table
  • Fragmented Data
  • Primary Key and Foreign Key Relationships
  • Opaque Views

Business Model and Mapping Layer

  • Business Model Objects
  • Duplicate Business Model and Presentation Catalog
  • Logical Tables
  • Logical Columns
  • Logical Table Sources (Mappings)
  • Dimensions and Hierarchical Levels
  • Unbalanced (Ragged) and Skip-Level Hierarchies
  • Parent-Child Hierarchies
  • Subject Areas for Logical Stars and Snowflakes
  • Display Folders
  • Logical Joins
  • Level Based Measures
  • Aggregation Navigation
  • Time Series Function
  • Fragmented Content,Where Cluase,Logical Levels

Presentation Layer

  • About the Presentation Layer
  • Subject Areas
  • Presentation Tables and Columns
  • Presentation Hierarchies and Levels
  • Permissions for Presentation Layer Objects
  • Creating Aliases (Synonyms) for Presentation Layer Objects
  • Implicit Fact Column
  • Nested Folders
  • Controlling Presentation Object Visibility

Config Files

  • Nqs Config
  • Nqs Server
  • Nqs Query
  • Instance Config

Variables

  • Repository Variables
  • Static and Dynamic
  • Session Variables
  • System and Non System Variables
  • Initialization Blocks
  • Row Wise Initialization
  • Presentation Variable
  • Requset Variable

Cache

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

Security

  • Authentication
  • Authorization
  • Authorization Types
    • Data level Security
    • Object Level Security
  • Authentication Types
    • LDAP Authentication
    • External Table Authentication
  • Application Roles
  • Users and Groups

Analysis

  • Types of Views
  • Column Properties
  • Filters
  • Manage Session
  • Advanced Tab
  • Actions and Conditions
  • Scorecards, KPI, KPI Watchlist

Prompts

  • Inline and Dashboard Prompts
  • Column Prompt
  • Image Prompt
  • Variable Prompt

Administering Oracle Business Intelligence Presentation Catalog

  • Maintaining the OracleBI Presentation Catalog
  • Maintaining security
  • Understanding security inheritance
  • Using Oracle Business Intelligence Delivers
  • Building alerts
  • Building Agents
  • Introduction to OracleBI Scheduler

Performance and Troubleshooting

MUDE(Multiuser Development Environment)

Catalog manager

Write Back ,Usage Tracking

Moving from development to Test to Production