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