Oracle Discoverer is a business intelligence tool that was widely used for querying and reporting data. Although Oracle Discoverer was discontinued as part of Oracle’s shift toward other tools like Oracle BI and Oracle Analytics Cloud, some companies continue to use it, and training on the tool can still be valuable for legacy systems.

Module 1: Introduction to Oracle Discoverer

• Overview of Oracle Discoverer
  • What is Oracle Discoverer?
  • Key features and functionality
  • Components of Oracle Discoverer (Discoverer Plus, Discoverer Viewer, Discoverer Administrator)
• Understanding Oracle Discoverer Architecture
  • Discoverer Servers and Components
  • Discoverer and the Oracle Database
  • Discoverer Workbooks and Worksheets
  • User Roles and Permissions

Module 2: Getting Started with Oracle Discoverer Plus

• Logging into Oracle Discoverer Plus
  • Introduction to the user interface
  • Customizing the workspace
• Creating and Opening Workbooks
  • Overview of workbooks and worksheets
  • Creating a new workbook
  • Opening existing workbooks
• Basic Query Creation
  • Selecting data from data folders
  • Simple queries: selecting columns and applying filters
  • Sorting and grouping data

Module 3: Working with Data in Oracle Discoverer

• Understanding Data Folders and Items
  • What are folders, and how are they structured?
  • How to find and use items (columns) in a folder
  • Managing folder and item views
• Creating Custom Queries
  • Using the Query Wizard to create ad-hoc reports
  • Using simple and complex filters
  • Working with parameters in queries
  • Applying conditions to data
• Working with Date and Time Data
  • Date and time formatting
  • Filtering and grouping by date/time

Module 4: Enhancing Reports with Calculations and Formulas

• Using Basic Calculations
  • Adding simple calculations (sum, average, etc.)
  • Creating new calculated items
• Advanced Calculations
  • Nested formulas and conditional calculations
  • Using built-in functions (string, number, date, etc.)
• Creating and Managing Formulas
  • Formula syntax
  • Working with different data types in formulas
  • Using formula items in reports

Module 5: Data Presentation and Reporting

• Formatting Reports for Better Presentation
  • Formatting columns and rows
  • Setting up decimal places and date formats
  • Adding headers, footers, and page breaks
• Graphical Reports
  • Creating charts (bar, pie, line, etc.)
  • Customizing chart formats
  • Using graphs to present aggregated data
• Pivot Tables
  • What is a pivot table?
  • Using pivot tables to summarize data dynamically
  • Changing pivot table layouts and views

Module 6: Advanced Reporting Features

• Advanced Filtering Techniques
  • Multi-condition filters
  • Using wildcards and expressions in filters
  • Filter by parameter selection
• Subqueries and Complex Joins
  • Writing subqueries to filter data
  • Using multiple tables in a query with complex joins
• Using Parameters in Reports
  • Creating parameter-driven reports
  • Parameter prompts and default values
• Conditional Formatting and Alerts
  • Using conditional formatting to highlight data
  • Setting up alerts based on report criteria

Module 7: Sharing and Managing Reports

• Exporting Reports
  • Exporting reports to Excel, PDF, HTML
  • Exporting graphs and charts
• Publishing Workbooks
  • How to publish workbooks for other users
  • Managing workbook access and permissions
• Scheduling Reports for Automated Distribution
  • Setting up report schedules
  • Sending reports via email or to a file location

Module 8: Oracle Discoverer Administration

• Introduction to Oracle Discoverer Administrator
  • What is Oracle Discoverer Administrator?
  • Key administrative tasks in Discoverer
• Managing Discoverer Servers and User Access
  • Configuring Discoverer Server and client connections
  • Defining user roles and permissions
  • Creating and managing folders and workbooks for different users
• Backup and Recovery
  • Backup strategies for Discoverer workbooks and configurations
  • Restoring workbooks and server settings

Module 9: Troubleshooting and Performance Optimization

• Performance Tuning in Discoverer
  • Optimizing queries and reports for performance
  • Managing large datasets efficiently
• Common Issues and Troubleshooting
  • Dealing with connection issues
  • Resolving report rendering problems
• Log Files and Diagnostics
  • Understanding Discoverer log files
  • Using diagnostic tools to troubleshoot

Module 10: Moving to Oracle BI and Analytics

• Why Migrate from Oracle Discoverer?
  • Overview of Oracle BI and Analytics Cloud (OAC)
  • Features of Oracle BI tools compared to Discoverer
•