Oracle 10g R2 BI Disco Plus (O1038) Training Course

Training Course Objectives

This practical course covers Oracle Discoverer Plus and is applicable to all releases but, for the duration of the course, Discoverer 10g Release 2 will be used.

Oracle Discoverer enables professionals and users without database skills to perform complex queries and in depth data analysis.

This one-day course provides a comprehensive insight into the Discoverer tool and the techniques required to use it to access and retrieve data.

Who Should Attend

• Data Administrators
• Support Technicians
• Data Analysis Technicians
• Data Retrievers
• Report Writers

Training Course Prerequisites

• PC Fundamentals
• View Learning Path

Training Course Duration

1 Day

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
• Sharing Workbooks

Formatting Worksheets

• Introduction
• Renaming a Worksheet
• Rearranging Item Columns
• To Move Items in Table
• Worksheets
• Formatting the Item Header
• Formatting the Data
• Stoplight Formatting
• Conditional Formatting
• Creating links

Manipulating Worksheets

• Introduction
• Basic Table Sorting
• Group Sorting
• Sort Table Dialogue
• Copying Items between
• Worksheets
• Exporting Data to Other
• Applications
• Crosstab Reports
• Exporting Crosstabs as Pivot
• tables

Graphs

• Introduction
• Creating a Graph
• Editing the Graph
• Formatting the Graph
• Chart Types

Creating a New Workbook

• Introduction
• Editing a Worksheet
• Duplicating a Worksheet
• Drilling
• Drilling Up and Down

Manipulating Data

• Introduction
• Conditions
• Parameters
• Totals
• Percentages
• Calculations

Advanced Reporting Techniques

• Multiple conditions
• SQL Functions
• Using calculations within
• Conditions and Parameters

Introduction to Discoverer

• Opening reports
• Formatting reports

Next Available Dates

• 15th Sep 2010  Swindon
• 15th Sep 2010  Manchester
• 15th Sep 2010  Swindon
• 29th Sep 2010  Edinburgh