Training & Certifications

Oracle BI 11g R1: Create Analyses & Dashboards for End Users

This course provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. It will begin by building basic analyses to include in dashboards, with more complexity as the course progresses. It will transform organization’s data into intelligence for improved decision making. Provide time-critical, relevant and accurate insights. Become more efficient at modifying analyses and dashboards.

Program Objectives

At the end of the program, the participants will be able to :

  1. Build and use views and charts in analyses
  2. Create and modify Interactive Dashboards
  3. Create and modify Oracle Business Intelligence analyses using Analyses Editor
  4. Use BI Composer
  5. Use hierarchical columns in analyses and views

Target Audience

This program is aimed for End User.

Duration

This program is 2 days of intensive training class.

Requirement

There are no prerequisites for this program.

Program Modules

Module 1 : Introducing Oracle Business Intelligence Enterprise Edition
  1. Introduction to Oracle BI
  2. Architecture overview

Module 2 : Working with Oracle Business Intelligence Analyses
  1. Introduction to Oracle BI Analysis Editor
  2. Oracle BI column types
  3. Working with analyses in Oracle BI
  4. Using advanced formatting

Module 3 : Limiting and Grouping Data in Analyses
  1. Introduction to filters and selections
  2. Creating, editing, and grouping filters
  3. Adding prompts to analyses
  4. Dynamic filtering
  5. Using saved analyses as filters

Module 4 : Working with Views and Graphs in Analyses
  1. Introduction to views, graphs, and editors
  2. Working with views in Compound Layouts
  3. Creating and editing graphs
  4. Linking master-detail views
  5. Performing common view tasks

Module 5 : Showing Results With Pivot Tables
  1. Creating, arranging, and formatting a pivot table
  2. Using hierarchical columns
  3. Sorting in pivot tables
  4. Setting aggregation and using totals
  5. Showing an item's relative value
  6. Building calculations and displaying running sums

Module 6 : Creating Oracle Business Intelligence Dashboards
  1. Creating and editing dashboards
  2. Using the Dashboard Builder
  3. Exploring dashboard object properties and options
  4. Publishing dashboard pages
  5. Creating personal customizations and using other page options

Module 7 : Configuring Oracle Business Intelligence Dashboards
  1. Exploring types of dashboard content
  2. Embedding content in dashboards

Module 8 : Creating Dashboard Prompts and Variables
  1. Understanding variables
  2. Adding a named dashboard prompt to a dashboard
  3. Adding a hidden named dashboard prompt to a dashboard
  4. Creating additional prompt page and setting page preferences
  5. Adding variable prompts to a dashboard

Module 9 : BI Composer
  1. Examining BI Composer Components
  2. Creating an Analysis by Using BI Composer
Scroll to Top