Analysing Data with OracleBI Discoverer Plus 10g Training Course
Node ID: 13569
Duration
14 hours
Requirements
Basic computer browser usage. Familiarity with relational models and SQL required but not recommended.
Public Course Dates
There is no public course dates for this training.
This course would cost you around 1790GBP + VAT.
Please submit a public course date request for the exact price.
This course would cost you around 1790GBP + VAT.
Please submit a public course date request for the exact price.
Overview
This course has been created for End Users, Sales Consultants. Business Intelligence Developer or Business Analysts
who wants to learn how to Build Ad-Hoc queries, Create Advanced Reports, Schedule Reports, Share reports and analyses with other users,View reports and Create Discoverer Portlets.
Course Outline
Building Ad Hoc Queries
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
Workbook Properties
Sharing a Workbook
General Query Management Options
Default Sheet Options
Default Format Options
Default Advanced Options
Using the URL Parameters
Creating Advanced Reports Using Plus Relational
Conditional Format
New Stoplight Format
Conditional Formatting
Managing Conditions
Calculations in a Condition
Advanced Calculations and Summary Functions with Discoverer Plus Relational
Totals and Subtotals
Percentages
Calculations
Using Analytic Functions Using Calculations in Conditions
Passing a Parameter to a Calculation
Presenting Data with Graphs in Discoverer Plus Relational
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
Workbook and Worksheet
Conditions
Saved Selections
Calculations
Prebuilt Calculations
Viewing and Using the Graph
Building Advanced Reports Using Discoverer Plus OLAP
Reports Based on Ranking and Exception Criteria
Examining a Ranking Condition
Static and Dynamic Condition Parameters
Stoplight Format
Time-Series Calculations
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
