O1037 - Oracle 10g BI Discoverer Plus

Availability

DateDurationPriceLocationEnrolment

Training Course Objectives

This practical course covers Oracle Discoverer Plus and is applicable to 4i, 9i and 10g release 1 users.

Oracle Discoverer enables professionals and users without database skills to perform complex queries and in depth data analysis.

This one-day course provides a comprehensive insight into the Discoverer tool and the techniques required to use it to access and retrieve data.

Training Course Contents

Training Course Contents

Introduction

  • Introduction to Discoverer
  • An introduction to Databases

Getting Started

  • Accessing Discoverer
  • Workbooks
  • Opening Existing Workbooks
  • Worksheets
  • Workbook Window
  • Printing your Worksheets
  • Page Set up
  • Scheduling Workbooks

Formatting Worksheets

  • Introduction
  • Renaming a Worksheet
  • Rearranging Item Columns
  • To Move Items in Table
  • Worksheets
  • Formatting the Item Header
  • Formatting the Data

Manipulating Worksheets

  • Introduction
  • Basic Table Sorting
  • Group Sorting
  • Sort Table Dialogue
  • Copying Items between
  • Worksheets
  • Exporting Data to Other
  • Applications

Graphs

  • Introduction
  • Creating a Graph
  • Editing the Graph
  • Formatting the Graph
  • Chart Types

Creating a New Workbook

  • Introduction
  • Editing a Worksheet
  • Duplicating a Worksheet
  • Drilling
  • Drilling Up and Down

Manipulating Data

  • Introduction
  • Conditions
  • Parameters
  • Totals
  • Percentages
  • Calculation

Introduction to Discoverer

  • Opening reports
  • Formatting reports

Who Should Attend

Pre Requisites