ERP Products Other Products Virtual Classroom

Search

paypal verified
paypal cartes de crédit

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


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

Now you can study at home by your self and
get certified.

These set teach you everything you need to know to become an Oracle 11g Certified Professional.

The tests are based directly from the information from these books


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


Description:


This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus 11g (Oracle BI Discoverer Plus 11g.)


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 analysis 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 Discoverer Plus Relational and 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


Objectives:


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


Topics:


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 Paremeterized 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


                                                         Shipping

Shipping is free IMMEDIATE DOWNLOAD AFTER PAYMENT .Receive a direct download link in your email in 1 - 3 minutes.

[Do NOT forget to check the junk or Spam mails of your email box]





29.99 $



Enter promotionnal code:







Terms & Policy

Website hosting and design by Zedimage.com       admin