Oracle - AS Discoverer 10g: Create Queries and Reports (Windows)

Request more details:

Description:
This class will teach students the purpose and capabilities of the Oracle BI Discoverer 10g AS tool. Thereafter, each user can learn to apply this knowledge to the company`s internal data model.
Prerequisites:
Oracle Application Server 10g: Administration I is recommended, but not mandatory.
DATA ANALYSIS REVIEW :
what is data analysis
introduction to oracle10g discoverer
discoverer components
important terminology
the training environment
CREATING QUERIES :
starting discoverer as
online help
the workbook wizard
the results window
QUERY MANAGEMENT :
managing workbooks
saving workbooks
opening workbooks
deleting workbooks
sharing workbooks
managing worksheets
moving/copying worksheets
editing worksheets
renaming and deleting worksheets
MODIFYING THE DISPLAY :
adding a report title
adding a report footer
print preview/page setup options
page setup options
formatting headings
modifying heading properties
formatting data
changing default column size
modifying data display properties
setting heading and data format defaults
WORKING WITH CONDITIONS AND PARAMETERS:
working with conditions
viewing, applying, disabling conditions
creating new conditions
using the new condition dialog
multiple and nested formula conditions
create conditions using the analysis bar
editing conditions
working with parameters
viewing, applying, and disabling parameters
creating new parameters
executing the query with the parameter wizard
editing parameters
WORKING WITH CONDITIONAL FORMATS AND CALCULATIONS :
working with conditional formats
how conditional formats are used
viewing, applying, disabling exceptions
creating and editing conditional formats
working with calculations
viewing, displaying, hiding calculations
creating calculations using the edit calculation dialog
creating calculations using the tool bar
editing calculations
WORKING WITH SORTS, TOTALS, AND PERCENTAGES :
working with sorts
creating column sorts
creating group sorts
the sort table dialog
working with totals
viewing, displaying, hiding totals
creating/editing totals using the total dialog
working with percentages
viewing, displaying, hiding percentages
creating/editing percentages
using the percentage dialog
using the tool bar to create percentages
drilling the data
using drills in discoverer
drilling from the workbook window
using the drill dialog
specifying drill options
drilling to external applications
GRAPHING DATA :
creating a graph
selecting a graph type
the graph window
WORKBOOK MAINTENANCE :
scheduling workbooks
schedule workbook dialog
scheduling manager
opening scheduled workbooks
exporting discoverer output
using the export dialog
WORKING WITH SQL AND SETTING OPTIONS :
viewing, exporting, and importing sql
the sql inspector/plan display
setting discoverer options
general options
query governor options
sheet options
format options
advanced options
eul options
USING SQL FUNCTIONS IN DISCOVERER :
using functions in discoverer
function categories
types of functions
string functions
character string formatting functions
character string manipulation functions
numeric functions
numeric comparison and presentation functions
date functions
date recalculation functions
nesting functions
using analytic functions
INTRODUCTION TO DISCOVERER VIEWER :
what is discoverer viewer
starting discoverer viewer
using discoverer viewer
differences between discoverer plus and discoverer viewer
INTRODUCTION TO DISCOVERER DESKTOP INTERFACES (OPTIONAL) :
discoverer desktop
using discoverer desktop
compare/contrast plus and desktop
preparing for practice exercises
workshop system requirements
extracting the student files
preparing to run the sql scripts
creating student accounts
creating the camp_src schema
building the end user layer and business area
setting security and privileges
registering the sales_tax() function
copying the sample word document
testing the setup