Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: WHAT IS ORACLE DISCOVERER

• Overview of Oracle Discoverer
• Oracle Discoverer Components
• Connecting to Oracle Discoverer
• Workbooks and Worksheets

Session 2: WORKBOOK BASICS

• The Oracle Discoverer Workbook Window
• The Button Bars
• Displaying Data
• Selecting Worksheet Sections
• Viewing Pages

Session 3: WORKBOOK FORMATTING

• Re-ordering and Resizing Columns
• Formatting Headings and Data
• Worksheet Titles

Session 4: CREATING A WORKBOOK

• Overview of Workbook Creation
• Adding a Table Layout Worksheet
• Adding a Crosstab Layout Worksheet
• Page-Detail Worksheets
• Duplicating Sheets
• Worksheet Management

Session 5: CONDITIONS

• Creating and Editing a Condition
• Creating and Using Parameters
• Advanced Conditions

Session 6: COUNTS AND CALCULATIONS

• Creating COUNTS on a worksheet
• Creating and Editing Calculations
• Introduction to Oracle functions

Session 7: GRAPHING YOUR DATA

• Overview of Graphs in Discoverer Worksheets
• The Graph Tool Bar
• Creating a Graph
• Modifying a Graph
• Drilling in a Graph

Session 8: WORKBOOK MANIPULATION

• Pivoting Data
• Drilling into Data
• Sorting Data

Session 9: DATA ANALYSIS TOOLS

• Overview of the Data Analysis Tools
• Creating and Editing a Total
• Creating and Editing a Percentage
• Conditional Formatting with Exceptions

Note - in practice this session may start on the first day

Session 10: REPORTS

• Printed Reports
• Scheduled Reports
• Using the Scheduling Manager

Session 11: ADVANCED FEATURES

• Discoverer Options

Session 12: ANALYTIC FUNCTIONS

• Introduction - Oracle Analytic Functions and their Purpose
• Examples of Oracle Analytic Functions
• Creating Calculations using Oracle Analytic Functions

Session 13: DISCOVERER VIEWER

• Overview of Oracle Discoverer on the Web
• Creating Private Connections
• Using Oracle Discoverer Viewer