Call now to OBIEE Training +91 9620196773, +91 8884684156
OBIEE Training EMAIL info@iqstreamtech.com
Call for Free Demo +91 9620196773, +91 8884684156, 080-42073645

Course Details

Enquiry Form



Oracle OBIEE Training in Bangalore

IQ Stream Technologies is one of the top Oracle OBIEE Training (Oracle Business Intelligence Enterprise Edition 11g ) institutes in Bangalore with highly experienced and skilled trainers. IQ Stream Technologies Bangalore also offers placement assistance for students who enrolled in Advanced Oracle OBIEE Courses. We offer advanced Oracle OBIEE training classes in Bangalore BTM area and you will learn datawarehousing concepts, OBIEE Installation & Configuration, Oracle Business Intelligence, OBIEE Repository Design & Development and more advanced tools for better learning, understanding and experience. We offer top quality classrooms, learning ambience, advanced and most updated syllabus in OBIEE Oracle Business Intelligence Enterprise Edition 11g Training like other top quality OBIEE Training institutes in Bangalore.

Expert OBIEE Training Institute

Oracle Business Intelligence Enterprise Edition (OBIEE) is a Business Intelligence (BI) tool by Oracle Corporation. Become and Expert in Oracle OBIEE with IQ Stream Technologies' advanced Oracle OBIEE learning programmes. Main highlights of our Oracle OBIEE Training in Bengaluru (BTM Layout 1st Stage) include ‎OBIEE Data Warehouse, ‎OBIEE Basics, ‎OBIEE Repositories, OBIEE Prompts, Intensive Practical Training, Advanced Learning Materials & Tools, Friendly Classrooms, hands-on labs, etc. IQ Stream Technologies offer beginner, intermediate and advanced lessons for you to become an expert in the area.

OBIEE Training in Bangalore

OBIEE Training Location at BTM:

IQ Stream Technologies Oracle OBIEE Training Training Institute Location: BTM Layout, Bangalore
Mobile : +91 9620196773, +91 8884684156
Landline: +91 80 42073645​
Email: info@iqstreamtech.com
Address: #3, 8/2 Anugraha Complex, 1st E Cross,
20th Main, Maruti Nagar Main Road,
BTM Layout 1st Stage, Bangalore - 560029
OBIEE Training in BTM Layout

Highlights of Our OBIEE Training in Bangalore

- Intensive Practical Training
- Advanced Learning Materials & Tools
- Friendly Classrooms
- Practical Guidance
- Advanced Lab Facility
- Placement Oriented
- Expert and Experienced Trainers

Oracle OBIEE Training Syllabus

OBIEE Training Syllabus

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 )

OBIEE Installation & Configuration

• Installation of Database
• Installation of OBIEE Meta Data using Repository Creation Utility.
• Installation and Configuration of OBIEE.
• Testing of Sample Reports and RPD.
• Configuration of BI Sample schemas.

Introduction to Oracle Business Intelligence

• What is BI ?
• What are the other BI tools ?
• What is OBIEE ?
• History of OBIEE ?
• What you are going to learn in OBIEE ?
• Introduction on OBIEE Repository Design & Development
• Introduction on OBIEE Answers and Dashboards

OBI ARCHITECTURE

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

OBI COMPONENTS

• OBI Administration Tool
• OBI Answers
• Intelligence dashboards

Part 1 OBIEE Repository Design & Development

REPOSITORY BASICS

• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Creating a repository
• Connection Pool
• Repository Modes ( ONLINE and OFFLINE )
• Physical Layer
• Business Model & Mapping Layer
• Presentation Layer
• Presentation Catalogs, Folders and Columns

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

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

USING VARIABLES & INITIALIZATION BLOCKS

• Understanding different types of Variables.
• Creating Repository Variables and session variables and using them in the OBIEE environment
• Creating and setting Presentation variables in obiee reports and dashboards.

CREATING TIME SERIES MEASURES

• Using time comparison in business analysis.
• Using Oracle BI time series functions to model time series data

Security in OBIEE

• Oracle Platform Security Service
• Exploring Oracle BI default security settings
• Creating users and groups

Part-2 OBIEE Answers & DashBoards(REPORTS DEVELOPMENT)

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 column Selector
• Creating View 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
• Usage of presentation variables

OBIEE Advanced Concepts : Master-Detail linking ,KPI's etc

OBIEE Environment in different software companies

• Explain the Real time OBIEE Environment in the software Companies
• Explain the different support groups which are part of OBIEE project
• The way OBIEE project is developed
• Roles and Responsibilities of the Developer,Lead, Testers,etc
• OBIEE Requirement Analysis
• OBIEE Design and Development
• OBIEE testing dev and uAT
• OBIEE Migration
• OBIEE Infant Care