OBIEE Online Training

OBIEE Online Training



    Learn concepts of self-serve interactive reporting, actionable intelligence and spatial intelligence via map-based visualizations. How to Explore Oracle BI architecture components and physical layer object properties, Building a business model and testing a repository…etc.

    Course Content

    1.Introduction To OBIEE

    • Data warehousing overview
    • Basics of Data Warehousing
    • What is OLTP and OLAP?
    • Difference between OLTP and OLAP
    • Advantages of OLAP
    • What is Data Marts and ODS?

    2.Dimensional Modeling Overview

    • Introduction to Dimensional Modeling
    • What are Facts and Dimensions?
    • Star schema and Snowflake schema

    3.Introduction To Business Intelligence

    • What is Business Intelligence
    • Where BI tools are Used
    • Why the Oracle Business Intelligence
    • Advantages
    • Architecture
    • Components
    • Clients – Answers
    • Delivers
    • Dashboards and Web administration
    • ServersOracle BI server
    • Presentation
    • Scheduler server

    4.Server Architecture

    • Repository Basics
    • What is Meta data?
    • Creating a Repository using BI Administration Tool
    • Business Model and Mapping and presentation layers
    • Properties of repository objects

    5.Building Physical Layer Of A Repository

    • Objects of Physical Layer
    • DSN for a data sources
      Build physical layer

    6.Building Business Model Mapping Layer

    • Objects of BMM layer
    • Building Business model (creating logical tables, columns, joins)
      Creating simple measures

    7.Building Presentation Layer

    • Objects of presentation layer
    • Properties of the presentation layer
    • Build presentation layer

    8.Testing And Validating Repository

    • Checking repository consistency
    • Checking Global Consistency
    • Inspecting Oracle Answers and SQL
    • Inspecting log files (Nqquery.log, NQSserver.log)

    9.Adding Multiple Sources To Dimension

    • De-normalizing tables structures in database design
    • Adding multiple sources to existing logical tables source
    • Adding second table sources

    10.Adding Calculations To Fact

    • Calculation measures on the basis of physical and logical columns
    • Using Calculation wizard

    11.Creating Dimensional Hierarchies And Level Based Measures

    • Creating dimensional hierarchies
    • Using level based measures
    • Creating Rank and Share measures

    12.Using Aggregation

    • Importing Aggregated Tables into Repository
    • Modeling aggregate tables to speed processing

    13.Using Variables

    • Presentation Variables
    • Repository variables
    • Session variables
    • Initialization Blocks

    14.Multi-User Environment (MUD)

    • Overview on Multi-user Environment (MUD)
    • How to create projects in MUD
    • Checkout and check-in of projects

    15.Modeling Time Series Data

    • Types of SCDS
    • Using of time series functions

    16.Modeling Extension Tables

    • Purposes of extension tables
    • Modeling extension tables for fact and dimensions

    17.Oracle BI Security

    • Security at object and data level
    • Creating users and User groups
    • Assigning permissions to users
    • Setting Query limits and timing restrictions
    • Authenticating using an external database

    18.Cache Management

    • Purge cache and event handling tables
    • Making the table cache able
    • Setting of cache in NQSCONFIG.INI file

    19.Oracle BI Presentation Services

    • Working with Oracle BI Answers
    • Building Business Requests using Answers, Adding filters to Business requests, Adding Column Filter Prompts in
    • Answers Views and charts in requests

    20.Creating Oracle Intelligence Dashboards

    • Creating dashboard pages using report requests
    • Creating dashboard prompts
    • Configuring guided navigation links
    • Adding content to dashboard
    • Conditional links and conditional section

    21.Administering OBI Presentation Catalogue

    • Using catalogue management to maintain web catalogue
    • Creating catalogue groups
    • Issuing privileges etc

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies