OBIEE Developer Online Training

OBIEE Developer Online Training

OBIEE Developer Online Training
OBIEE Developer Online Training

OBIEE Developer Online Training Course Content :

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 Catalog
  • 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 to BI Publisher

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

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim