OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

What you will learn
 This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus (OracleBI Discoverer Plus.)

Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analyses against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.

Learn to:

  • Use the new OracleBI Discoverer Plus and Discoverer Viewer user interfaces
  • Create ad hoc queries and advanced, interactive reports based on relational or multidimensional data
  • Share reports and analyses with other users



Audience
 Business Analysts
Business Intelligence Developer
End Users
Sales Consultants

Prerequisites
 Basic knowledge of SQL
Familiarity with Web browsers

Course Objectives
 Use OracleBI Discoverer Plus Relational to access a relational data source
Use OracleBI Discoverer Plus OLAP to access a multidimensional data source
Create ad hoc queries and advanced reports based on relational or multidimensional data
Create exception or stoplight formatting
Use graphs to present data
Analyze data using drilling and pivoting
Generate parameterized reports
Create calculations and conditions
Schedule reports in batch mode
Share reports with other users through Discoverer Viewer and Oracle Portal

Course Topics
Introducing OracleBI Discoverer
Getting Started with Ad Hoc Queries Using Plus Relational
Managing Relational Queries
Creating Advanced Reports Using Plus Relational
Using Advanced Calculations and Summary Functions with Plus Relational
Using Graphs to Present Data in Plus Relational
Analyzing Data Using Drills in Plus Relational
Scheduling and Distributing Reports Using Plus Relational
Describing the OLAP Data Model
Getting Started Using Discoverer Plus OLAP
Building Advanced Reports Using Discoverer Plus OLAP
Distributing Business Intelligence through Discoverer Viewer and Discoverer Portlets
Suggested Next Courses
 OracleBI Discoverer Administrator 10g: Develop an EUL
Oracle Database 10g: Using OLAP

Related Courses
 OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data Self-Study CD