Oracle9iAS Release 2 Discoverer for End Users - Seminare

Seminar-Ziel

This course introduces students to the querying and analytical capabilities of Oracle 9iAS Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer s intuitive and easy-to-use Workbook Wizard.

Teilnehmer Zielgruppe

End Users
Data Warehouse Designer
Data Warehouse Administrator
Business Intelligence Analyst
Data Warehouse Analyst

Kurs Voraussetzungen

Familiarity with Microsoft Windows applications
Familiarity with Web browsers

Seminar-Inhalt

• Introduction to Oracle9iAS Discoverer for End Users
  • The Oracle9i Application Server
  • Oracle s Business Intelligence Solutions
  • Oracle9iAS Discoverer Components
  • Data Warehouse Versus Transactional Systems
  • Using Discoverer with a Data Warehouse
  • Starting Oracle9iAS Discoverer
  • Creating and Editing Discoverer Connections
  • Where to Get Helpful Information
• Creating Ad-hoc Queries
  • Creating a Query and Viewing Output
  • Using the Workbook Wizard
  • Using the Item Navigator
  • Customizing the Viewing Output
  • Editing a Query
• Managing Queries
  • Building and Executing Queries
  • Controlling Query Execution
  • Customizing Worksheets
  • Managing Workbooks
  • Sharing Workbooks
  • Setting Advanced Options
• Customizing Display Properties
  • Customizing Display Properties
  • Setting Default Worksheet Layout Options
  • Setting Default Format Options
  • Applying Custom Format Options to a Worksheet
• Applying Conditions and Using Parameters
  • Overview of Conditions and Parameters
  • Selecting and Applying Predefined Conditions
  • Creating Conditions
  • Creating Complex Conditions
  • Creating Parameterized Conditions
• Creating Group Sorts and Applying Summary Functions
  • Creating a Group Sort Output
  • Creating Totals and SubTotals
  • Creating Percentages
  • Displaying Percentage in the Results Window
• Creating Calculated Items
  • Identifying Types of Calculations
  • Creating a Simple Calculation
  • Building a Complex Calculation
  • Overview of Analytic Functions
  • Analytic Functions Examples
  • Using Calculations in a Condition
  • Passing a Parameter to a Calculation
• Scheduling and Managing Worksheets in Batch Mode
  • Scheduling Worksheets
  • The Scheduling Manager Window
• Analyzing Data with Drills
  • Identifying the Drill Types
  • Drill Up or Down
  • Using the Drill Dialog Box Options
  • Drilling to an External Application
• Analyzing Data Graphically
  • Creating Graphs
  • Customizing Graphs
• Exporting Worksheets to Other Applications
  • Exporting a Worksheet into Other Applications
  • Exporting to Excel
  • Exporting to Reports
  • Printing a Discoverer Worksheet Using the Print Wizard
• Introducing Oracle9iAS Discoverer Viewer
  • Connecting to Discoverer Viewer
  • Main Features
  • Setting Query Execution Options
  • Setting Presentation Options
  • Exporting Results to Other Applications
• Integration of Oracle9iAS Discoverer with Oracle9iAS Portal
  • Overview of an Enterprise Information Portal
  • Overview of Oracle9iAS Portal
  • Discoverer Portlets
  • Creating a Portal Page Using the Oracle9iAS Portal Interface
  • Adding Discoverer Portlets to a Portal Page
  • Selecting Default Settings for Discoverer Portlets
  • Customizing Discoverer Portlets
  • Opening a Workbook in Discoverer from Oracle9iAS Portal

Literatur

nach Absprache

[ Zurück ]