Oracle Discoverer 3.1: Data Exploration

This course introduces participants to the querying and analytical capabilities of Oracle Discoverer 3.1. Participants will learn how to create modify run and refine ad hoc queries. They will also learn how to view chart and analyze multidimensional data. Finally they will learn how to schedule and manage report generation in batch mode.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

End users data analysts and technical support professionals.

Objective

• Create manage and format ad hoc queries.
• Manage worksheets and workbooks.
• Generate customize and export reports.
• Schedule batch reports.
• Customize queries by applying conditions and parameters.
• Create sorts calculations percentages and summaries.
• Analyze date with graphs and drills.

Topics Include

Unit 1: Discoverer 3.1. Overview

• Match the three main Discoverer components to the correct definition.
• Match the available database sources to the correct definition.
• Identify the help options available when using Discoverer 3.1.
• Match key Discoverer 3.1 terms to the correct definition.
• Identify primary functions performed by the Discoverer Administrator.

Unit 2: Creating and Formatting Ad hoc Queries

• Create a new workbook using the Workbook Wizard.
• Include items in a query using the Workbook Wizard.
• Convert a table layout to a page-detail layout using the Workbook Wizard.
• Add a predefined condition to a query using the Workbook Wizard.
• Identify the components of the Results window.
• Identify the available options for customizing information in the Results Window.
• Define pivoting an axis item in the Results window.
• Define display properties.
• Identify the elements of item heading and data that you can customize.
• Identify the datatypes supported by Discoverer 3.1.
• List the steps performed to create and run a query.
• Change the default directory used to store cached data.
• Identify the query actions that you can govern.

Unit 3: Managing Worksheets and Workbooks

• Define worksheets and workbooks.
• Set a default title for worksheets.
• Rename a worksheet using the worksheet tab.
• Duplicate a worksheet as a table using the toolbar.
• Delete a worksheet.
• Save a workbook to the database.
• Open a workbook saved to the database.
• Create a new workbook using the toolbar.
• Delete a workbook from the database.
• Identify the four most common options available for customizing workbooks.
• Schedule a workbook.
• Edit a scheduled workbook using the Scheduling Manager.
• Share a workbook with another user.
• Access the Page Setup dialog box to select formatting options.
• Create and format the header for a printout.
• Format the margins of a printout using the Page Setup dialog box.
• Export a report.
• Review the SQL generated for a worksheet and export the worksheet as SQL.
• Import an SQL file.

Unit 4: Customizing Queries

• Define exception.
• Create and apply an exception.
• Identify conditional operators.
• Create a single condition.
• Differentiate between grouped conditions and nested conditions.
• Add a new condition to an existing condition.
• Change the logical operator for a grouped condition using the Group button in the Edit Condition dialog box.
• Create a nested condition.
• Identify the element of a parameterized query that is supplied by the user when the query is run.
• Create a parameterized query.
• Sort a column of output.
• Apply a group sort.
• Apply a total using the toolbar buttons.
• Apply a summary using the Tools menu.
• Identify the arithmetic operators available for use in Discoverer 3.1 calculations.
• Find a percentage using the tools menu.
• Find a percentage using the toolbar.
• Create a calculation using the Tools menu.
• Create a calculation using the toolbar buttons.
• Identify the elements of a complex calculation.

Unit 5: Drilling Through Data

• Identify the definition of drilling.
• Identify the difference between drilling up an down and drilling to a related item.
• Identify the results from a filtered drill and the results from an unfiltered drill.
• Identify the options available for direct drilling in Discoverer 3.1.
• Identify the options available for hyperdrilling.
• Drill out to an external application using a Hyperdrill plug-in.
• Identify the options available to display the Drill dialog box.
• Change a drill item.
• Identify the options available for customizing drills in Discoverer 3.1.

Unit 6: Graphing Data

• Identify the information available in a graph produced using Discoverer 3.1.
• Generate a graph of crosstab output with the Graph Wizard using the Graph button.
• Generate a graph of table output with the Graph Wizard using the Graph menu.
• Drill down in a graph.
• Identify the methods available to customize a graph in Discoverer 3.1.
• Change the type of graph with the Modify Graph dialog box using the Graph menu.
• Change the type of graph using the New Graph Type button on the Graph Window toolbar.
• Add a legend to a query.
• Change a graph color.
• Rotate the graph.
• Customize a graph title.
• Customize the Y-axis.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media