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

Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data Training (11gBI-DISC-OLAP)


Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data Training Course Hands-on

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.

Learn To:

● Use the new Discoverer Plus Relational and Discoverer Plus OLAP user interfaces.
● Create ad hoc queries and advanced, interactive reports based on relational or multidimensional data.
● Share reports and analyses with other users.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

● Business Analysts
● Business Intelligence Developer
● End Users
● Sales Consultants

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

Duration: 2 days

Class Prerequisites:

● Familiarity with Web browsers
● Basic knowledge of SQL

Skills Gained:

● Use Oracle BI Discoverer Plus Relational to access a relational data source
● Use Oracle BI 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
● Share reports with other users through Discoverer Viewer and Oracle Portal

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

Request More Information

Time Frame: 0-3 Months4-12 Months

No Comments Yet.

Leave a comment