TRN 205 : Oracle BI EE 11g Create Reports, Dashboards, Alerts and Scorecards

Overview : This two day course is aimed at developers, and business power-users who wish to create their own reports and dashboards using Oracle BI EE 11g Enterprise Edition. Written for Oracle BI EE 11g, it takes delegates through the basics of creating reports, adding graphics and interactivity, creating pivot tables and graphs, alerts, KPIs and Scorecards, and delivering them through an interactive dashboard.

No prior knowledge is assumed, and delegates by the end of the course will have a good understanding of what is involved in creating an end-to-end dashboard using Oracle BI EE, together with alerts, offline analysis and boardroom quality reports using Oracle BI Publisher.

This course has been updated for OBIEE 11.1.1.7, but is just as relevant if your organisation is on an earlier release of 11g.

Duration : 2 Days

Course Delivery : Instructor-led with labs, on-site at customer location

Who Should Attend :End-users, developers, project managers

Prerequisites : none

Detailed Course Agenda :

Day 1
1. Oracle BI EE 11g Overview

  1. Creating Analyses using Tables, Charts, Maps and Prompts
  • Dashboard and Analyses Overview
  • Creating table views
  • Creating totals and subtotals
  • Filters and prompts
  • Title views and icons
  • Working with the compound layout
  • Adding charts
  • Adding Gauges
  • Briefing Books
  • Microsoft Office Integration
  • Column Selectors
  • View Selectors
  • Narrative Views
  • Formatting & Conditional Formatting
  • Hierarchical Columns and Selection Steps
  • Master-Detail Linking
  • Trellis charts
  • Mapping
  • Dashboard Overview
  • Adding requests to the dashboard
  • Adding dashboard prompts

Day 2

  1. Actionable Intelligence
  • Creating Basic Actions and Action Links
  • Creating Agents and Conditions

4. Creating Published Reports using BI Publisher

  • BI Publisher overview
  • BI Publisher User Interface
  • Online Data Modeller
  • Online template editor
  • Combining data sources in the online data modeller
  • Report Bursting
  1. Key Performance Indicators and Scorecards
  • Defining Key Performance Indicators
  • Creating KPI Watchlists
  • Creating Scorecards

To book this course for your organization, to customize this course or for more information, contact training@rittmanmead.com for more details.

Website Design & Build: tymedia.co.uk