OBIEE ONLINE TRAINING
|
Obiee
Course Content
|
||||||
|
Data warehouse Concepts
|
||||||
|
|
DATA AND TYPES OF DATA
|
|||||
|
OLTP (ONLINE TRANSACTION PROCESSING)
|
||||||
|
OLAP(Online Analytical Processing)
|
||||||
|
difference between OLAP and OLTP
|
||||||
|
Data warehouse
|
||||||
|
Data Mart
|
||||||
|
Basics of Data Warehousing
|
||||||
|
Dimensional Modeling Overview
|
||||||
|
Types of Tables
|
||||||
|
Dimensional table
|
||||||
|
FactTable
|
||||||
|
Aggregate Table
|
||||||
|
Difference between Fact and Dimension Tables
|
||||||
|
Difference between Fact and Aggregate
Table
|
||||||
|
Schema and Types of Schema
|
||||||
|
StarSchema
|
||||||
|
Snowflake Schema
|
||||||
|
Mixed or Fact Contellation
|
||||||
|
Difference between Starand SnowFake
Schema
|
||||||
|
Types of Facts
|
||||||
|
Types of Fact Tables
|
||||||
|
Types of Dimensions
|
||||||
|
Factless Fact Table
|
||||||
|
Level of Granularity
|
||||||
|
Grain
|
||||||
|
SCD TYPE'S
|
||||||
|
|
||||||
|
OBIEE Overview
|
||||||
|
|
Introduction to Nquire
|
|||||
|
Introduction to Siebel Analytics
|
||||||
|
Introduction to OBIEE 10 G
|
||||||
|
Introduction to OBIEE
11 G
|
||||||
|
What is Obiee?
|
||||||
|
End to End Life Cycle of Obiee
|
||||||
|
Advantages of Obiee
|
||||||
|
End to End Life Cycle of Obiee
|
||||||
|
Types of Reports
|
||||||
|
Types of Applications
|
||||||
|
Components OF Obiee
|
||||||
|
Client Components Of Obiee
|
||||||
|
Types of Servers
|
||||||
|
Obiee Architecture
|
||||||
|
Difference between Obiee 10g and Siebel
Analytics
|
||||||
|
Difference between Obiee 10g and
Obiee 11g
|
||||||
|
Obiee11.1.1.7 new features
|
||||||
|
Repository Basics
|
||||||
|
|
What is Meta data?
|
|||||
|
Creating a Repository using BI
Administration Tool
|
||||||
|
Physical, Business Model Mapping, and
presentation layers
|
||||||
|
Properties of repository objects
|
||||||
|
Online Mode and Offline Mode
|
||||||
|
Physical Layer
|
||||||
|
|
Physical
Layer from Relational Data Sources
|
|||||
|
Database
Objects
|
||||||
|
Properties
of Connection Pools
|
||||||
|
Physical
Tables
|
||||||
|
Alias
Tables
|
||||||
|
Physical
Layer Folders
|
||||||
|
Physical Joins
|
||||||
|
Complex
Joins
|
||||||
|
Defining Physical Foreign Keys and
Joins
|
||||||
|
Viewing Data in Physical Tables or
Columns
|
||||||
|
Creating and Editing a Column in a
Physical Table
|
||||||
|
Fragmented Data
|
||||||
|
Primary Key and Foreign Key
Relationships
|
||||||
|
Opaque Views
|
||||||
|
Business Model and Mapping Layer
|
||||||
|
|
Business Model Objects
|
|||||
|
Duplicate Business Model and
Presentation Catalog
|
||||||
|
Logical Tables
|
||||||
|
Logical Columns
|
||||||
|
Logical Table Sources (Mappings)
|
||||||
|
Dimensions and Hierarchical Levels
|
||||||
|
Unbalanced (Ragged) and Skip-Level
Hierarchies
|
||||||
|
Parent-Child Hierarchies
|
||||||
|
Subject Areas for Logical Stars and
Snowflakes
|
||||||
|
Display Folders
|
||||||
|
Logical Joins
|
||||||
|
Level Based Measures
|
||||||
|
Aggregation Navigation
|
||||||
|
Time Series Function
|
||||||
|
Fragmented Content,Where
Cluase,Logical Levels
|
||||||
|
|
||||||
|
Presentation Layer
|
||||||
|
|
About the Presentation Layer
|
|||||
|
Subject Areas
|
||||||
|
Presentation Tables and Columns
|
||||||
|
Presentation Hierarchies and Levels
|
||||||
|
Permissions for Presentation Layer
Objects
|
||||||
|
Creating Aliases (Synonyms) for
Presentation Layer Objects
|
||||||
|
Implicit Fact Column
|
|
|
|
|||
|
Nested Folders
|
||||||
|
Controlling Presentation Object
Visibility
|
||||||
|
|
||||||
|
Config Files
|
||||||
|
|
Nqs Config
|
|||||
|
Nqs Server
|
||||||
|
Nqs Query
|
||||||
|
Instance Config
|
||||||
|
|
||||||
|
Variables
|
||||||
|
|
Variable
|
|||||
|
Repository
Variables
|
||||||
|
Static
and Dynamic
|
||||||
|
Session
Variables
|
||||||
|
System
and Non System Variables
|
||||||
|
Initialization
Blocks
|
||||||
|
Row
Wise Initialization
|
||||||
|
Presentation Variable
|
||||||
|
Requset Variable
|
||||||
|
Cache
|
||||||
|
|
Restricting tables as non-cacheable
|
|||||
|
Using Cache Manager
|
||||||
|
Inspecting cache reports
|
||||||
|
Purging cache entries
|
||||||
|
Modifying cache parameters and
options
|
||||||
|
|
||||||
|
Variable
|
||||||
|
|
Variable
|
|||||
|
Repository
Variables
|
||||||
|
Static
and Dynamic
|
||||||
|
Session
Variables
|
||||||
|
System
and Non System Variables
|
||||||
|
Initialization
Blocks
|
||||||
|
Row
Wise Initialization
|
||||||
|
|
||||||
|
|
||||||
|
Security
|
||||||
|
|
Authentication
|
|||||
|
Authorization
|
||||||
|
Authorization Types
|
||||||
|
Data level Security
|
||||||
|
Object Level Security
|
||||||
|
Authentication Types
|
||||||
|
LDAP Authentication
|
||||||
|
External Table Authentication
|
||||||
|
Application Roles
|
||||||
|
Users and Groups
|
||||||
|
|
||||||
|
Analysis
|
||||||
|
|
Types of Views
|
|||||
|
Column Properties
|
||||||
|
Filters
|
||||||
|
Manage Session
|
||||||
|
Advanced Tab
|
||||||
|
Actions and Conditions
|
||||||
|
Scorecards , KPI ,KPI Watchlist
|
||||||
|
|
||||||
|
|
||||||
|
Prompts
|
||||||
|
:
|
Inline and Dashboard Prompts
|
|||||
|
Column Prompt
|
||||||
|
Image Prompt
|
||||||
|
Image Prompt
|
||||||
|
Currency Prompt
|
||||||
|
Variable Prompt
|
||||||
|
|
||||||
|
Presentation Catalog
|
||||||
|
|
Maintaining the OracleBI Presentation
Catalog
|
|||||
|
Maintaining security
|
||||||
|
Understanding security inheritance
|
||||||
|
|
||||||
|
|
Using Oracle Business Intelligence
Delivers
|
|||||
|
Building alerts
|
||||||
|
Building Agents
|
||||||
|
Introduction to OracleBI
Scheduler
|
||||||
|
|
||||||
|
MUDE(Multiuser
Development Environment)
|
||||||
|
Catalog
manager
|
||||||
|
Moving
from development to Test to Production
|
||||||
|
Other
Feature we provide:
|
||||||
|
FAQS
|
||||||
|
Real-time Repositories
|
||||||
|
Concentration on performance tuning
|
||||||
|
Real time scenarios
|
||||||
|
Certification guidance
|
||||||
|
Resume preparation
|
||||||
|
Sample resumes
|
||||||
|
Interview & certification FAQS
|
||||||
|
How to face the interview
|
||||||
|
Class notes which is useful for who
is trying for job
|
||||||
|
Project preparation
|
||||||
|
|
||||||
0 comments: