Oracle – Business Intelligence

4 Star Rating: Very Good 4.50 out of 5 based on 232 ratings.

Croma Campus which is an ISO 9001:2008 certified training institute in Noida which is foremost IT Training Institute leveraging from past 15 years. Our expertise and technical trainers have designed the course “Oracle- Apps Business Intelligence” for college students, freshers, professional, non-professionals anyone who wants to make a bright career in Oracle which has huge scope and in high demand in the Industry. Oracle-Business Intelligence is a comprehensive and innovative Business Intelligence platform that provides whole range of BI Capabilities.

If you feel that you don’t have such knowledge and still you want to go for this then not an issue because we have designed the course keeping in mind the different levels of student’s basic and advanced level. We have batches as per students convenience weekdays and weekend. You can attend a demo class free of cost and can register yourself thereafter.


  • Basic computer knowledge
  • Familiarity of data processing
  • Basic knowledge of Oracle & Database.

Key Features of Oracle – Business Intelligence Training are:

  • Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
  • Video Recording of every session will be provided to candidates.
  • Live Project Based Training.
  • Job-Oriented Course Curriculum.
  • Course Curriculum is approved by Hiring Professionals of our client.
  • Post Training Support  will helps the associate to implement the knowledge on client Projects.
  • Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
  • Interview calls till placement.

Creating a Repository Using the Oracle BI 11g Administration Tool

  • Overview
  • Building the Physical Layer of a Repository
  • Building the Business Model and Mapping Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing and Validating a Repository
  • Managing Logical Table Sources
  • Creating Calculation Measures
  • Creating Logical Dimensions with Level-Based Hierarchies
  • Creating Level-Based Measures
  • Creating Logical Dimensions with Parent-Child Hierarchies
  • Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies
  • Using Aggregates
  • Using Initialization Blocks and Variables
  • Creating Time Series Measures

Integrating Oracle Essbase with Oracle Business Intelligence 11g

  • Importing a Multidimensional Data Source into a Repository
    • Importing an Essbase cube into the repository.
    • Exploring the multidimensional schema in the Physical layer
    • Converting the Measure dimension to flat measures
    • Verifying the connection to the Essbase data source
    • Creating the business model
    • Creating the subject area
  • Performing Ad Hoc Analysis on the Imported Data Source
    • Creating a simple chart

Merging and Importing from Different Repositories Using Oracle BI 11g 

  • Examining Merge Scenarios
    • Describing Merge Types
  • Merging Objects from Different Repositories with a Common Parent (Standard Three-Way Merge)
  • Merging Objects from Different Repositories without a Common Parent (Two-Way Merge)

Setting Up a Multiuser Development Environment (MUDE)

  • Preparing the Environment – Initial Administrative Tasks
  • Working in a Multiuser Development Environment
  • Checking In and Publishing a MUDE Project

Federating Essbase and Relational Data in Oracle BI 11g

  • Building a Business Model to Provide Horizontal Federation
    • Adding Relational Measures
    • Creating Logical Joins in the Business Model: Products Dimension
    • Creating a Subject Area and Saving the Repository
    • Verifying your Work in Oracle BI EE
  • Building a Business Model to Provide Vertical Federation
    • Modifying the Months Hierarchy for Vertical Federation
    • Mapping Facts to Multiple Sources and Setting Logical Levels
    • Checking Vertical Federation in Oracle BI EE

Setting Up Usage Tracking in Oracle BI 11g

  • Creating the Usage Tracking Subject Area in the Repository
  • Configuring Usage Tracking in Enterprise Manager
  • Populating the Usage Tracking Table and Verifying Usage Tracking
  • Creating Aggregates using Aggregate Persistence Wizard in Oracle BI 11g

Setting Up the Data Schema in Oracle Database 

  • Creating the Aggregates
  • Verifying that the Aggregates were Successfully Created
  • Creating Analysis to Use the Aggregates

Setting Up and Running Summary Advisor on an Exalytics Machine

  • Deleting Aggregates
  • Setting Up Summary Advisor
  • Running Summary Advisor Wizard
  • Creating Aggregates
  • Using the Aggregates

