Description 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
Objectifs
Create and modify Business Intelligence requests using Oracle Business Intelligence Answers
Create and modify Interactive Dashboards
SOMMAIRE
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
