OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data
Starting dates and places
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
- 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 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
- Adding Totals and Subtotals
- Creating Subtotals
- Creating Percentages
- Creating Calculations
- Using Analytic Functions Using Calculations in Conditions
- Passing a Parameter to a Calculation
- Using the Graph Wizard to Edit Graphs
- Tips for Using Graphs
- Types of Drilling
- Using Filtered Drill
- Drill to a Related Item
- Drill to a Link
- Scheduling Reports
- Scheduling a Workbook
- Scheduling Manager
- Sharing Scheduled Workbooks
- Exporting Query Results
- Printing Worksheets
- 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
- 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
- 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 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
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.