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

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

Benefits to You

Transform your organization’s data into intelligence for improved decision making. Provide time-critical, relevant and accurate insights. Become more efficient at modifying reports and dashboards.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• End Users

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

Course Objectives

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