Loading...

Oracle Business Intelligence (BI) Publisher

Course code: O1039

3 days £1,650.00
+ VAT

Oracle BI Publisher - learn to develop, manage and distribute highly sophisticated reports & documents for IT staff, end users and developers.

Course content >

Who Should Attend?

  • Business Users
  • Report Writers
  • Oracle Database Administrators
  • Oracle Analysts
  • Oracle Developers
  • Technical Consultants

Prerequisites

Course Reviews

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835

COURSE DATES
09 Jul 2018 London Delegates:    £1,650.00
10 Sep 2018 London Delegates:    £1,650.00

Course Contents

Hands on Oracle BI Publisher training course structure to provide delegates with skills to author and create Oracle Business Publisher (BI) reporting applications (reports).

Oracle Business Publisher (BI) training course will cover the different options available within the BI Publisher Enterprise reporting portal and how to create a BI Publisher Enterprise online reporting application from scratch.

Attendees will learn to use BI Publisher to harness desktop tools such as Adobe Acrobat, Microsoft Excel, and Microsoft Word  and gain the skills and experience to create and maintain their own reports via the BI Publisher architecture. Covering Data Model Editor, Layout Editor and using OBIEE as a datasource and publisher (via Dashboards) attendees will learn how to harness and distribute data in a meaningful way to transform the 'raw material' of data into an organsiational asset - information.

As with all iTrain courses this can be delivered as a closed course on your site or a third party location. As company specific training iTrain will work with you to tailor content to your organisation and project's specific requirement and objectives. To assist with this iTrain provide a full mobile classroom the Classroom in a Box.

Oracle Business Intelligence Publisher Training Course Contents

Objectives

  • Create BI Publisher templates
  • Create and maintain reports using BI Publisher Enterprise
  • Create and run reports interactively
  • Schedule and deliver reports to recipients
  • Explore advanced topics in BI Publisher

Introduction to BI Publisher

  • Class objectives
  • BI Publisher Architecture

BI Publisher Data Models

  • Describe the sample schemas used in course practices
  • Creating a BI Publisher Report from a BI Answers Request
  • Creating a BI Publisher Report from the Oracle Database
  • Creating a Data Template Report
  • Creating a BI Publisher Report from the OBIEE Subject Area
  • Creating a Multi-Source BI Publisher Report
  • Editing Report Properties

RTF Templates Using Word

  • Exploring the MS Word BI Publisher Interface
  • Creating Table Wizard Templates
  • Uploading (Pushing) Templates to a BI Publisher Report
  • Creating Multiple Layouts for One Report
  • Uploading (Pulling) Templates to a BI Publisher Report
  • Creating Custom Tables
  • Implementing Totals on Layouts
  • Creating Summary Group Tables

Creating PDF templates

  • Creating PDF templates using Adobe Acrobat

Disconnected Report Dev

  • Exporting a Data Model
  • Developing Layouts in Disconnected Mode

Custom Calculations

  • Group-level calculations
  • Report-level calculations

Report Formatting

  • Formatting using native Word features
  • Conditional Formatting
  • Creating Templates
  • Applying Advanced Conditional Formatting
  • Applying Page Breaks and Page Numbers

Crosstabs (Pivot Tables)

  • Creating Crosstabs

Charts

  • Creating Vertical Bar Charts

Creating Pie Charts

  • Creating Pie Charts
  • Exploring Chart Options

Developing Form Field Layouts

  • Creating Two-Column Tables
  • Creating Three-Column Tables
  • Creating Nested Three-Column Tables

Parameters and Lists of Values

  • Duplicating Existing Reports
  • Creating Selection Lists
  • Creating Parameters
  • Filtering with Parameters
  • Creating Cascading Parameters

Hyperlinks

  • Using Hyperlinks to Drill and Navigate

Advanced Layout Options

  • Backgrounds and Watermarks
  • Annotating Layouts with Drawings and Shapes
  • Table of Contents
  • Dynamic Data Columns
  • Batch Reporting

Report Distribution

  • Bursting and Scheduling using a Single Layout
  • Bursting and Scheduling using Multiple Layouts
  • Bursting to E-mail
  • Bursting and Scheduling Options
  • Scheduling BI Publisher Reports
  • Viewing saved output and history
  • Managing scheduled reports

BI Publisher Reports in OBIEE

  • Including a BI Publisher Report in a Dashboard Page

Page level Calculations

  • Page level Calculations and Context Specific Content

BI Publisher Analysis Tools

  • Review of BI Publisher Analysis Tools

XML Reporting and Data Sets

  • Introduction to XML Reporting and Data Sets

Oracle BI Publisher Admin

  • Security Models
  • Configure data sources, users, roles and permissions, delivery options
  • Administrative tasks
  • Defining a Report Repository
  • Configuring BI Publisher Scheduler
  • Establishing a Database Connection
  • Installing BI Publisher Desktop
  • Creating Layouts for Check Printing
  • Advanced Layout Exercises

Integrating BI Publisher with OBIEE

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

Data Models and BI Publisher Reports Using Alternative Data Sources

  • Configuring Presentation Services Integration
  • Web Services Data Source
  • HTTP (XML/RSS Feed) Data Source
  • Proxy Setting for Web Services and HTTP Data Sources
  • BI Publisher Reports based on an External Web Service
  • BI Publisher Reports based on an HTTP Data Set
  • BI Publisher Reports Based on XML File
  • BI Publisher Reports Based on CSV Data source
Contact us for more information