Oracle BI EE ( New Features

  • Presentation Services
    • Selecting a Recommended Visualization
    • Using Breadcrumbs to Navigate Oracle BI Content
    • Creating Custom Print Layouts
    • Freezing Dashboard Columns
    • Creating a Performance Tile View
    • Using the Current View or All Views Option
    • Limiting Values in a Column Prompt Value List
    • Replacing an Analysis in a Dashboard
    • Specifying Fixed Headers or Paging Controls
  • BI Mobile
  • Installation
  • Metadata Repository
  • System Administration
  • Security

Creating Analyses and Dashboards 11g (OBI EE

  • Beginning the Analytic Process
  • Creating Analysis
  • Adding a Graph to an Analysis
  • Working with Pivot Tables, and Master-Detail Linking
  • Adding Performance Tile to an Analysis
  • Adding a Simple Trellis to an Analysis
  • Working with Other View Types
  • Building Dashboards
  • Prompting to Filter Analysis

Integrating Oracle BI EE with Oracle Hyperion Smart View for Office

  • Setting Up Smart View
  • Inserting Oracle BI EE Views into Smart View Clients
  • Working with Views in Smart View Clients
  • Copying and Pasting Oracle BI EE Objects
  • Creating and Publishing Views Using the View Designer

Creating and Using Action Links and Actions

  • Enabling BI Navigation
    • Log in to Oracle BI EE and Create an Analysis
    • Add an Action Link to the Analysis
    • Test the Action Link
    • Save the Action in the Presentation Catalog
  • Enabling Web Navigation and Passing Parameters
    • Set the Action Link to Display Conditionally
  • Creating a New Action
    • Execute the Action
  • Creating a Web Service Action
  • Consuming Actions

Creating and Deploying Custom Styles, Skin, and Messages in Oracle BI 11g

  • Deploying analyticsRes and developing a Custom Skin
    • Exposing a Static Directory in WebLogic Server
    • Deploying a Custom Skin
  • Deploying a Custom Style
  • Deploying Custom Messages

Sending Alerts in Oracle BI EE 11g by Using Oracle BI Delivers

  • Installing the ArGoSoft Mail Server
  • Configuring the eMail Client
  • Creating a New Analysis
  • Creating a Condition-Based Agent/Alert
  • Verifying the Mail Client for the Agent/Alert

Getting Started with Oracle BI Publisher 11g (

  • General Navigation and Preferences
    • Logging in to Oracle BI Publisher and Navigating Through the Home Page
    • Browsing the Catalog and Viewing Reports
    • Managing Favorites
    • Creating a New Folder
    • Uploading a Resource to the Catalog
    • Setting My Account Preferences
    • Configuring the Data Sources
  • Creating a Data Model
  • Creating Reports
  • Creating Report Jobs / Scheduling Reports

Exploring Advanced Features of Oracle BI Publisher 11g

  • Creating a Master Detail Report (Creating Detailed Summary Reports)
    • Creating Reports with Consistent Look and Feel Using Subtemplates
    • Digitally Signing and Securing PDF Documents
    • Bursting
    • Translating Reports
    • Creating a Data Model with Multiple Data Sets
  • Creating RTF Templates Using BI Publisher 11g Template Builder for Word
    • Installing Template Builder and Exploring the Template Builder User Interface
    • Building an RTF Template in Offline Mode
    • Building an RTF Template in Online Mode
    • Working with a Pivot Table in an Existing RTF Template
    • Using Template Builder Utilities: Field Browser, Validate Template, and Check Accessibility
    • Setting Configuration Options for Template Builder
  • Oracle Enterprise Manager 12c: Install and Integrate BI Publisher
  • Oracle Enterprise Manager 12c: Implement the BI Publisher Security Model
  • Oracle Enterprise Manager 12c: Create a BI Publisher Report

Financial Reporting 11.1.2

  • Managing User POVs
  • Building Rolling Forecast Reports
  • Scheduling Batch-Bursting Options
  • Replacing Text Function Parameters with the Current Keyword
  • Retrieving Data from Multiple Database Connections
  • Selecting Members with Advanced Expressions
  • Using ERP Integrator Drill Through from Financial Reporting

Please write to us at for the course price, schedule & location.

Enquire Now

Frequently Asked Questions:


All training courses offered by us are through IT Professional with 10+ years of experience. Freshers/College Students/Professionals(IT & Non-IT) can spot the quality of training by attending one lecture. Hence, we provide one free demo class to all our trainees so that they can judge on their own.


No, you don’t have to pay anything to attend the demo class. You are required to pay the training fee after free demo only if you are fully satisfied and want to continue the training.


To register for free demo, visit our campus or call our counsellors on the numbers given on contact us page.


Yes, all the trainees shall work on live projects provided by Croma Campus after completing their training part.


You will never lose any lecture. You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

Please note, access to the course material will be available for lifetime once you have enrolled into the course.


Yes, Training certificate & Project completion will be issued by Croma Campus(ISO 9001-2000 Certified Training Center)


Yes, Croma Campus conduct special training programs on week end for college students throughout the year.


Croma Campus is the largest education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.


Yes, Course Fee can be paid in two equal installments with prior Approval.


Yes, Croma Campus offer various group or special discounts.


No, Lab is open from 8 A.M. to 8 P.M. seven days a week. This time can be extended upto 11 PM if need arises.


Yes, students can take breaks during their exams and can resume it later without paying any fee. Apart from this, Students can attend batches for revision even after completion of their courses.


Batch strength differ from technology to technology. Minimum batch strength at Croma Campus is 10 and maximum batch strength is 30.

Drop us a query

Our Valued Partners