Loading...

Oracle 10g R2 Business Intelligence Discoverer Plus

Course code: O1038

1 days £360.00
+ VAT

Oracle 10g R2 Business Intelligence Discoverer Plus training course covers Oracle Discoverer Plus and is applicable to all releases.

Course content >

Who Should Attend?

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

Prerequisites

Course Contents

This Oracle 10g R2 Business Intelligence Discoverer Plus training course allows students to get a hands on experience to perform queries and in depth data analysis.

iTrains Oracle 10g R2 Business Intelligence Discoverer Plus course is suitable for professionals and users without database skills. 

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

Oracle 10g R2 Business Intelligence Discoverer Plus 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
Contact us for more information