Oracle

OracleBI Discoverer Plus 10 g : Analyze Relational and OLAP Data

Course Code: D17427GC10      Days: 2
Show all Oracle Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Central London
City
London (EC2) 13/10/08 £ 924
England
West Midlands
Birmingham (B90) 24/11/08 £ 924
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This course introduces students to the querying and analytical capabilities of our 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.

Audience

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

Skills Gained

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

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

Prerequisites

  • Basic knowledge of SQL
  • Familiarity with Web browsers

Course Outline

  • 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

Follow On Courses

OracleBI Discoverer Administrator 10g: Develop an EUL


How to make a booking for the D17427GC10 course

 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership