0845 450 6120

Oracle 11g Business Intelligence Publisher

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

We don't currently have any courses listed for Oracle 11g Business Intelligence Publisher, would you like to view all courses for Oracle?

Learning Objectives

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.

Pre-Requisites

XML Programming

Oracle PL/SQL

Course Content

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
      One Month
      Two Months
      Three Months
      More than Three Months
      PRINCE2 Foundation & Practitioner
      MSP Foundation & Practitioner
      APMP Certificate
      ITIL Foundation
      Scrum in One Day
      Certified ScrumMaster
      ISTQB Software Test Foundation
      Microsoft Project
      BCS Business Analysis Practice
      Other - Please Specify Below

      Our Customers Include