O1038 - Oracle 10g R2 Business Intelligence Discoverer Plus

Availability

DateDurationPriceLocationEnrolment
08/28/121360ReadingPlease phone 01275 859666

Training Course Objectives

This practical course covers Oracle Discoverer Plus and is applicable to all releases but, for the duration of the course, Discoverer 10g Release 2 will be used.

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
  • Sharing Workbooks

Formatting Worksheets

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

Manipulating Worksheets

  • Introduction
  • Basic Table Sorting
  • Group Sorting
  • Sort Table Dialogue
  • Copying Items between
  • Worksheets
  • Exporting Data to Other
  • Applications
  • Crosstab Reports
  • Exporting Crosstabs as Pivot
  • tables

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
  • Calculations

Advanced Reporting Techniques

  • Multiple conditions
  • SQL Functions
  • Using calculations within
  • Conditions and Parameters

Introduction to Discoverer

  • Opening reports
  • Formatting reports

Who Should Attend

  • Data Administrators
  • Support Technicians
  • Data Analysis Technicians
  • Data Retrievers
  • Report Writers

Pre Requisites

  • PC Fundamentals