Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Basics of Oracle Fusion OTBI - Reports & Dashboards
New
9 students

Basics of Oracle Fusion OTBI - Reports & Dashboards

Beginner's guide to Oracle Transactional Business Intelligence (OTBI) Basics
Created bySkill Manor by BEENUM LEARNING
Last updated 7/2026
English

What you'll learn

  • Understand the fundamentals of Oracle Transactional Business Intelligence (OTBI)
  • Learn the OTBI architecture and how it fits into Oracle Fusion reporting
  • Navigate through the OTBI interface and understand the key components available
  • Create basic OTBI analyses from scratch
  • Understand subject areas and how to select the right subject area for reporting
  • Work with columns, filters, prompts, and sorting options in OTBI analyses
  • Apply basic formatting and customization to OTBI reports
  • Understand different OTBI views including tables, charts, and other visualization options
  • Learn the basics of compound layouts and how to organize report output
  • Understand what OTBI dashboards are and how they are created
  • Explore the Dashboard Designer and learn about dashboard objects
  • Add analyses, prompts, and other components to OTBI dashboards

Explore related topics

Course content

11 sections • 21 lectures • 2h 46m total length

  • Intro and create first report using BI composer18:21

Requirements

  • Basic understanding of Oracle Fusion Cloud Applications is helpful but not mandatory
  • No prior OTBI reporting experience is required
  • Familiarity with Oracle Fusion business processes (ERP, SCM, HCM, etc.) is an advantage
  • Students should have access to an Oracle Fusion Cloud environment with OTBI reporting access for hands-on practice
  • This course is suitable for beginners who want to start learning OTBI

Description

This course is designed to help you get started with Oracle Transactional Business Intelligence (OTBI) from scratch.

Please enroll in this course only if you are planning to learn the fundamentals of Oracle OTBI, understand how to build analyses and dashboards, and create interactive reports using features such as Drill Down, Drill Through, Compound Layouts, View Selectors, and Column Selectors.

If you are looking for advanced OTBI concepts, BI Publisher, Oracle Analytics Cloud (OAC), or complex reporting techniques, then this course may not be the best fit for you.

NOTE: This course focuses on the core concepts of Oracle OTBI and is intended to help beginners build a strong foundation before moving on to advanced reporting topics.

NOTE: The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.

With this course, you will learn the fundamentals of Oracle OTBI. Below are some of the key topics covered:

  • Introduction to Oracle Transactional Business Intelligence (OTBI)

  • Understanding OTBI Architecture and Components

  • Navigating the OTBI Catalog

  • Creating Your First OTBI Analysis

  • Working with Subject Areas

  • Adding and Formatting Columns

  • Applying Filters and Sorting Data

  • Creating Tables, Pivot Tables, and Charts

  • Using Compound Layouts

  • Working with View Selectors

  • Working with Column Selectors

  • Creating Interactive Reports

  • Implementing Drill Down Navigation

  • Implementing Drill Through Navigation

  • Creating and Managing Dashboards

  • Dashboard Designer Walkthrough

  • Saving, Organizing, and Reusing Analyses

  • OTBI Reporting Best Practices

Oracle Transactional Business Intelligence (OTBI) is Oracle Fusion Applications' embedded reporting and analytics solution that enables users to create real-time reports and interactive dashboards without writing SQL. It provides access to business data through subject areas and offers powerful features such as drill-down, drill-through, dashboards, view selectors, and compound layouts, helping business users analyze operational data and make informed decisions.

Who this course is for:

  • Oracle Fusion Cloud functional consultants who want to learn OTBI reporting
  • Oracle Fusion technical consultants who want to understand OTBI report development
  • Beginners who want to start their journey with Oracle Fusion Analytics and reporting
  • Business analysts who need to create reports and dashboards in Oracle Fusion
  • Oracle BI developers transitioning to Oracle Fusion Cloud reporting

Report abuse