Oracle 9iAS: Discoverer Plus for End Users

This course introduces students to the querying and analytical capabilities of Oracle Discoverer4i Plus. Students learn how to create modify run and refine ad hoc queries using multidimensional data. Students also learn how to create edit and customize graphs to analyze data.

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

The intended audiences for this course are end users data analysts and technical support professionals. Suggested prerequisite would be familiarity with Microsoft Windows applications.

Objective

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

Topics Include

Unit 1: Discoverer4i Plus Overview

• Match the Discoverer component with its primary function.
• Identify the primary tasks of the data administrator.
• Match the data sources that Discoverer can access with their correct definitions.
• Match the Discoverer terms with their correct definition.
• Connect to a database by using Discoverer4i Plus.
• Open an existing workbook from the database.
• Identify the main components of the Results window.
• Match the help sources available in Discoverer with their correct function.

Unit 2: Creating Simple Queries

• Sequence the steps required for building and executing a query.
• Label the various types of report templates with their correct examples.
• Create a new workbook by using the Workbook Wizard.
• Select items to include in a query by using Step 2 of the Workbook Wizard.
• Change the layout of information in a query by using Step 3 of the Workbook Wizard.
• Drill down through data by using the drill facility.
• Drill up through data by using the drill facility.
• Perform filtered or unfiltered drills on data in a crosstab by drill facility.
• Drill to an external application.
• Control query prediction and data retrieval by using the Query Governor.
• Format the data displayed in a worksheet by using the Sheet Format dialog box.
• Format an item heading displayed in a query by using the Format dialog box.
• Format the data displayed in a query by using the Format dialog box.

Unit 3: Workbooks and Worksheets

• Create a new worksheet in an existing workbook by using the toolbar.
• Change the order of sheets in a workbook by using the Move Worksheets dialog box.
• Edit the selection of items in a query by using the menu bar.
• Change the layout of items in a worksheet.
• Duplicate a worksheet by using the toolbar.
• Rename a worksheet by using the toolbar.
• Set the default format for worksheet data by using the Default Formats dialog box.
• Set the default format for column headings by using the Default Formats dialog box.
• Set the default format for worksheet totals by using the Default Formats dialog box.
• Save a workbook to the database.
• Delete a workbook from the database.
• Share a workbook with another user.
• Set general options for opening workbooks by using the General dialog box.
• Export the data in a worksheet to another application by using the Export Wizard.
• Export a graph to another application by using the Export Wizard.
• Export the data in a worksheet to Microsoft Excel or HTML by using the toolbar shortcuts.

Unit 4: Customizing Queries

• Match the conditional operator with its correct definition.
• Create and apply a single condition to a query.
• Add a new condition to an existing condition by using the Edit Condition dialog box.
• Create a nested condition by using the New Condition dialog box.
• Sort data in a table in ascending or descending order by using the Sort dialog box.
• Sort data in a crosstab in ascending or descending order by using the Sort Crosstab dialog box.
• Apply an existing totals definition to a table or crosstab.
• Create and apply a grand total to a table or crosstab.
• Create and apply a subtotal to a table or crosstab.
• Create a custom label for a totals definition by using the Edit Total dialog box.
• Create and apply a percentage to data in a table by using the menu bar.
• Create and apply a percentage to data in a crosstab by using the toolbar.
• Create a custom label for a percentage definition by using the Edit Percentages dialog box.
• Create a simple calculation by using the Calculations dialog box.
• Match the SQL functions used in building complex calculations with their correct definitions.
• Create a calculation that uses a SQL function.
• Match the analytic functions used in building advanced calculations with their correct definitions.
• Create a ranking report that uses an analytical function.
• Create a single parameter by using the New Parameter dialog box.
• Apply a parameter to a worksheet by using the Edit Parameter Values dialog box.
• Change the value of a parameter by using the Edit Parameter dialog box.
• Create a parameterized condition.

Unit 5: Graphing Data

• Identify the main components of a graph.
• Create a new graph by using the Graph Wizard.
• Position a graph in the Results window by using the Graph menu.
• Change the graph type and subtype by using the Graph Wizard.
• Set options for titles totals and series by using the Graph Wizard.
• Set options for the x-axis of a graph by using the Graph Wizard.
• Set options for the y-axis of a graph by using the Graph Wizard.
• Set options for the plot area of a graph by using the Graph Wizard.
• Add a legend to a graph and format it by using the Graph Wizard.
• Edit a graph by using the Graph Toolbar.

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