OBIEE Online Training

Course Duration : 40 Hrs

OBIEE 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