OBIEE Online Training

Course Overview

OBIEE 11g online training 

Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine.
Oracle Business Intelligence online training is designed for every learner to bring greater business visibility and insight to a wide variety of users.
OBIEE training provides a full range of business intelligence capabilities that allow you to:
  •   Collect up-to-date data from your organization
  •   Present the data in easy-to-understand formats (such as tables and graphs)
  •   Deliver data in a timely fashion to the employees in your organization
  •   These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.
OBIEE online training provides a solid foundation on OBIEE 11g step-by-step procedures for building and verifying the three layers of an Oracle BI repository.
Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive Dashboard, Delivers, OBIEE 11g/Fusion Middle ware Security and OBIEE-BI Publisher integration.

Oracle Business Intelligence course is designed for those professionals who are looking for Great career as Consultant in BI Technology.

 OBIEE  Online Course Content

OBIEE 11g COURSE STRUCTURE

Duration:30 Hours


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 OracleBI Administration Tool
  • Repository Directory
  • Repository Files ( Initialization files and log files)
  • Informatica Server ETLLoading 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
Note: All Training will be on BI Sample Schema.
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

Course Highlights

Highlights of OBIEE Training 

  • OBIEE online trainer will mostly concentrate on real time issues rather than simply teaching you the OBIEE course. This will    help you when you join the job and while attending interviews.
  • OBIEE online trainer will give you all possible interview questions with answers and take a preliminary interview to build your confidence. This will help you how to answer in the interview.
  • We will give you OBIEE job support if you get any issues in the real time.
  • Our OBIEE online trainer will give you complete OBIEE material for your reference which nobody will have in general.
  • You can join after attending the two free live demo classes.
  • Our OBIEE online trainer will explain you the real time requirements in OBIEE at clients place so it will be easy for you after joining the first job.
  • Our OBIEE online trainer will give you Introduction to Informatica and DAC financial analytics which are advanced topics in OBIEE, which will help you getting a job very easily.
  • Online training of OBIEE is our trainer’s passion; they do not run a professional training institute that teaches all the courses. They will only teach OBIEE and nothing else.
  • Our OBIEE online trainer will make you to love the subject you are learning. This is the most important thing that most of the online trainers will miss.
  • We will provide complete installation guide of OBIEE and Oracle in your computer. And will login to your computer and help if you are not able to install.
About Trainer

Trainer Information 

  • Having 6 Yrs of IT exp
  • And 3.5+ yrs of OBIEE and DWH Exp
  • Having exp 2yrs as an online trainer for obiee.
  • Held up to 80+ batches in past 1yr.
  • Worked with future point, Focus Thread, Kennedy International and various pvt projects
Subscribe to: Posts (Atom)