OBIEE 11g Reports and Dashboards Development

Who can learn this course :

· Business Analysts

· End Users

· Technical Consultant

· Functional Implementer

· Business Intelligence Developer

· Application Developers

· Developer

· Technical Administrator

Pre Requisite :

  • Basic Sql and PLsql

End Objective :

· Build and use views and graphs in analyses

· Combine analysis criteria using set operations and execute direct database requests

· Perform pre- and post-aggregate filtering using filters, groups, and selections

· Add geographical mapping to analyses

· Use Oracle Business Intelligence Mobile to view BI content on a mobile device

· Create and modify dashboards

· Use Oracle BI for Microsoft Office to integrate Oracle BI analysis and dashboard content

· Configure Agents using Delivers to get the results of analyses and deliver them to subscribers

· Create and modify Oracle Business Intelligence analyses

· Use hierarchical columns in analyses and views

· Perform administration tasks related to the development and configuration of dashboards

Course Duration : 35 Hours

Course Content :

· Creating Reports Using Analysis

· Filtering, Totals, and Formatting Views

· Charts and Formatting

· Building Pivot Table

· Adding Calculations and Data Formatting

· Creating Bins Creating Reports Using Analysis

· Filtering, Totals, and Formatting Views

· Charts and Formatting

· Building Pivot Table

· Adding Calculations and Data Formatting

· Creating Bins

· Conditional Formatting

· Advanced Formatting of Tabular Views

· Column Selector View

· View Selector View

· Creating and Configuring Dashboards

· Creating Dashboard Prompts

· Prompting Filters in Reports

· Adding a Saved Filter and Formatting an Existing Analysis

· Ranking and Top and Bottom Analyses

· Analysis Interaction

· Dashboard Action Links

· Using Section Condition Properties

· Design Best Practices

OBIEE 11g Repository (RPD) Development

· OBIEE 11g Architecture Overview

· Powering Up Services & Working within the Physical Layer

· Dimensional Hierarchies, Hierarchical Columns, and Logical Table Sources

· Building Basic Business Measures in the Business Model

· Attribute Columns and Calculated Measures

· Building the Presentation Layer

· Using Aggregate Tables

· Building Time Dependent Measures

· Repository Variables

· Embedded Database Functions