Discoverer Plus 10g R2

Course Overview

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

Audience

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

Prerequisites

PC Fundamentals

Course Outline

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