Oracle Discoverer Training Class

Discoverer Administration & Management

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

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

* Understand Workflow and the Discoverer viewer. * Get started fast with Oracle Discoverer reporting * Understand the End-User Layer. * Create and manipulate Discoverer workbooks and worksheets. * See tips for creating robust data warehouse schemas * Understand OLAP and ROLAP in Plain English * Learn how to get the most from your Oracle Data Warehouse

This is an intensive 5-day hands-on Oracle Discoverer training course.  This Discoverer class covers both Discoverer End-user layer (EUL) (2-days) and Discoverer administration (3-days).      Oracle Discoverer 10g Handbook Michael Armstrong-Smith Oracle Press ISBN: 0072262141 This Oracle Discoverer training course is designed for practicing Oracle professionals who have basic experience with Oracle databases and wish to understand the use of Oracle discoverer for ad-hoc reporting, data aggregation and report creation.

This Oracle Discoverer training course was designed by Donald K. Burleson with many respected leaders in Oracle Discoverer technology. Burleson Consulting instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense hands-on Oracle Discoverer training.

(See also Oracle Discoverer for end-users - A fun class in ad-hoc reporting with Oracle Discoverer)

Oracle Discoverer

Syllabus

An intensive 5-day hands-on Oracle Forms Training course
© 2007-2009 by Donald K. Burleson

DAY 1

Introduction to Oracle Discoverer

·        Benefits of Discoverer

·        Components of Oracle Discoverer

·        Introducing the PUBS database

Using Discoverer Viewer

Lesson 1            Connect to a relational data source OracleBI Discoverer Viewer
Lesson 2            Pivoting and Sorting Worksheet Items
Lesson 3            Formatting Worksheet Items
Lesson 4            Drilling
Lesson 5            Analyzing Data with Graphs
Lesson 6            Printing and Exporting a Worksheet
 

DAY 2

Using Discoverer Plus to Create Ad Hoc Queries

Lesson 1            Open an workbook
Lesson 2            Create ad hoc queries and save workbook
Lesson 3            Create worksheet
Lesson 4            Add new worksheet
Lesson 5            Sort table data
Lesson 6            Sort crosstab data

DAY 3

Using Discoverer Plus to Create Ad Hoc Queries

Lesson 1            Format Data
Lesson 2            Create Totals
Lesson 3            Create Subtotals
Lesson 4            Create Percentages
Lesson 5            Drill to related item
Lesson 6            Drill up

DAY 4

Using Discoverer Plus to Create Advanced Ad Hoc Queries, continued

Lesson 1            Advanced drill
Lesson 2            Drill to link
Lesson 3            Using graphs

Creating a Business Area Using Discoverer Administrator

Lesson 4            Create an End User Layer
Lesson 5            Create a Business Area
Lesson 6            Exploring the Business Area

DAY 5

Creating a Business Area Using Discoverer Administrator, continued

Lesson 1            Access privileges
Lesson 2            Complex folders
Lesson 3            Calculations and Hierarchies
Lesson 4            Summary Management
Lesson 5            Creating summaries
Lesson 6            Testing the Business Area using Discoverer Viewer

BC is a leader in Oracle Discoverer training.