OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

Total time

OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle 10G.

Description

This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence 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:

  • Build Ad-Hoc queries using Discoverer Plus
  • Create Advanced Reports using Discoverer Plus
  • Schedule Reports using Discoverer Plus
  • Share reports and analyses with other users
  • View reports created through Discoverer Plus and Discoverer Plu…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 10G, Programming (general), Oracle, IT Security, and Retail (Management).

This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence 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:

  • Build Ad-Hoc queries using Discoverer Plus
  • Create Advanced Reports using Discoverer Plus
  • Schedule Reports using Discoverer Plus
  • Share reports and analyses with other users
  • View reports created through Discoverer Plus and Discoverer Plus OLAP in Discoverer Viewer
  • Create Discoverer Portlets

Audience
  • End Users
  • Sales Consultants
  • Business Intelligence Developer
  • Business Analysts

Course Topics Introducing OracleBI Discoverer Building Ad Hoc Queries with OracleBI Discoverer Plus Relational
  • Connecting to OracleBI Discoverer Plus
  • Creating a New Workbook
  • Selecting a Report Template and the Objects to Display
  • Customizing the Worksheet Layout
  • Aggregating Results for Data Points
  • Editing the Query Output: Pivoting
  • Sorting Tables and Crosstabs
  • Formatting Data
Managing Queries
  • Viewing Workbook Properties
  • Sharing a Workbook
  • Duplicating a Worksheet
  • Selecting General Query Management Options
  • Selecting Default Sheet Options
  • Selecting Default Format Options
  • Selecting Default Advanced Options
  • Using the URL Parameters
Creating Advanced Reports Using Plus Relational
  • Creating Conditional Format
  • Creating a New Stoplight Format
  • Managing Conditional Formatting
  • Managing Conditions
  • Creating a New Condition
  • Using Calculations in a Condition
  • Creating Multiple Conditions
  • Creating a New Parameter
Using Advanced Calculations and Summary Functions with Discoverer Plus Relationa
  • Adding Totals and Subtotals
  • Creating Subtotals
  • Creating Percentages
  • Creating Calculations
  • Using Analytic Functions Using Calculations in Conditions
  • Passing a Parameter to a Calculation
Using Graphs to Present Data in Discoverer Plus Relational
  • Using the Graph Wizard to Edit Graphs
  • Tips for Using Graphs
Analyzing Data Using Drills in Discoverer Plus Relational
  • Types of Drilling
  • Using Filtered Drill
  • Drill to a Related Item
  • Drill to a Link
Scheduling and Distributing Reports Using Discoverer Plus Relational
  • Scheduling Reports
  • Scheduling a Workbook
  • Scheduling Manager
  • Sharing Scheduled Workbooks
  • Exporting Query Results
  • Printing Worksheets
Understanding the OLAP Data Model
  • Oracle BI Discoverer Data Model Options
  • Dimensional Data Model with Relational Data Types
  • Multidimensional Data Types and Models
  • Measure Types
  • Dimensional Views
  • Hierarchies
  • Levels and Attributes
  • Analytic Workspaces
Getting Started with Discoverer Plus OLAP
  • Examining the Common Schema AW Data Model : Dimensions and Measures
  • Creating a Workbook and Worksheet
  • Creating Conditions
  • Creating Saved Selections
  • Creating Calculations
  • Using Prebuilt Calculations
  • Viewing and Using the Graph
Building Advanced Reports Using Discoverer Plus OLAP
  • Creating Reports Based on Ranking and Exception Criteria
  • Examining a Ranking Condition
  • Static and Dynamic Condition Parameters
  • Creating a Stoplight Format
  • Creating Reports Using Time-Series Calculations
  • Creating Forecast Reports
Distributing Business Intelligence through Discoverer Viewer and Discoverer Portlets
  • Distributing Discoverer Plus Reports
  • Sharing Discoverer Plus OLAP Content
  • Specifying Access Rights to Shared Content
  • Opening Discoverer Plus OLAP Reports
  • Modifying the Layout and Format of Worksheet Items
  • Analyzing Data with Graphs
  • Linking and Unlinking a Worksheet Layout
  • Examining Discoverer and Oracle Application Server PortalAdding Discoverer Content to a Portal Page

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
  • Access multidimensional data source using OracleBI Discoverer Plus OLAP
  • Access relational data source using OracleBI Discoverer Plus OLAP
  • Create graphs to present data

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.