RKG Technologies: ITBiz Training

		1-877-482-0809
		info@training-ITBiz.com

We provide Microsoft Tools, Data Bases, ETL, Business Applications, Project Management, Reporting tools and several other IT courses at our locations or at corporate facilities. We develop and customize training courses for all corporate training needs for IT managers, IT staff and end users. With our experienced faculty and with our proven course development process, we can create an effective curriculum and can fulfill all corporate training requirements.

For further details
Call Us 1-877-482-0809
Or send a message to
info@training-ITBiz.com

Oracle Discoverer

Software Version	Oracle Developer Suite 10g v9.0.4
Course Duration	4 Days
Course Type	Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training

Course Overview

This course covers complete capabilities of Oracle Discoverer reporting tool. This course also covers ad-hoc reporting, data aggregation, report creation workbook wizard, graphical data presentation, use of simple and advanced calculations and creating more user friendly reports.

Intended Audience for this course

This course is designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, Business Intelligence Developer, Data warehouse Administrator, Data Modelers, End Users, ERP Developers, DBAs, Functional Consultants, IT management and Staff, Business Analysts, Data Warehouse Analyst, Technical Consultants, Students and also those who want to become Oracle Applications Consultants.

Course Topics

Introduction to Oracle Discoverer

Introduction to Discoverer
Components of Oracle Discoverer
Queries
Conditions and Parameters
Importing and Exporting Reports

Discoverer Viewer

Connect to a data source
Oracle BI Discoverer Viewer Overview
Pivoting and Sorting Worksheet Items
Formatting Worksheet Items
Drilling
Analyzing Data with Graphs and Drills
Printing and Exporting a Worksheet

Ad Hoc Queries

Introduction to Workbook
Create Ad-hoc queries
Create and add worksheet
Sorting
Managing Queries
Creating Subqueries

Create Ad Hoc Queries – Advanced Features

Format Data
Create Totals
Create Subtotals
Create Percentages
Drill to related item
Drill up
Advanced drill
Drill to link
Using Graphs
Scheduling and Managing Reports

Discoverer Administrator

Introduction to End User Layer
Create and manage Business Area
Access Privileges
Complex folders
Calculations and Hierarchies
Summary Management
Testing

Instructor-Led On-Line Classes are designed to use the latest technologies to deliver a highly interactive learning experience. On-Line training is a virtual classroom wherein the teacher and students can share the screens interactively. Instructor can visit student’s computer via remote control during exercises and provide assistance to debug and solve the problems. Instructor-Led On-Line Training (ILT) has several advantages such as convenience and avoiding travel to go to classroom. With an effective instructor and good course design, distance learning can be effective and engaging.