Oracle Discoverer

COURSE DESCRIPTION

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)

KEY BENEFITS

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

Oracle Discoverer

Course Content

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