Beginner’s guide to Oracle Transactional Business Intelligence (OTBI) Basics
This course is designed to help you get started with Oracle Transactional Business Intelligence (OTBI) from scratch.
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.
Course Content
- Introduction –> 1 lecture • 18min.
- Basic Concepts –> 6 lectures • 51min.
- SOAP Web Service –> 1 lecture • 11min.
- 9 Analysis Prompt, Conditional Formatting, Data Format –> 1 lecture • 9min.
- Drill Down –> 2 lectures • 18min.
- 12 Master Detail Event –> 1 lecture • 7min.
- Drill Through –> 2 lectures • 14min.
- 15 Column Selector and View Selector –> 1 lecture • 7min.
- 16 Switch between the compound layouts –> 1 lecture • 6min.
- 17 What is Dashboard OTBI –> 4 lectures • 25min.
- Congratulations –> 1 lecture • 1min.
Requirements
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.