Institute Address :

B1, 3rd Floor, Eureka Court,
Near Image Hospital, Ameerpet,
Hyderabad, India

Contact Details:

Phone No : 91+7207070872 / 9700446467
Email ID : onlinetrainingfromindia@gmail.com
onlinetraining@onlinetrainingfromindia.com

Online Training Enquiry Form

Security-Code reload security code

OBIEE 10g Online Training in India
Course Duration - 40hrs
OBIEE Online Training Course Content

Data warehousing overview
  • Basics of Data Warehousing
  • What is OLTP and OLAP?
  • Difference between OLTP and OLAP
  • Advantages of OLAP
  • What is Data Marts and ODS?
Dimensional Modeling Overview
  • Introduction to Dimensional Modeling
  • What are Facts and Dimensions?
  • Star schema and Snowflake schema
Introduction to Business Intelligence
  • What is Business Intelligence
  • Where BI tools are Used
  • Why the Oracle Business Intelligence
  • Advantages
  • Architecture, Components
  • Clients - Answers, Delivers, Dashboards and Web administration,
  • Servers- Oracle BI server, Presentation, Scheduler server
Server Architecture

Repository Basics

  • What is Meta data?
  • Creating a Repository using BI Administration Tool
  • Physical, Business Model and Mapping, and presentation layers
  • Properties of repository objects

Building Physical Layer of a Repository

  • Objects of Physical Layer
  •  DSN for a data sources
  • Build physical layer

Building business Model mapping layer

  • Objects of BMM layer
  • Building Business model (creating logical tables, columns, joins)
  • Creating simple measures

Building presentation layer

  • Objects of presentation layer
  • Properties of the presentation layer
  • Build presentation layer

Testing and validating Repository

  • Checking repository consistency
  • Checking Global Consistency
  • Inspecting Oracle Answers inspecting SQL
  • Inspecting log files(Nqquery.log,NQSserver.log)

Adding multiple sources to dimension

  • De-normalizing tables structures in database design
  • Adding multiple sources to existing logical tables source
  •  Adding second table sources

Adding calculations to fact

  • Calculation measures on the basis of physical and logical columns
  •  Using Calculation wizard

Creating dimensional hierarchies and level based measures

  • Creating dimensional hierarchies
  • Use level based measures
  • Create Rank and Share measures

Using aggregation

  • Importing Aggregated Tables into Repository
  • Modeling aggregate tables to speed processing
Using variables
  • Presentation Variables
  • Repository variables
  •  Session variables
  • Initialization Blocks

Multiuser Environment (MUD)

  • Overview on Multiuser Environment (MUD)
  • How to create projects in MUD
  • Checkout and checkin of projects
Modeling time series data
  • Types of SCDS
  • Using of time series functions

Modeling extension tables

  • Purposes of extension tables
  • Modeling extension tables for fact and dimensions

Oracle BI Security

  • Security at object and data level
  • Creating users and User groups
  • Assigning permissions to users
  • Setting Query limits and timing restrictions
  • Authenticating using an external database

 Cache management

  • Purge cache and event handling tables
  • Making the table cacheable
  • Setting of cache in NQSCONFIG.INI file

Oracle BI Presentation services

Working with Oracle BI Answers

  • Building Busines Requests usiing Answers
  •  Adding filters to Business requests
  • Adding Column Filter Prompts in Answers
  • Views and charts in requests

Creating Oracle Intelligence Dashboards

  • Creating dashboard pages using report requests
  • Creating dashboard prompts
  • Configuring guided navigation links
  • Adding content to dashboard
  • Conditional links and conditional section

Administering OBI Presentation Catalog

  • Using catalog management to maintain web catalog
  • Creating catalog groups, issuing privileges etc
Online Training