Course Contents
This practical course covers the Oracle Discoverer User Edition. It enables professionals without database skills,
to perform complex queries and in depth data analysis.
Training Course Contents
Introduction
- Introduction to Discoverer
- An Introduction to Databases
Getting Started
- Accessing Discoverer Workbooks
- Opening Existing Workbooks
- Worksheets
- Workbook Window
- Printing your Worksheets
- Page Set Up
- Scheduling Workbooks
Formatting Worksheets
- Introduction
- Multiple Item Selection
- Renaming A Worksheet
- Resizing & Rearranging Item Columns
- To Move Items in Table Worksheets
- Editing Item Headings
- Formatting the Item Header
- Formatting the Data
- Creating and formatting the Title
Manipulating Worksheets
- Introduction
- Basic Table Sorting
- Group Sorting
- Sort Table Dialogue
- Copying Items between
- Worksheets
- Exporting Data to Other Applications
Drilling
- Introduction
- Drilling Up and Down
- Drilling To a Related Item
- Drill to Detail in Another
- Worksheet
- Drilling Out
- Additional Drill Options
Graphs
- Introduction
- Creating A Graph
- Editing the Graph
- Formatting the Graph
- Chart Types
Creating A New Workbook
- Introduction
- Editing A Worksheet
- Duplicating a Worksheet
Manipulating Data
- Introduction
- Format Exceptions
- Conditions
- Parameters
- Totals
- Percentages
- Calculations