 |
|
Discoverer for End Users
 Click here to contact us
Course Overview
Discoverer for End Users introduces end users to the reporting, querying and analytical capabilities of Oracle's Discoverer reporting tool. 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
- Display graphical data
- Filter data using conditions, paged items and parameterized reports
- Schedule batch mode reports
- Share workbooks with other Discoverer users
- Export workbooks to other applications; for example, Microsoft Excel
- Use Discoverer Viewer to open a workbook and analyze data
- Analyze data by using totals, subtotals, percentages and calculations
- Create reports and ad hoc queries
- Set default worksheet format options
- Format data, column headings, titles and background in a worksheet
Prerequisites
- Familiar with Microsoft Windows applications and Web browsers
- Basic SQL knowledge
Who Should Attend?
- Information technology reporting staff
- Technical business analysts
- Advanced end users
Course Materials
- Discoverer for End Users Course Notes
- Discoverer Reference Book
- Discoverer Sample Script Disk
Duration
Tuition
Course Outline
- Introduction to Discoverer for end users
- This lesson introduces Oracle Discoverer User Edition, Plus and Viewer concepts
- Creating ad hoc queries
- Create tabular and cross-tab 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
|
|
|
|
