ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading
Trust Your IT Training   |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
Email Training Course

OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

Format: Instructor-Led Classroom
Other Formats:
 
 

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 Plus OLAP in Discoverer Viewer
  • Create Discoverer Portlets
 
Oracle Certified Training Course   Oracle Training Savings
 

Skills Gained
 

  • 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

Who Can Benefit
 

  • Business Analysts

  • Business Intelligence Developer

 

  • End Users

  • Sales Consultants

Prerequisites
 

  • Familiarity with Web browsers

 

  • Basic knowledge of SQL
 
Enroll For This Class
Enroll For This Class
Oracle DB PeopleSoft Hyperion This course is taught by Certified Oracle instructors.

Oracle University has awarded ExitCertified the 2009 Partner of the Year and Outstanding Instructor Quality Awards

There is a difference....learn more.
Training Class Enrollment Ask A Question About This Training
Code: 10gBI-DISC-OLAP
Format: Instructor-Led Classroom
Length: 2
Certified By: Oracle
Tuition (USD): $1,200
Browse Similar Training Classes
Related training classes
Sort Schedule By: 
No Course Dates There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
   
Request course date Request Course On-Site
 

OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data Content Details
 
 
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
Managing Queries
  • 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 Advanced Reports Using Plus Relational
  • 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
Using Advanced Calculations and Summary Functions with Discoverer Plus Relationa
  • Adding Totals and Subtotals
  • Creating Subtotals
  • Creating Percentages
  • Creating Calculations
  • Using Analytic Functions Using Calculations in Conditions
  • Passing a Parameter to a Calculation
Using Graphs to Present Data in Discoverer Plus Relational
  • Using the 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
  • Creating a Workbook and Worksheet
  • Creating Conditions
  • Creating Saved Selections
  • Creating Calculations
  • Using Prebuilt Calculations
  • Viewing and Using the Graph
Building Advanced Reports Using Discoverer Plus OLAP
  • 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 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


  ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
  When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

There is a difference. Learn from the source.		  
     
Training Contacts    
Training Provided Across North America
     
Atlanta Training
Austin Training
Boston Training
Chicago Training
Dallas Training 		Denver Training
Hampton Training
Houston Training
Indianapolis Training
Kansas City Training 		Los Angeles Training
Las Vegas Training
New York Training
Philadelphia Training
Phoenix Training 		Sacramento Training
San Francisco Training
San Jose Training
Tampa Training
Washington Training

View All US Training Centers
Worldwide and All US Cities:
408.288.3948		 Got Questions?
We are happy to help. Just email us with this form and we'll get back to you shortly.
   



(c) 2010 ExitCertified Corp. All rights reserved.


ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
 
Sun Microsystems Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class, CISCO Training, VMWare Training SUSE Training, RedHat Training , JBoss Training
         
MySQL Training Apple Training Hitachi - HDS Training Project Management PMI Training  
  Apple Course, Leopard Training, Xsan Training