Session 1: WHAT IS ORACLE DISCOVERER
- Overview of Oracle Discoverer
- Oracle Discoverer Components
- Connecting to Oracle Discoverer
- Workbooks and Worksheets
Session 2: WORKBOOK BASICS
- The Oracle Discoverer Workbook Window
- The Button Bars
- Displaying Data
- Selecting Worksheet Sections
- Viewing Pages
Session 3: WORKBOOK FORMATTING
- Re-ordering and Resizing Columns
- Formatting Headings and Data
- Worksheet Titles
Session 4: CREATING A WORKBOOK
- Overview of Workbook Creation
- Adding a Table Layout Worksheet
- Adding a Crosstab Layout Worksheet
- Page-Detail Worksheets
- Duplicating Sheets
- Worksheet Management
Session 5: CONDITIONS
- Creating and Editing a Condition
- Creating and Using Parameters
- Advanced Conditions
Session 6: COUNTS AND CALCULATIONS
- Creating COUNTS on a worksheet
- Creating and Editing Calculations
- Introduction to Oracle functions
Session 7: GRAPHING YOUR DATA
- Overview of Graphs in Discoverer Worksheets
- The Graph Tool Bar
- Creating a Graph
- Modifying a Graph
- Drilling in a Graph
Session 8: WORKBOOK MANIPULATION
- Pivoting Data
- Drilling into Data
- Sorting Data
Session 9: DATA ANALYSIS TOOLS
- Overview of the Data Analysis Tools
- Creating and Editing a Total
- Creating and Editing a Percentage
- Conditional Formatting with Exceptions
- Note - in practice this session may start on the first day
Session 10: REPORTS
- Printed Reports
- Scheduled Reports
- Using the Scheduling Manager
Session 11: ADVANCED FEATURES
Session 12: ANALYTIC FUNCTIONS
- Introduction - Oracle Analytic Functions and their Purpose
- Examples of Oracle Analytic Functions
- Creating Calculations using Oracle Analytic Functions
Session 13: DISCOVERER VIEWER
- Overview of Oracle Discoverer on the Web
- Creating Private Connections
- Using Oracle Discoverer Viewer