PANAPAND :: Courses :: Oracle :: Introduction to Oracle9i: SQL

Oracle BI Suite EE 10g R3: Create Reports and Dashboards for End Users

What you will learn:

This course provides step-by-step instructions for creating ad-hoc queries in Oracle Business Intelligence Answers and incorporating them into Interactive Dashboards, which compose business intelligence applications. Learn to build a simple Oracle BI Interactive Dashboard starting with basic requests created in Answers, then add more complexity as the course progresses, including pivot tables, charts and gauges.

In addition to building Interactive Dashboards, learn to configure and maintain them and how to customize their user interface using cascading style sheets, dashboard styles, and XML message files. Use Oracle BI for Microsoft Office to integrate Oracle BI data and views in Microsoft Office presentations and spreadsheets.

Learn To:

Build queries in Oracle BI Answers
Customize the Oracle BI user interface
Create and modify Oracle BI Interactive Dashboards
Use Oracle BI Content in your Microsoft Office documents

Audience:

End Users

Course Objectives:

Create and modify Business Intelligence requests using Oracle Business Intelligence Answers
Create and modify Interactive Dashboards

Course Topics:

Working with Oracle Business Intelligence Answers

Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
Using advanced formatting

Filtering Requests in Oracle Business Intelligence Answers

Introduction to filters in Answers
Adding filter prompts to requests
Using saved requests as filters

Oracle Business Intelligence Answers: Advanced Features

Combining request criteria using set operations
Executing direct database requests
Editing logical SQL generated by a request

Building Views and Charts in Requests

Introduction to Answers views and charts
Creating and editing charts
Performing common view tasks

Showing Results with Gauge Views

Introduction to Gauge views
Working with Gauge views

Showing Results with Pivot Tables

Introduction to pivot tables
Formatting pivot tables
Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

Introduction to Interactive Dashboards and pages
Dashboard Editor UI elements
Composing dashboard elements

Configuring Oracle Business Intelligence Interactive Dashboards

Types of dashboard content
Embedding content in Interactive Dashboards
Using bookmark links to distribute and save Interactive Dashboards
Use Oracle Business Intelligence Presentation security

Using Oracle BI for Microsoft Office

Introduction to Oracle BI for Microsoft Office
Working with Oracle BI content in Microsoft Office applications

عصر آموزش پناپند - 1391