OBIEE Online Training

Course OverView

Introduction to OBIEE Online Training

OBIEE is a product of Oracle Corporation. It is a Data Warehousing BI tool. It is very user friendly.  OBIEE is one of the most emerging reporting tools ever since Oracle has taken over Siebel. In the coming days there are going to be many existing and new projects that will be migrated to OBIEE from their existing reporting tools.  And above all OBIEE is very easy to learn and fun to learn, you do not need coding skills, but just a little logic and familiarity with the tool.

About Our OBIEE Trainer

  • Our OBIEE Trainer is into training from last 10 years.
  • He is working as a senior Developer on OBIEE since 5 years.
  • Our online trainer of OBIEE is a real-time employee of CMM- LEVEL V Company.
  • Our OBIEE Trainer has trained many online professionals on OBIEE.
  • The students he trained most are from US and Europe.
  • Online Training techniques of MC are specially designed for the global learners and are globally proven.
  • MonsterClasses has taken utmost care to recruit the trainers for online training.
  • Our trainer is capable of designing sophisticated course material.
  • Our OBIEE Trainer is not only a research scholar but also an enthusiastic learner, which helped him to acquire up-to-date knowledge of the technology.
  • Our Trainers aims at quality teaching, which earned them multitudes of learners.

Highlights of OBIEE

  • Excellent real-time faculty
  • Real-time scenario based training
  • Project testing in real environments
  • Placement assistance
  • Makes you confident, consistent and real-time professional
  • Tailor-made Course Curriculum
  • Online training is learner cantered.
  • Learner can combine education, work and family.
  • Real-time experts are our trainers
  • Most affordable Fee Structure
  • Industry-centric Approach
  • World-class teaching methodology
  • We Provide goal oriented, comprehensive training based on your specific educational needs.
  • We provide free 24/7 server access to help our trainees practice exercises and demos in real-time.
  • We offer Placement options to our learners if required.

Scope of the Course

  • Oracle Business Intelligence Enterprise Edition 11g, the new, industry-leading technology platform for business intelligence, which offers:
  • The Next Generation of Answers (Answers+)
  • Multidimensional, OLAP Analysis
  • OLAP-style query building with member selection
  • Calculated Members
  • Ragged and skip-level hierarchies
  • Hierarchical Calculations
  • Function extensibility
  • Custom Aggregates
  • Uniformly applies to dimensional (OLAP) and relational sources Optimized for Essbase
  • Invoking Business Processes from BI Dashboards
  • Fully Integrated Score carding

Why MonsterClasses for OBIEE

  • Training would be conducted by experienced, real-time worker of Oracle Corporation and certified Instructors.
  • Online inter-active training is a common experience @ MonsterClasses
  • Many students in the past have learned, mastered, got certified and landed in excellent jobs.
  • Our course material is specially designed for online learning
  • Our trainers are technology specialists actively involved in their particular fields.
  • Support for real-time projects by our trainers.
  • 100% job support for desired and excellent candidates.

OBIEE Course Content

DATAWAREHOUSING CONCEPTS

  • Introduction and Definition
  • Sources, Transformations and Targets( Architecture )
  • Data Extraction, Data Transformations and Data Loading( Data Acquisition Process)
  • Data Warehousing Approaches
  • Staging Area, Metadata, Repository and Data Mart
  • Differences between OLTP and OLAP( DSS ) Systems
  • Operational Data Store( ODS )
  • Business Intelligence
  • Star Schema Design & Confirmed Dimension, Fact less Fact Table, Types of Facts
  • Slowly Changing Dimensions( SCD )

OBI Overview

NEW FEATURES OF OBI

OBI ARCHITECTURE

  • Clients
  • OBI Presentation Services
  • OBI Server
  • OBI Repository (.rpd)
  • Data Sources

OBI COMPONENTS

  • OBI Administration Tool
  • OBI Answers
  • Intelligence dashboards

REPOSITORY BASICS

  • Oracle Business Analysis Warehouse
  • DAC and Informatica Server
  • Informatica Server ETL
  • Sample Request Processing
  • Using the Oracle BI Administration Tool
  • Repository Directory
  • Repository Files ( Initialization files and log files)
  • Informatica Server ETL 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

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

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

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
  • Message Severity
  • viewing Server Logs

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

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

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
  • Adding Multiple Logical Table Sources
  • Adding multiple logical table sources to a logical table
  • Specifying logical content

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

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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES

  • Creating dimension hierarchies
  • Creating level-based measures

Providing Security for Groups & Users

ANSWERS (REPORTS)

WORKING WITH ORACLE BUSINESS INTELLIGENCE ANSWERS

  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • Using advanced formatting
  • Creating report Level Hierarchy

FILTERING REQUESTS IN ORACLE BUSINESS INTELLIGENCE ANSWERS

  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters

BUILDING VIEWS AND CHARTS IN REQUESTS

  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks
  • Creating a Narrative View
  • Creating a column Selector

SHOWING RESULTS WITH PIVOT TABLES

  • Introduction to pivot tables
  • Formatting pivot tables
  • Setting aggregation rules and building formulas

CREATING ORACLE BUSINESS INTELLIGENCE INTERACTIVE DASHBOARDS

  • Introduction to Interactive Dashboards and pages
  • Adding Objects to Dashboard
  • Creating Dashboard prompts
  • Embedding content in an Interactive Dashboard
  • Define repository in terms of Siebel Analytics?
  • What is the end to end life cycle of Siebel Analytics?
  • What were you schemas? How does Siebel Architecture works? Explain the three layers. How do you import sources?
  • If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no then what is the option? Why you won’t join fact to fact?
  • What is connection pool and how many connection pools did you have in your last project?
  • What is the purpose of Alias Tables?
  • How do you define the relationship between facts and dimensions in BMM layer?
  • What is time series wizard? When and how do you use it?
  • Did you create any new logical column in BMM layer, how?
  • Can you use physical join in BMM layer?