Oracle - Course Details

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

Oracle Course Description:
This Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data training introduces you to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus 11g (Oracle BI Discoverer Plus 11g.)You'll learn how to use Discoverer Plus to query, report and analyze corporate data.
Oracle Course Duration:
Oracle Course Target Audience:
Business Analysts,Business Intelligence Developer,End Users,Sales Consultants
Oracle Course Prerequisite:
Familiarity with Web browsers,Basic knowledge of SQL
Course Content:
  • Introducing Oracle BI Discoverer 11g

    • Challenges faced in managing BI applications
    • Evolving role of Business Intelligence
    • Addressing BI Requirements- Portfolio Approach
    • Oracle Fusion Middleware 11g- An Overview
    • Fusion Middleware BI Solution
    • Components of Oracle BI Discoverer 11g

  • Getting Started with Ad Hoc Queries Using Discoverer Plus Relational

    • Data Warehouse Versus Transactional System
    • Using Discoverer with a Data Warehouse or a Transactional Database
    • End Users
    • Getting helpful Information
    • Key Terminology
    • Creating Reports
    • Editing the query output by Sorting, Pivoting, Adding and Deleting items
    • Customizing Display properties of reports

  • Managing Relational Queries

    • Managing Workbooks and Worksheets
    • Adding New Worksheets
    • Viewing and Modifying Worksheet Properties
    • Setting Query Management, Query Execution, and Query Governor Options
    • Using Discoverer URL Parameters

  • Creating Advanced Reports Using Discoverer Plus Relational

    • Using Conditional Formatting
    • Using Predefined Conditions
    • Creating and Managing Conditions
    • Creating A Parameterized Report
    • Creating Parameters
    • Passing Parameters to a Condition
    • Using Cascading Parameters

  • Using Advanced Calculations and Summary Functions with Discoverer Plus Relational

    • Creating Totals, Subtotals, and Percentages
    • Creating Simple and Complex Calculations
    • Using Analytic Function Template in Calculations
    • Using Calculations in Conditions
    • Passing a Parameter Value to a Condition

  • Using Graphs to Present Data in Discoverer Plus Relational

    • Viewing Graphs to Display Worksheet Data
    • Editing Graphs
    • Using the Toolbar Options to Edit Graphs

  • Analyzing Data Using Drills in Discoverer Plus Relational

    • Identifying Different Types of Drilling
    • Drilling up Or Drilling down along a predefined hierarchy
    • Drilling to a Related Item
    • Drilling to Detail
    • Drilling to a Link

  • Scheduling and Distributing Reports Using Discoverer Plus Relational

    • Scheduling Reports- An Overview
    • Scheduling A Workbook in Discoverer Plus Relational
    • Managing Scheduled Workbooks
    • Sharing Scheduled Workbooks
    • Exporting the Query Results to Various Formats- MS Excel, HTML, PDF, Web Query for MS Excel, and so on.
    • Printing Query Results

  • Describing the OLAP Data Model

    • Describing the Differences between Relational and Multidimensional Data Models
    • Describing the Primary data types associated with the OLAP Data models :
    • - Dimensions
    • - Measures
    • - Cubes
    • - Hierarchies
    • - Analytic Workspace, and so on.

  • Getting Started with Discoverer Plus OLAP

    • Creating a workbook, and a worksheet using Discoverer Plus OLAP
    • Creating and Editing OLAP Queries
    • Creating and Using Saved Selections
    • Creating and Using Calculations
    • Modifying the Layout and Format of Crosstabs and Graphs

  • Building Advanced Reports Using Discoverer Plus OLAP

    • Adding new worksheets
    • Creating reports based on ranking and exception criteria
    • Adding visual cues (stoplights) to the report that highlight specific data ranges
    • Creating reports using time-series calculations
    • Creating and using calculated (custom) members in a report

  • Distributing Business Intelligence through Discoverer Viewer and Discoverer Portlets

    • Understanding distribution options for Discoverer Plus reports
    • Using Discoverer Viewer to access Discoverer Plus reports (both Relational and OLAP reports)
    • Describing how to publish Discoverer Plus reports on Oracle Portal pages