Audience:

• End Users
• Business Analysts

Prerequisites:

Suggested Prerequisites:

• Familiarity with Microsoft Windows applications
• Familiarity with Web browsers
• SQL Basic Knowledge

Course Objectives:

• Display data graphically
• Filter data by using conditions and create parameterized reports
• Schedule reports in batch mode
• Share workbooks with other users
• Export workbooks to other applications
• Open a workbook and analyze data using OracleAS Discoverer Viewer
• Use and customize Discoverer Portlets in OracleAS Portal
• Analyze data by using totals, percentages, and advanced calculations
• Generate reports and ad hoc queries
• Select default worksheet format options
• Format data, headings and background in a worksheet

Course Topics:

Introducing OracleAS Discoverer 10g

• Business Intelligence Tools
• Discoverer Components
• Connecting to Discoverer Plus
• Data Warehouse Versus Transactional Systems
• Using Discoverer with a Data Warehouse
• Online Help and Key Terminology
• The Discoverer Administrator
• The Training Database

Creating Ad-hoc Queries

• Creating a Query: Workflow
• Using the Workbook Wizard
• Editing a Query

Managing Queries

• Building and Executing Queries
• Controlling Query Execution
• Managing Worksheets
• Managing Workbooks
• Setting Query Management Options

Customizing Display Properties

• Result Set Display Options
• Setting Default Worksheet Display Options
• Customizing Display Properties for The Current Worksheet

Applying Conditions and Using Parameters

• Selecting and Applying Predefined Conditions
• Selecting and Applying User-Defined Conditions
• Creating a New Condition
• Nesting Conditions
• Using Parameters
• Creating Parameterized Conditions

Creating Group Sorts and Applying Summary Functions

• Sorting Output: Overview
• Sorting and Grouping Data in Tables
• Sorting Data in Crosstabs
• Creating Totals and SubTotals
• Creating and Displaying Percentages

Creating Calculated Items

• Identifying Types of Calculations
• Creating a Simple Calculation
• Building a Complex Calculation
• Using the Analytic Calculations Templates
• Creating Analysis Calculations
• Using Calculations in a Condition
• Passing a Parameter to a Calculation

Scheduling and Managing Reports in Batch Mode

• Scheduling Workbooks Using Discoverer Plus
• The Scheduling Manager Window

Analyzing Data with Drills

• Identifying the Drill Types
• Drill Up or Down
• Drilling to an External Application

Analyzing Data Graphically

• Displaying Data Graphically
• Creating a New Graph
• Editing Graphs
• Customizing Graphs
• Using Pie Charts

Exporting a Worksheet to Other Applications and Printing a Worksheet

• Exporting a Worksheet into Other Applications
• Exporting to Excel or HTML
• Exporting an Worksheet to an Excel Pivot Table
• Exporting to Oracle Reports in XML Format
• Printing a Worksheet Using the Print Wizard

Introducing Oracle9iAS Discoverer Viewer

• Connecting to Oracle9iAS Discoverer Viewer
• Using the Main Features of Discoverer Viewer
• Setting Query Execution Options
• Setting Presentation Options
• Creating a Bookmark to a Worksheet Using Discoverer Viewer

Introducing OracleAS Discoverer Viewer

• Connecting to Oracle9iAS Discoverer Viewer
• Discoverer Portlets
• Customizing Discoverer Portlets