Discoverer for End Users

 Click here

Course Overview

This course introduces the reporting, querying and analytical capabilities of Discoverer. Students will lean how to view data stored in a relational database and develop reports based upon that data using Discoverer. Students will learn how to create, modify, and specify ad hoc queries using Discoverer's Workbook Wizard. They will learn how to present graphical data and how to format query results into customized reports. Students will learn how to implement simple and advanced calculations.

Course Goals

• Create reports and ad hoc queries
• Format data, column headings, titles and background in a worksheet
• Filter data using conditions, paged items and parameterize reports
• Analyze data by using totals, sub-totals, percentages and calculations
• Display graphical data
• Schedule batch mode reports
• Share workbooks with other Discoverer users
• Set default worksheet format options
• Export workbooks to other applications for example Microsoft Excel
• Use Discoverer Viewer to open a workbook and analyze data

Prerequisites

• Familiar with Microsoft Windows applications and Web browsers
• Basic SQL knowledge

Who Should Attend?

• IT Reporting Staff
• Technical Business Analysts
• Advanced End Users

Course Materials

• Discoverer for End Users Course Notes
• Discoverer Reference Book

Duration

• Two (2) days

Course Outline

• Introduction to Discoverer for End Users
  • This lesson introduces Oracle Discoverer User Edition, Plus and Viewer concepts
• Data Warehousing
  • How Discoverer can give you the benefits of a DW without the design and maintenance effort
• Creating Ad Hoc Queries
  • Create tabular and crosstab queries using a wizard
• Managing Queries
  • Manage workbooks and worksheets, and control the execution of queries
• Customizing Display Properties
  • Customize the appearance of the properties of results
• Conditions and Parameters
  • Apply conditions and run parameterized queries
• Creating Subqueries
  • What is a subquery and how to create simple and correlated subqueries
• Creating Group Sorts and Applying Summary Functions
  • How to create breaks and compute summary functions
  • How to create percentage items
• Calculated Items
  • Create and use calculated items
• Scheduling and Managing Reports in Batch Mode
  • How to submit, view and delete reports in batch mode
• Analyzing Data with Drills
  • How to use the drill facilities to generate both detail and summarized data
• Analyzing Data Graphically
  • Structure the items in the analyzer window to chart the results
  • How to customize charts
• Importing and Exporting Reports, and Command-Line Interface
  • Learn how to export your reports to different applications
  • How to use the command line interface
• Discoverer Plus
  • The features available in Discoverer Plus