Introduction:

The course begins with an introduction to the fundamental concepts related to business intelligence and dimensional modelling. You will explore Oracle Business Intelligence Enterprise Edition user interfaces (including Oracle BI Answers) and share analytical requests for viewing within Interactive Dashboards. This course also covers ‘Oracle BI Administration Tool’ and details of various reporting formats using ‘BIP’.

Objectives:

  • Identify the analytical business challenge and the solution provided by Oracle BI products
  • Describe the role of key components in the architecture
  • Describe the relationships among the components
  • Identify and describe repository features and functions
  • Navigate through an ‘Oracle BI Analytics Intelligence’ dashboard
  • Publish a ‘BI Publisher’ report created from ‘Free Hand’ SQL
  • Publish a ‘BI Publisher’ report created from ‘BI answers’

Course Outline:

Oracle FLEXCUBE Object Naming Conventions

  • Naming conventions
  • Coding Standards & Processes

Overview of OBIEE

  • Architecture
  • Deployment

Repository basics

  • Repository Structure, Features, and Functions
  • Using the Oracle BI Administration Tool
  • Creating a repository
  • Loading a Repository into Oracle BI Server Memory
  • Importing Data Sources
  • Setting up Connection Pool Properties
  • Building the Business Model and Mapping Layer of a Repository
  • Building the Presentation Layer of a Repository

OBIEE Analytics

  • Launching and Accessing Answers
  • Subject area
  • Query
  • prompt
  • Filters
  • Functions
  • Folders
  • Viewing the SQL Query involved in the report

Creating Oracle Business Intelligence Interactive Dashboards

  • Introduction to Interactive Dashboards and Pages
  • Dashboard Editor UI Elements
  • Composing Dashboard Elements
  • Creating and Managing Catalogs

GDP reports

  • BIP Reports Overview
  • BIP admin features
  • JDBC Connection
  • User / role creation

BI Publisher reporting features

  • Building a BI Publisher Report Using SQL Queries
  • Template design
  • Parameter prompts
  • Building a BI Publisher Report Based on Analytics Request

Canned reports

  • Setting up and Configuring Canned Reports.