Oracle Discoverer Training Course

End-user ad-hoc query and report generation

An intensive 2-day hands-on Oracle Discoverer training course

This course is taught at your Company site with up to 20 students.  Click here for on-site course prices Optional supplemental mentoring

* 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 hands-on 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.     Oracle Discoverer 10g Handbook Michael Armstrong-Smith Oracle Press ISBN: 0072262141 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 hands-on Oracle Discoverer Training course
© 2007-2009 by Donald K. Burleson

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
   

• 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-2009

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.