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