Name: OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data
Course Code: OR17427
Duration: 2
Scheduled Dates for OR17427
This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus (OracleBI 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:
* Use the new OracleBI Discoverer Plus and Discoverer Viewer user interfaces
* Create ad hoc queries and advanced, interactive reports based on relational or multidimensional data
* Share reports and analyses with other users
Target Audience
Business Analysts
End Users
Sales Consultants
Business Intelligence Developer
Key Topics
- Introducing OracleBI Discoverer
- Getting Started with Ad Hoc Queries Using Plus Relational
- Managing Relational Queries
- Creating Advanced Reports Using Plus Relational
- Using Advanced Calculations and Summary Functions with Plus Relational
- Using Graphs to Present Data in Plus Relational
- Analyzing Data Using Drills in Plus Relational
- Scheduling and Distributing Reports Using Plus Relational
- Describing the OLAP Data Model
- Getting Started Using Discoverer Plus OLAP
- Building Advanced Reports Using Discoverer Plus OLAP
- Distributing Business Intelligence through Discoverer Viewer and Discoverer Portlets
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
Required Skills/Experience
- Basic knowledge of SQL
- Familiarity with Web browsers
Suggested Next Course(s)
- OracleBI Discoverer Administrator 10g: Develop an EUL
- Oracle Database 10g: Using OLAP
Fee: $1,200.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
