Introduction:

This advanced course is designed for experienced developers and professionals who want to master Oracle BI Publisher. Participants will gain comprehensive knowledge and hands-on experience in creating advanced data models, designing complex reports and online report layouts, integrating with OBI EE data sources, publishing reports on OBI EE Dashboards, and automating report scheduling and bursting.

Objectives:

  • Create data models by using the Data Model Editor.
  • Create BI Publisher reports based on data models.
  • Create report layouts by using the Layout Editor (online).
  • Create reports based on OBI EE data sources.
  • Publish the reports on OBI EE Dashboards.
  • Schedule reports and burst these reports.

Course Outline:

Module 1: Advanced Introduction to Oracle BI Publisher

  • Overview of BI Publisher
  • Advanced features and benefits
  • Understanding the BI Publisher interface

Module 2: Advanced Data Modeling with Data Model Editor

  • Exploring advanced features of the Data Model Editor
  • Creating complex data models
  • Advanced SQL query techniques and parameterization

Module 3: Creating Advanced BI Publisher Reports

  • Creating advanced BI Publisher reports
  • Leveraging data models for complex reports
  • Implementing advanced report features
  • Creating online report layouts
  • Advanced formatting, styling, and customization
  • Responsive design for various devices

Module 4: Working with OBI EE Data Sources

  • Advanced integration with OBI EE data sources
  • Advanced utilization of OBI EE subject areas in data models
  • Complex reporting based on OBI EE data.

Module 5: Advanced Publishing and Integration

  • Advanced integration techniques for BI Publisher reports into OBI EE Dashboards
  • Customization and interactivity enhancements
  • Advanced scheduling and automation of report generation
  • Bursting reports based on dynamic data-driven conditions

Module 6: Advanced Topics and Best Practices

  • Advanced customization techniques and scripting
  • Performance optimization and tuning
  • Best practices for complex report design

Module 7: Hands-on Exercises and Projects

  • Complex practical exercises and projects to reinforce advanced learning
  • Building advanced custom reports based on real-life scenarios

Module 8: Certification Preparation and Advanced Topics

  • Advanced topics for Oracle BI Publisher certification (if applicable)
  • Tips for certification success.