OBIEE 11g Online Training Course

Duration : 4-5 Weeks
Data Warehousing Basic Concepts
  • Data Warehouse Definition,
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
Architecture of Date Warehouse
  • Process flow In DWH
  • Components of Architecture
  • Source, Integration Layer, Staging Area, ODS.
  • Technical Architecture of Back Room
  • Architecture of Front Room
  • Infrastructure Metadata
Implementation Methodology
  • Kimball Methodology
  • Inmon Methodology
Types of Loads
  • First Time Load
  • Full Load
  • Incremental Load
Data Marts and Star Schema Design
  • Definition of Star Schema
  • Data Marts Reasons for Construction
  • Replacement of Data Mart With Warehouse
  • Design process
  • Design of Dimension and Facts
  • Snow Flake Star Schema
  • Summary Tables
  • Slowly Changing Dimensions
  • Non Additive Facts
  • Conformed Dimensions
  • Types of OLAP ROLAP, DOLAP, HOLAP, MOLAP
Fundamentals of ETL Architecture
  • Scope of ETL Determination
  • Need for ETL metadata
  • Tools Vs Manual Development
  • Selecting and Setting ETL Architecture
  • Extract Analysis
  • Target Table Refresh Strategy
  • Transformations
  • Job Scheduling
ORACLE 11g
  • Overview of Business Analysis
  • Introduction to OBIEE
  • Importance and features of the tool
  • Overview of Oracle BI Components
  • Gather information to start building Business Model
  • Architecture of OBIEE
  • Create OBDC Connections
  • Importing a data source
  • Defining Keys and Joins
  • Defining the Repository logical Structure
  • Measures
    • Building simple Fact Measures
    • Customizing the presentation Catlog
    • Testing the repository
    • Checking Consistency
    • Importing Additional Product Tables
    • Creating Multiple Sources for a logical Table source
    • Specifying the Most Economical Source
    • Creating Calculation Measures using Logical columns
    • Creating Calculation Measures using Physical columns
    • Creating Calculation Measures using Calculation Wizard
    • Creating Level Based Measures
    • Define Share Measure and Rank Measures
  • Partition
    • Types of Partitions
    • Modeling a Value Based Partition
  • Using Dynamic Repository Variables
  • Time Series functions
  • Creating Users and Groups
  • Assigning permissions to users
  • Security
    • Object Level Security
    • Data Level Security
    • Setting Query Limits
  • Cache Management
    • Introduction to Cache
    • Cache Features
    • Modifying Cache Parameters
    • Purge the Cache
  • Report developer
    • Introduction to Reports
    • Different views
    • Dashboard
    • Creating and Modifying Reports
    • Creating Dashboards
    • Dash boards pages
    • Working with dash board objects
    • Working with filters and prompts
    • Guided Navigation Links
      • Static
      • Dynamic
  • Introduction and working with ODBC Client
  • Introduction to BI Publisher
  • Introduction to DAC
  1. Send us which course you want to join.
Have a Query?