Skip to content

Oracle BI Publisher Instructor-led Training
Uplatz

Free server access, Class recordings, Certification guidance, Job & Interview assistance, Course Completion Certificate

Summary

Price
£1,999 inc VAT
Or £166.58/mo. for 12 months...
Study method
Online + live classes
Duration
30 hours · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Uplatz Certificate of Completion - Free
Additional info
  • Tutor is available to students

Overview

Oracle Business Intelligence Publisher (BI Publisher) – Instructor-Led TrainingCourse Overview

This instructor-led training (ILT) program on Oracle BI Publisher provides a practical and hands-on approach to mastering enterprise-level reporting and document output management. Participants will gain the skills to create, design, and publish high-quality reports from multiple data sources using Oracle BI Publisher 12c.

Whether you're working with structured data models or integrating with Oracle BI EE, this training covers the full lifecycle of report creation—from data modeling to layout design, scheduling, bursting, and deployment.

What You Will Learn

By the end of this course, you will be able to:

  • Understand Oracle BI Publisher architecture and core concepts.

  • Create robust data models using the Data Model Editor.

  • Design and format report layouts using Layout Editor and Microsoft Word/Excel.

  • Generate multi-format reports (PDF, RTF, Excel, HTML, etc.).

  • Build reports from Oracle BI EE data sources and embed them into dashboards.

  • Schedule and burst reports to specific recipients or locations.

  • Manage output delivery via printers, email, fax, FTP, or WebDAV.

Certification

Upon successful completion of the course, participants will receive a Course Completion Certificate from Uplatz.

Certificates

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Course media

Resources

  • Oracle BI Publisher course syllabus - download

Description

Oracle BI Publisher – Course SyllabusModule 1: Introduction to BI Publisher
  • Overview of Oracle BI Publisher

  • Key features and benefits

  • Comparison with other reporting tools

  • BI Publisher architecture and components

  • Understanding the reporting lifecycle

Module 2: Data Modeling
  • Introduction to data models

  • Data sources supported by BI Publisher

  • Creating data sets using SQL queries, Web Services, Excel, etc.

  • Creating parameters and filters

  • Creating and managing LOVs (List of Values)

  • Grouping and aggregation in data sets

  • Using Data Model Editor

Module 3: Report Creation
  • Creating BI Publisher reports from data models

  • Report definition and layout design overview

  • Binding data sets to report layouts

  • Report parameters and runtime input handling

  • Managing report properties and formatting

  • Report bursting basics

Module 4: Layout Design & Templates
  • Layout types: RTF, PDF, Excel, HTML

  • Creating templates using Microsoft Word (RTF templates)

  • Creating Excel templates for tabular reporting

  • Using Layout Editor (online)

  • Conditional formatting, tables, and repeating elements

  • Sub-templates and reusable content

  • Multi-language support

  • Using BI Publisher Desktop Plugin

Module 5: Scheduling and Bursting
  • Introduction to scheduling in BI Publisher

  • Creating and managing job schedules

  • Setting delivery options (email, FTP, printer, WebDAV)

  • Creating bursting definitions for targeted delivery

  • Monitoring and auditing scheduled jobs

Module 6: Integration with Oracle BI EE
  • Overview of Oracle BI EE integration

  • Creating reports from BI EE subject areas

  • Embedding BI Publisher reports in dashboards

  • Securing and sharing BI Publisher content via BI EE

  • Security and permissions management

Module 7: Advanced Topics
  • Managing report translations

  • Using barcode and image support

  • Using XPath expressions

  • Creating pivot tables and charts

  • Performance tuning best practices

  • Versioning and revision control

Module 8: Deployment & Administration
  • Deploying BI Publisher reports to production

  • Setting up folders and catalog organization

  • Managing users, roles, and permissions

  • Configuring delivery channels

  • Archiving and backing up reports and templates

Module 9: Troubleshooting and Debugging
  • Common issues in report design and execution

  • Debugging data models and templates

  • Using diagnostic logs and error messages

  • Report performance optimization tips

Module 10: Real-World Projects & Use Cases
  • Hands-on case studies

  • Creating operational, financial, and dashboard reports

  • End-to-end mini-project: data modeling to report delivery

Who is this course for?

  • Report Developers – Professionals responsible for building, formatting, and maintaining business reports using Oracle BI Publisher.
  • BI Consultants – Business Intelligence professionals who integrate reporting into larger analytics and ERP systems.
  • Data Analysts – Individuals who need to extract, format, and present data insights effectively.
  • ERP Implementers – Consultants involved in Oracle EBS, Fusion, or other ERP implementations requiring custom reporting.
  • Application Developers – Developers who work with Oracle technologies and need to generate reports from structured data sources.
  • Oracle EBS Users – Functional and technical users who need to replace or enhance Oracle Reports with BI Publisher.
  • Database Administrators (DBAs) – DBAs interested in understanding how BI Publisher interacts with databases and data sources.
  • IT Managers / Reporting Managers – Decision-makers looking to implement or manage enterprise reporting solutions in Oracle environments.

Requirements

Enthusiasm and zeal to make it big!

Career path

  • Oracle BI Publisher Consultant
  • Business Intelligence Reporting Specialist
  • Oracle BI Developer
  • BI Publisher Report Developer
  • Document Output Management Specialist
  • Oracle BI Technical Analyst
  • Financial Reporting Analyst
  • Oracle BI Functional Consultant
  • Application Support Analyst – BI Reports
  • Technical Analyst – Oracle BI Publisher
  • Oracle Fusion Reports Consultant
  • BI Publisher Implementation Expert

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.