Oracle Discoverer
Training Course
End-user ad-hoc query
and report generation
An intensive
2-day Oracle Discoverer training course
* Get started fast with
Oracle Discoverer reporting
* Understand the End-User
Layer.
* Create and manipulate
Discoverer workbooks and worksheets.
* Create fast, attractive reports directly from your Oracle
database
* Learn how to get the most from your Oracle Data Warehouse
|
|

This is an intensive
2-day Oracle Discoverer training course. This
Discoverer training class covers Discoverer End-user layer (EUL)
and ad-hoc reporting and using Discoverer for fast easy
reports.


This Oracle Discoverer training course
is designed for end-users who have no technical
knowledge.
|

This Oracle Discoverer training was designed b
Donald K. Burleson, author of "Oracle Data Warehousing" and a
respected leader in data warehouse and OLAP technology.
(See also Oracle
Discoverer Administration - A detailed class in
Administration of Oracle Discoverer)
Oracle
Discoverer for End-users
Syllabus
An intensive
2-day Oracle Discoverer Training course
© 2007-2013 by Donald K. Burleson
The
learning goals include using Discoverer for ad-hoc queries,
including query formulation, successive refinement and query
execution. Students also learn Oracle multidimensional OLAP
and understand how to display, aggregate, graph and analyze
multidimensional data displays. Students also learn how to
save, schedule and manage Discoverer reports in offline batch
mode.
INTRODUCTION TO WORKBOOKS
·
Benefits of
Discoverer
·
Understanding
Discoverer Components
·
Starting
Discoverer Desktop
·
Opening a
Workbook
WORKING WITH WORKBOOKS
·
The Workbook
Window
·
Selecting
Sections in Worksheets
·
Formatting
Worksheets
CREATING WORKBOOKS
·
Types Of
Worksheets
·
Creating
Tabular Worksheets
·
Creating
Crosstab Worksheets
CUSTOMIZING THE DISPLAY
·
Customizing
Item Headings
·
Customizing
Data Displays
·
Customizing
Report Headings
CONDITIONS AND PARAMETERS
·
Creating a
Condition
·
Parameters in
Conditions
·
Multiple
Conditions
GROUP SORTS AND SUMMARIES
·
Creating Group
Sorted Output
·
Including
Totals and Subtotals
CALCULATED ITEMS
·
Creating
Calculated Items
·
Calculating
Percentage of the Whole
·
Applying
Functions
·
Conversion
Functions
·
Date
Functions
·
Numeric
Functions
·
String
Functions
·
Miscellaneous
Functions
MANAGING QUERIES, WORKSHEETS AND WORKBOOKS
·
Copy a Query
Sheet as a Table
·
Copy a
Worksheet as a Crosstab
·
Monitoring
Query Execution
CONDITIONS AND SUBQUERIES
·
Creating
Subqueries in Conditions
DRILLS IN WORKSHEETS
·
Identifying
Drill Types
·
Using the Find
Facility as a Drill Feature
ANALYZE DATA GRAPHICALLY
·
Graphically
Analyze Table Output
SCHEDULING AND MANAGING QUERIES
·
Scheduling
Periodical Queries
ADVANCED OPTIONS
- Support for MS Excel and
Other File Formats
- Other Advanced
Features
Discoverer Course Labs:
-
Opening and Using
Workbooks
-
Creating Workbooks
-
Managing Queries, Worksheets &
Workbooks
-
Customizing the
Display
-
Conditions and
Parameters
-
Queries and Subqueries
-
Group
Sorts and Summaries
-
Calculated Items
-
Drills in Worksheets
-
Analyze Data Graphically
Optional Discoverer course topics:
-
Oracle Discoverer installation and
configuration
-
Oracle Discoverer client
requirements
-
Oracle Discoverer OLAP and ROLAP
implementation
-
Business Intelligence Application
Development and Oracle Discoverer
-
Accessing Discoverer Data Sources
for Quality, Completeness and Availability
-
Creating and managing Oracle
Discoverer workbooks and Discoverer worksheets
-
Creating, Saving, Sharing and
Printing Discoverer Worksheets
-
Formatting data and
ordering/grouping of Discoverer result sets
-
Grouping and summarizing
Discoverer report data
-
Oracle Discoverer exception
reporting
-
Filtering Discoverer worksheet
data
-
Creating calculated columns on
Discoverer reports
-
Applying Conditions Using
Parameters in Discoverer
-
Displaying Discoverer Results
Graphically
-
Discoverer Batch Scheduling
Reports
-
Exporting Discoverer
Data
-
Creating Discoverer drill-down
reports
-
Oracle Discoverer
Reporting
-
Analysis of Discoverer Reporting
Requirements
-
Discoverer Client Environment
Assessment
-
Documenting data warehouse
architecture and data structures
-
Customizing Discoverer Report
Design and Development
-
Scheduling and managing batch
reports and scheduling Oracle Discoverer reports
This is a BC Oracle training
course (c) 2007-2013
This Oracle Discoverer training course is fully
customizable. Our instructors will work with your team to
develop an Oracle Discoverer syllabus that meets your specific
training needs.
|