Enter your keyword

Oracle Business Intelligence (BI) & OTBI

What is Oracle BIP and OTBI?

Oracle Business Intelligence Publisher is a reporting and publishing application that enables you to extract data from multiple data sources, create layouts for report data, and publish the report to numerous output formats.

BI capabilities allow you to:

  • Gather real-time  data from your organization
  • Visualize the data in different formats such as tables and graphs
  • Deliver data in a timely fashion to the employees in your organization


Oracle Transactional Business Intelligence (OTBI) provides real-time insight into data. OTBI processes, organize, and collect data from internal IT systems and external sources, prepare it for analysis, run queries against the data, and create data visualizations, BI dashboards make the analytics results available to business users for operational decision-making and strategic planning. Instead of constructing a SQL query, users can drag and drop data from functional subject areas and use different graphical views to explore or visualize the data interactively.


    Training Course Structure

    Course Outline

    • What is BI?
    • Features of BI?
    • Benefits of BI
    • Technologies required to learn BI
    • Tools required for BI Report Development
    • Overview of Fusion Tables

    • Pre-requisites to create BI Report
    • Introduction to BI Data Model
    • Different ways via which BI data model can be created
    • Overview of delivered BI Reports
    • Security in BI Reports
    • Report Templates and its importance

    • Pixel Perfect Reporting
    • Language Translation Feature in BI Reports
    • Creating parameterized reports
    • Reports based on secured views
    • Overview of Parameter View Object
    • Using a Parameter View Object (PVO) in BI Report
    • Different Types of Data Source in Oracle Cloud
    • BI Report Usage for Integration

    • Data Model
    • Templates
    • Parameters
    • Value Set
    • Parameter Defaulting
    • Format Triggers

    • Creating Custom Scheduled Jobs
    • Reading Log and Output Files of Custom Scheduled Job
    • Overview of commonly used delivered Scheduled Jobs
    • Sending Notification of a Scheduled Job
    • Submitting a Scheduled Job
    • Enabling Security in a Scheduled Job
    • Calling scheduled job from web service
    • Different BO REST APIs

    • Know all best practices to use BI Report
    • When to use a BI Report
    • BI Report in a dashboard

    • Introduction of OTBI
    • Different types of Subject Area
    • Creating a simple OTBI Analysis from a subject area
    • SET Operations in OTBI Analysis
    • Agents and their Usage

    • Creating Data Sets based on various data sources (SQL, XLS, CSV, Web Service)
    • Create a simple Data Model
    • Creating parameterized Data Model
    • Creating a Data Model which has mandatory and optional parameter
    • Associating a LOV with parameter
    • Creating a RTF Template
    • Creating a simple BI Report
    • BI Bursting
    • Creating security enabled BI Report
    • Creating letter format reports
    • Pixel Perfect Reporting
    • BI Report encapsulated in ESS Job
    • Running a ESS Job
    • Sending Report output Via Email
    • Creating OTBI Report
    • Overview of Agents
    • Creating Dashboard
    • Creating BI Report from OTBI Analysis
    • Password protecting a OTBI Analysis Output
    • Cross Subject Area Reporting
    • Using facts and measures
    • Creating charts
    • OTBI usage in Application
    • Delivered OTBI Reports
    • Comparison between a OTBI and BI Report

    Training Details

    Training Schedule

    Timings: 07:00 to 09:00 PM IST

    Days: Saturday & Sunday

    Total Duration: 12 hours

    Date: 30-Mar-24

    Mode: Online