OBIEE Training

OBIEE Training is essential to grasp the concepts of self-serve interactive reporting, actionable intelligence and spatial intelligence via map-based visualizations. Its proven architecture delivers enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis which provides a rich end-user experience.

OBIEE Training Curriculum

Introduction to OBIEE

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
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 and 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
Using level based measures
Creating 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
Multi-User Environment (MUD)

Overview on Multi-user Environment (MUD)
How to create projects in MUD
Checkout and check-in of projects
Modeling Time Series Data

Types of SCDS
Using of time series functions
Modeling Extension Tables

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 cache able
Setting of cache in NQSCONFIG.INI file
Oracle BI Presentation Services

Working with Oracle BI Answers
Building Business Requests using 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 Catalogue

Using catalogue management to maintain web catalogue
Creating catalogue groups
Issuing privileges etc.