Course Title:
Discoverer for End Users

Duration: 1 day

Course Overview
This course provides a hands-on approach to Oracle’s Discoverer application for End Users. The course begins with a very brief overview of the Oracle database and Oracle Discoverer’s place in the system. Delegates will then use the wizards to create the four different types of report that can be generated.

Delegates will be guided through drilling, sorting, totals, percentages, conditions, exceptions, formatting, printing, parameters, scheduling, graphs and exporting. The course is structured in such a way that the delegates are using Discoverer for the entire day. They will be taken through tasks step-by-step and then given exercises to enforce what they have just learned.

Course Objectives


By the end of the course attendees will be able to:

• Use the wizards to produce the four different types of report
• Include titles and images for their reports
• Format the data displayed in their report
• Implement sorting into their reports
• Implement conditions and filters
• Set up reports that run with parameters
• Schedule reports
• Export their reports to different applications such as Excel and HTML
• Include graphs in their reports
• Show exceptions in their reports
• Include totals and percentages in their reports.
• Create calculated items

Prerequisites


Basic keyboard and mouse skills.

Course Content


Introduction
• The Oracle Database
• The Purpose of Oracle Discoverer
• The End User Layer

Creating Workbooks
• The Workbook Wizard
• Table Report
• Crosstab Report
• Page-Detail Table Report
• Page-Detail Crosstab Report

Maintaining Workbooks and Worksheets
• Saving a Workbook
• Creating a New Worksheet in Your Workbook
• Sharing Workbooks
• Worksheet Maintenance
• Printing a Worksheet

Formatting Data
• Renaming Your Column Names
• Rearranging the Order of the Columns
• The Formatting Toolbar
• The Format Data Dialogue Box
• Formatting Columns
• Formatting Totals
• Adding a Title to Your Query
• Adding a Background Bitmap

Filtering Data with Conditions
• Different Methods Available
• Creating a Basic Filter
• Creating a Complicated Filter

Ordering Results
• Basic Sorts
• Sorting into Groups
• Using Groups for Pagination

Generating Totals and Percentages
• Creating a Basic Total
• Creating a Total Based on a Group
• Creating a Basic Percentage
• Creating a Percentage on a Group

Exception Reporting
• Creating an Exception

Calculated Fields
• Creating a Calculated Field without Oracle Functions
• Creating a Calculated Field Using Oracle Functions

Applying Conditions Using Parameters
• Using Existing Conditions
• Creating Parameters without Existing Conditions

Remaining Features
• Implementing Graphs using the Graph Wizard
• Batch Scheduling
• Exporting Data

My group have used Pentland Training twice in the past two years for in-house Oracle courses. Pentland Training was recommended to us by another group with whom we interact within GSK.

The two courses met all our objectives relating to price, content covered, and tailoring to our needs. The last objective of having customised course content was especially important to us as other training companies tended to offer “one size suits all” training where much of the content was irrelevant to our needs.

Pentland will be our first choice for future training needs.

Data Management Manager
GlaxoSmithKline


Enter your email address to register for our newsletter:


IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

follow us on Twitter