OBIEE Trainig – Best OBIEE Training in Chennai

OBIEE Training – Best OBIEE Training in Chennai 


Bound techs solutions offer world class OBIEE training (Online & classroom training in Chennai). Bound tech solutions providing best OBIEE training with “real – time projects”. We have a crew with highly professionalized OBIEE trainers, those are working in top MNC’s . During OBIEE training you will learn with real- time “corporate projects” .So that you can get hands on experience in OBIEE. Apart from training, our trainers whose working in corporate will share guidelines to get placements. So we are the best OBIEE online training and class room training institute in Chennai.


Training with Real Time Projects – World Class Tutorship
Placement Assistance – Online & Class Room Training

oracle business intelligence training

What is OBIEE


Oracle Business Intelligence Enterprise Edition  (OBIEE) is an comprehensive business intelligence (BI) and analytics platform developed by oracle corporation. OBIEE  supports the highest workloads and most complex deployments because of its modern technological  foundation. OBIEE Interactive Dashboards provides fully an interactive collection of dashboards and reports with a rich variety of visualizations


OBIEE allows user to create flash reports, report templates, and ad-hoc reporting for end users. It allows integration with major data sources and can also be integrated with third party vendors like Microsoft PowerPoint presentations and word documents.


The functionality of OBIEE including  Interactive Dashboards , Ad hoc Analysis and Interactive Reporting, Mobile Analytics, Enterprise Reporting, Proactive Detection and Alerts, Actionable Intelligence, Microsoft Office Integration, Spatial Visualizations and Analytics, Scorecard and Strategy Management, Server based query, reporting, and analysis .

OBIEE Training Module

(OBIEE online training & Class room training in Chennai)




Day – 1

  • Data warehouse Architecture
  • Data warehouse Vs Data Mart
  • ETL
  • Measures, Fact, Dimensions
  • Schema
  • Star Schema
  • Snowflake Schema
  • Dimension Hierarchy
  • Slowly Changing Dimension
  • Type 1
  • Type 2
  • Type 3
  • Data Modeling
  • Fact Less fact table
  • Junk Dimension
  • Data Ware House Tools
  • Confirm Dimension


Oracle SQL


Day 2

  • How to create schema’s
  • How to Import Data (Sample)
  • How to Export Date (Sample
  • How to Grant Permissions
  • How to add new connections in Database
  • Some Basic SQL Commands
  • How to create tables and columns




Day 3

  • Repository Basics
  • Oracle BI architecture components
  • Repository structure, features, and functions
  • Using the Oracle BI Administration Tool
  • Creating a repository


Day 4

  • Building the Physical Layer of a Repository
  • Importing data sources, Tables and Columns
  • Setting up connection pool properties
  • Defining keys and joins
  • Examining physical layer object properties
  • Creating alias and select tables
  • Loading a repository into Oracle BI Server memory


Day 5

  • Building the Business Model and Mapping Layer of a Repository
  • Building a business model
  • Building logical tables, columns, and sources
  • Defining logical joins
  • Building measures
  • Examining business model object properties


Day 6

  • Building the Presentation Layer of a Repository
  • Exploring Presentation layer objects
  • Creating Presentation layer objects
  • Modifying Presentation layer objects
  • Examining Presentation layer object properties
  • Testing and Validating a Repository
  • Checking repository consistency


Day 7

  • Turning on logging
  • Testing a repository using Oracle BI Answers
  • Inspecting the query log


Day 8

  • Adding Multiple Logical Table Sources
  • Adding multiple logical table sources to a logical table
  • Specifying logical content


 Day 9

  • Adding Calculations to a Fact Table
  • Creating new calculation measures based on existing logical columns
  • Creating new calculation measures based on physical columns
  • Using Aggregates


Day 10

  • Creating Dimension Hierarchies and Level-Based Measures
  • Creating dimension hierarchies
  • Creating level-based measures
  • Modeling Time Series Data
  • Using time comparisons in business analysis


Day 11

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation


Day 12

  • Using Partitions and Fragments
  • Purpose for segmenting data into partitions and fragments


Day 13

  • Use of Joins Like Complex Join, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
  • Initialization Blocks and Variables.
  • Repository Utilities
  • calculation by using calculation wizard


Day 14

  • All Types of Functions in BMM Layer
  • Rename and Re-Arrange Wizard


Day 15

  • Building Views
  • Multiple use of Alias Table
  • Modelling Bridge Table


Day 16

  • Cache Management
  • Implicit Fact Column
  • Creating Hierarchy in Presentation Layer
  • Event Pooling Usage Tracking


Day 17

  • About EM
  • About Console
  • Path Location
  • Log Files
  • Configuration Files


Oracle BI Answer Side (Catalog)


Day 18

  • Catalog Manager Options
  • Migrations


Day 19

  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • How to access Subject Areas
  • Basic Reporting


Day 20

  • Formatting
  • Filters
  • Using advanced formatting
  • Filtering Requests in Oracle Business Intelligence Answers
  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters


Day 21

  • Types of View


Day 22

  • Oracle Business Intelligence Answers: Advanced Features
  • Combining request criteria using set operations
  • Executing direct database requests


Day 23

  • Building Views and Charts in Requests
  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks
  • Showing Results with Gauge Views
  • Introduction to Gauge views
  • Working with Gauge views
  • Showing Results with Pivot Tables
  • Introduction to pivot tables
  • Formatting pivot tables


Day 24

  • Setting aggregation rules and building formulas
  • Creating Oracle Business Intelligence Interactive Dashboards
  • Introduction to Interactive Dashboards and pages
  • Dashboard Editor UI elements
  • Composing dashboard elements
  • Types of dashboard content


Day 25

  • Using Prompts
  • Scope of the Prompt
  • Presentation Variable and Uses
  • Request Variable


Day 26

  • Combine Request
  • Direct Database Request


Day 27

  • Customizing the Oracle Business Intelligence User Interface
  • Making configuration changes using the instance config file
  • Configuring Guided Navigation Links
  • Building guided navigation with static links
  • Building guided navigation with conditional links and sections
  • Administering the Oracle Business Intelligence Presentation Catalog
  • Maintaining the Oracle BI Presentation Catalog


Day 28

  • Managing security
  • Understanding security inheritance
  • Permission types – Object Level Security/Data Level Security
  • Setting permissions using the Manage Catalog screen
  • Creating users and groups
  • Setting permissions for users and groups
  • Setting query limits and timing restrictions


Day 29

  • Introduction to Oracle BI Scheduler
  • Using BI Deliver
  • Configuration of Scheduler Service
  • Creating & scheduling iBots


Day 30

  • Using Repository Variables
  • Session variables
  • Repository variables
  • Initialization blocks
  • Using dynamic repository variables as filters


Day 31

  • Setting filters to personalize information
  • Cache Management
  • Inspecting cache reports
  • Purging cache entries
  • Modifying cache parameters and options
  • Seeding the cache


Day 32

  • Creating selection steps
  • Creating groups
  • Creating calculated items
  • Including advanced SQL clauses in your analysis
  • Providing Real Time Scenarios on RPD and Answer Side


Day 33

  • Interview Perspectives 1


OBIEE Training (Online Training)


Bound tech solutions Chennai, provide SAS online training for student’s from other states and country via skype, Google Hangouts,Citrix etc… Online training is more convenient for oversees students and working people. Online training more flexible with us. We are the best SAS online training Institute.


OBIEE training in Chennai (Classroom Training)


We also conduct classroom training with our highly configured world class training rooms. You can easily reach our center form Chrompet, Tambaram and Sanitorium. We are the best  Institute for OBIEE  training in Chennai