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

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

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

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. Learn to query, report and analyze relational and multidimensional corporate data.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Discoverer Plus 11g: Analyze Relational and OLAP Data Certification Training about?

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.

By enrolling in this course, you'll also learn how to use Discoverer Plus Relational to perform ad hoc analysis against relational data sources. You'll develop a deeper understanding of how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.

What are the objectives of Discoverer Plus 11g: Analyze Relational and OLAP Data Certification Training ?

  • 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

Who is Discoverer Plus 11g: Analyze Relational and OLAP Data Certification Training for?

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

What are the prerequisites for Discoverer Plus 11g: Analyze Relational and OLAP Data Certification Training?

Suggested Prerequisite

  • Familiarity with Web browsers
  • Basic knowledge of SQL

Available Training Modes

Live Online Training

2 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

  • Addressing BI Requirements- Portfolio Approach
  • Oracle Fusion Middleware 11g- An Overview
  • Components of Oracle BI Discoverer 11g
  • Evolving role of Business Intelligence
  • Fusion Middleware BI Solution
  • Challenges faced in managing BI applications
  • Data Warehouse Versus Transactional System
  • Key Terminology
  • Getting helpful Information
  • Editing the query output by Sorting, Pivoting, Adding and Deleting items
  • Using Discoverer with a Data Warehouse or a Transactional Database
  • Customizing Display properties of reports
  • Creating Reports
  • End Users
  • Using Discoverer URL Parameters
  • Managing Workbooks and Worksheets
  • Viewing and Modifying Worksheet Properties
  • Adding New Worksheets
  • Setting Query Management, Query Execution, and Query Governor Options
  • Using Cascading Parameters
  • Creating Parameters
  • Using Predefined Conditions
  • Using Conditional Formatting
  • Creating A Parameterized Report
  • Passing Parameters to a Condition
  • Creating and Managing Conditions
  • Using Analytic Function Template in Calculations
  • Passing a Parameter Value to a Condition
  • Using Calculations in Conditions
  • Creating Totals, Subtotals, and Percentages
  • Creating Simple and Complex Calculations
  • Viewing Graphs to Display Worksheet Data
  • Using the Toolbar Options to Edit Graphs
  • Editing Graphs
  • Drilling to a Related Item
  • Drilling up Or Drilling down along a predefined hierarchy
  • Drilling to Detail
  • Drilling to a Link
  • Identifying Different Types of Drilling
  • Scheduling Reports- An Overview
  • Sharing Scheduled Workbooks
  • Managing Scheduled Workbooks
  • Exporting the Query Results to Various Formats- MS Excel, HTML, PDF, Web Query for MS Excel, and so on.
  • Printing Query Results
  • Scheduling A Workbook in Discoverer Plus Relational
  • Measures
  • Describing the Differences between Relational and Multidimensional Data Models
  • Analytic Workspace, and so on.
  • Cubes
  • Dimensions
  • Hierarchies
  • Describing the Primary data types associated with the OLAP Data models
  • Creating and Using Saved Selections
  • Creating a workbook, and a worksheet using Discoverer Plus OLAP
  • Modifying the Layout and Format of Crosstabs and Graphs
  • Creating and Editing OLAP Queries
  • Creating and Using Calculations
  • 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
  • Creating reports based on ranking and exception criteria
  • Adding new worksheets
  • Using Discoverer Viewer to access Discoverer Plus reports (both Relational and OLAP reports)
  • Describing how to publish Discoverer Plus reports on Oracle Portal pages
  • Understanding distribution options for Discoverer Plus reports

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

Discoverer Plus 11g: Analyze Relational and OLAP Data Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews