• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 2
Job Meter = Medium

Oracle BI Publisher 12c R1

30 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Dec-2023
Oracle BI Publisher 12c R1 course and certification
7 Learners

About this Course

Oracle Business Intelligence Publisher course refers to enterprise reporting product powered by Oracle that enables the capability to build and manage formatted reports from varied data sources. Oracle Business Intelligence publisher online course intention is to create multi-format (PDF, RTF, Excel, HTML and few more languages with single template.

The Oracle BI Publisher 12c training teaches you the fundamental concepts of Oracle BI Publisher, a reporting & document output management solution. Develop skills and design reports by using components such as Data Model, Report and Layout Editors.

Learn To:

-- 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.

-- Creating Reports

Furthermore, you'll learn how to create layouts for reports, then publish the highly formatted reports to a wide range of destinations (printers, faxes, email, and document repositories via FTP or WebDav). Publisher's report formats can also be designed by using familiar Microsoft Office tools like Microsoft Word and Excel.

Scheduling and Bursting Reports

Oracle BI Publisher 12c provides best of breed capabilities for scheduling and bursting reports. By investing in this course, you'll learn how to schedule and manage scheduled jobs, along with bursting reports to other destinations.


Course Objective

The Oracle Business Intelligence Publisher training is intended for the individuals who seek to implement their knowledge, skills and expand their career as Business Intelligence Publisher Specialist. The dedicated mentors make sure the learners to cover all topics under Oracle Business Intelligence Publisher curriculum which will be useful for their career growth. Uplatz offers Oracle Business Intelligence Publisher training to become a skilled Business Intelligence Publisher specialist.


Course Description

Oracle Business Intelligence Publisher course program will let the participants gain complete proficiency to create, manage and deliver reports and documentation quicker than other reporting tools. The Oracle Business Intelligence Publisher online course is ideally developed for business intelligence implementation team who can build and design reports using components such as layout editors, report and data model.

In the Oracle Business Intelligence Publisher course, Uplatz provides an in-depth training for the participants or learners to make them understand the experience of using reporting and document output management solution. The Oracle Business intelligence publisher technology is useful in creating data model, Business intelligence publisher reports, report layouts.

With the help of Oracle Business Intelligence publisher online course, the learners can:

·       Schedule and burst data reports.

·       Translate data.

·       Design and construct business models.

·       Form layouts using layout editor.

·       Create and change data models.

Uplatz provides an in-depth training to the learners to accelerate their knowledge and skill set required for Business Intelligence Publisher specialist job.


Target Audience

The Oracle Business Intelligence Publisher course is intended for the below mentioned target audience, still if you are a newbie and want to make a career as Publisher specialist, then the Oracle Business Intelligence publisher course is the best option you can choose.

·       Developers

·       Analyst

·       Implementer

·       End user


Oracle BI Publisher 12c R1

Course Details & Curriculum

Introduction to Oracle BI Publisher 12c Course Syllabus

  • Course Agenda
  • Functions of Reporting Systems including Challenges
  • Salient Features of BI Publisher
  • BI Publisher as a Strategic Reporting Solution for All Applicationss
  • Overview of Oracle BI Foundation Suite
  • Introducing BI Publisher Paradigm
  • Overview of Oracle BI EE
  • Overview of Oracle Fusion Middleware

BI Publisher Technology and Architecture

  • Multitier Architecture
  • Internationalization and Language Support
  • Supported Data Sources
  • Layout Templates
  • Document Generation Process and Output Formats
  • Bursting Overview
  • Functional Components
  • Enterprise Server Architecture and Performance and Scalability

Getting Started with BI Publisher

  • Managing Repository Objects
  • Viewing Reports
  • Configuring Report Properties
  • Using Create Report wizard to Create Reports
  • Selecting Data: Data Model, Spreadsheet, and BI Subject Area
  • Logging In, the Home Page, and Global Header, and Setting Account Preferences
  • Managing Favorites

Using Oracle Business Intelligence (BI) Publisher 

  • Understanding the Key Features of Oracle BI Publisher
  • Describing the Vision Charts of Accounts
  • Explaining the Vision Story
  • Navigating Oracle Cloud Applications
  • Locating Course Resources
  • Running an Oracle BI Publisher Report from the Financial Reporting Center

Oracle Business Intelligence Publisher (BI) Fundamentals

  • Describing the Components of Oracle BI Publisher
  • Defining Templates Using the Word Template Builder
  • Understanding and Using the BI Publisher Customize Feature
  • Creating and Editing Report Layouts Using the Layout Editor
  • Understanding the Report Configuration Options
  • Creating a New Report Using an Excel Spreadsheet as the Data Source

Using the Data Model Editor

  • Viewing Data and Saving Sample Data Sets
  • Configuring Parameter Settings and Viewing Reports with Parameters
  • Adding Parameters and LOVs to the Query
  • Creating a Simple Data Model based on a SQL Query Data Set
  • Exploring the Data Model Editor UI and the Supported Data Sources
  • Exploring the Schemas Used in the Course
  • Creating a Private Data Source
  • Using Query Builder to Build a Query

Working with Layout Editor

  • Creating Boilerplates
  • Working with Lists, Gauges and Pivot Tables
  • Creating a Layout by Using a Basic Template
  • Inserting a Layout Grid
  • Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats
  • Adding Repeating Sections, Text Items, and Images
  • Opening the Layout Editor and Navigating the Layout Editor UI
  • Inserting and Editing Charts, and Converting Charts to a Pivot Tables

Using Template Builder to Create RTF Templates

  • Exploring the Basic and Form Field Methods
  • Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data
  • Designing an RTF Template for a BI Publisher Report
  • Adding a Chart to an RTF Template
  • Creating a BI Publisher Report by Using Template Builder in Online Mode
  • Using the BI Publisher Menu Bar
  • Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting

BI Publisher Server: Administration and Security

  • Describing Groups, Users, Roles, and Permissions
  • Integrating with Oracle BI Presentation Services and Oracle Endeca Server
  • Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS
  • Describing the Security Model for BI Publisher and Oracle Fusion Middleware
  • Creating the JDBC Connections
  • Setting, Viewing, and Updating Data Sources
  • Describing and Configuring BI Publisher Scheduler
  • Describing the Administration Page

Scheduling and Bursting Reports

  • Adding a Bursting Definition to a Data Model
  • Managing and Viewing a Report Job
  • Scheduling a Bursting Job
  • Viewing Report Job History
  • Scheduling a Report with Trigger
  • Describing Bursting
  • Scheduling and Describing a Report Job and Related Options

Integrating BI Publisher with Oracle BI Enterprise Edition

  • Configuring Presentation Services Integration
  • Creating a Data Model and Report based on a BI Server SQL Query
  • Navigating Oracle BI EE
  • Adding a BI Publisher Report to an Oracle BI EE Dashboard
  • Creating a Data Model and Report based on an Oracle BI Analysis
  • Creating a Report based on OBI EE Subject Area

Creating Data Models and BI Publisher Reports Based on Other Data Sources

  • Explaining Proxy Setting for Web Services and HTTP Data Sources
  • Creating a BI Publisher Report based on an External Web Service
  • Creating a BI Publisher Report Based on CSV Data source
  • Describing the Web Services Data Source
  • Configuring Presentation Services Integration
  • Creating a BI Publisher Report based on an HTTP Data Set
  • Describing the HTTP (XML/RSS Feed) Data Source
  • Creating a BI Publisher Report Based on XML File

Performing Translations

  • Exporting and Importing the XLIFF for a Catalog Folder
  • Managing XLIFF Translations on BI Publisher Server
  • Describing the Overall Translation Process
  • Translating by Using the XLIFF Option
  • Translating by Using the Localized Template Option
  • Describing Catalog Translation
  • Describing Translation Types


Career Path

The Oracle certified business intelligence publisher certification course with the help of expert professionals training is recognized across the globe. Because of the increased adoption of the Oracle Business Intelligence reporting software in various companies the participants are able to find the job opportunity easily. The leading companies hire business intelligence publisher to create and manage reporting.  The business intelligence publisher can pursue a wide range of career paths.

The following are the job titles:

  • BI Publisher consultant

  • Lead Developer

  • Business Intelligence Developer


Job Prospects

The Business Intelligence Publisher draws an average salary of $79,767 per year depending on the knowledge and hands-on experience. The Business Intelligence publisher job roles are in high demand and make a rewarding career.



Oracle BI Publisher Interview Questions


1. Define Business Intelligence.

The Business Intelligence’ (BI) is used for reporting the specified data of any business which is very critical and used by top management of any organization to make wise decision for the growth of their business.

2. Mention the vital decisions made by an organization using business intelligence.

The below decisions are decided from Business Intelligence tool:

•   determine whether a business is running as per plan.

•   analyse which things are actually going wrong.

•   monitor corrective actions.

•   identify the current trends of their business.

3. Mention the different stages of Business Intelligence.

The five stages of Business Intelligence:

•  Data Source: deals with data extraction from multiple data source.

•  Data Analysis: It is used to provide proper analysis report based on useful knowledge from a data collection.

•  Decision-Making: It makes use of the information in the proper way to provide proper graph on important events such as market changes, and poor staff performance.

•  Situation Awareness: It is about ignoring irrelevant information and retain the remaining information in the context of the business.

•  Risk Management: It is used to discover the corrective actions to be taken, or decisions made, at different scenarios.

4. List out the benefits of Business intelligence.

 The different benefits of Business Intelligence:

•  Improvised decisions making.

•  Optimize internal business process.

•  Increase operational efficiency.

•  Drive oppurtunities for new revenues.

•  Growing in terms of competitive markets.


5. Mention the various Business Intelligence tools available in the market.

•  Oracle Business Intelligence Enterprise Edition (OBIEE)

•  Cognos

•  Microstrategy

•  SAS Business Intelligence

•  SAP BusinessObjects

•  Tableau

•  Microsoft Business Intelligence Tool

•  Oracle Hyperion System

6. Define universe in Business Analytics.

The universe is type of semantic layer existing between database and user interface. it is one of the interfacing layers present in between the client (business user) and data warehouse. It is used to define a relationship between various tables in a data warehouse.

6. Define dashboard in a data warehouse.

The dashboard is nothing but the order arrangement of all the reports and graphs in a page. It is the collection of reports available in different format.

7. Define Fact table.

A Fact table is the center table present in star schema of a data warehouse. It is used to hold quantitative information for analysis.

8. Define Dimension table.

A dimension table is one of the key tables in a star schema of a data warehouse, which saves attribute, or dimension, that describe the objects in a fact table.

9. Define a RAGGED hierarchy.

Ragged hierarchy is used to maintain a relationship in case of parent member of at least one member of the dimension is not in the level immediately above the member.

10. Define universe in Business Analytics?

Universe is an interfacing layer between client and data warehouse. Universe specifies the relationship between various tables in data warehouse. It holds different names in different tools. It is called as repository or RPD in OBIEE.

11.Mention the different types of Data warehouse Systems.

a) Data Mart

b) Online Analytical Processing (OLAP)

c) Online Transactional Processing

d) Predictive Analysis


Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

Didn't find what you are looking for?  Contact Us