Asparona - CONSULT, DELIVER, SUPPORT
SEARCH

BI Discoverer: Analyze Relational & OLAP Data (for End Users)

Course Fees: $1890.00 excl. GST
Course Duration: 2 days
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

 

 

 

Suggested Prerequisites

Familiarity with Web browsers

Basic knowledge of SQL

Prerequisites: No Prerequisits, only suggested
Next Course: BI Discoverer Administrator: Develop an EUL
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

Auckland:
01 Nov - 02 Nov 10
Wellington:
20 Sep - 21 Sep 10
BI Discoverer: Analyze Relational & OLAP Data (for End Users)

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


PRODUCT IMAGES

BI Discoverer: Analyze Relational & OLAP Data (for End Users)

Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data

BI Discoverer: Analyze Relational & OLAP Data (for End Users)

BI Discoverer: Analyze Relational & OLAP Data (for End Users)

BI Discoverer: Analyze Relational & OLAP Data (for End Users)

Quantity


ALL IMAGES
Go Back