Instructor-led training
Oracle Bi Discoverer Plus 11g: Analyze Relational And Olap Data
This 2-day course 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.
What you'll learn
This 2-day course 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 0 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.
Prerequisites
Familiarity with Web browsers - Basic knowledge of SQL
Course Outline
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
Training locations
Oracle Bi Discoverer Plus 11g: Analyze Relational And Olap Data training across the U.S. and beyond.
We provide Oracle Bi Discoverer Plus 11g: Analyze Relational And Olap Data training onsite and live online for organizations throughout the United States and internationally.
- Denver
- Atlanta
- Phoenix
- Boston
- Sacramento
- Austin
- Salt Lake City
- Raleigh
- Columbus
- Nashville
- Indianapolis
- Richmond
- and more
View all Oracle Bi Discoverer Plus 11g: Analyze Relational And Olap Data training locations
- Denver, Colorado
- Montgomery, Alabama
- Little Rock, Arkansas
- Atlanta, Georgia
- Juneau, Alaska
- Indianapolis, Indiana
- Honolulu, Hawaii
- Trenton, New Jersey
- Springfield, Illinois
- Providence, Rhode Island
- Boston, Massachusetts
- Phoenix, Arizona
- Sacramento, California
- Dover, Delaware
- Tallahassee, Florida
- Boise, Idaho
- Richmond, Virginia
- Des Moines, Iowa
- Topeka, Kansas
- Frankfort, Kentucky
- Baton Rouge, Louisiana
- Augusta, Maine
- Annapolis, Maryland
- Lansing, Michigan
- Saint Paul, Minnesota
- Jackson, Mississippi
- Jefferson City, Missouri
- Helena, Montana
- Lincoln, Nebraska
- Carson City, Nevada
- Concord, New Hampshire
- Santa Fe, New Mexico
- Albany, New York
- Raleigh, North Carolina
- Bismarck, North Dakota
- Columbus, Ohio
- Oklahoma City, Oklahoma
- Salem, Oregon
- Harrisburg, Pennsylvania
- Columbia, South Carolina
- Pierre, South Dakota
- Nashville, Tennessee
- Austin, Texas
- Salt Lake City, Utah
- Montpelier, Vermont
- Olympia, Washington
- Charleston, West Virginia
- Madison, Wisconsin
- Cheyenne, Wyoming
- Hartford, Connecticut
- Toronto, Canada
- Berlin, Germany
- Stockholm, Sweden
- London, United Kingdom
- Dublin, Ireland
Train your team with HSG
Private, instructor-led training customized for your organization.
- Onsite or live online delivery
- Customized curriculum
- Training for groups of 3 or more
- Flexible scheduling
- Experienced instructors
Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com
Related training
Browse all Oracle courses →
Ready to train your team?
Let's customize this training for your organization.
Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.