OBIEE/ SIEBEL- ANALYTICS

Oracle Business Intelligence 10.x	
Introduction to Business Intelligence 	
	What is Business Intelligence
	Where BI tools are Used
	Why the  Oracle Business Intelligence
	Advantages
	Architecture, Components
	Client - Answers, Delivers, Dashboards and Web administration,
	Server- Oracle BI server, Presentation, Scheduler 
Server Architecture	
Repository Basics	
	Physical, Business Model and Mapping, and presentation layers
	Properties of repository objects
Building physical layer of a repository	
	Objects of repository
	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
Testing and validating Repository	Building presentation layers of repository
	Checking repository consistency
	Checking Global Consistency
	Inspecting Oracle Answers inspecting SQL
Adding multiple sources to dimension	
	De-normalizing tables structures in database design
	Adding multiple sources to existing logical tables sources
	Adding second table sources
Adding calculations to fact	
	Calculation measures, new calculation measures
	Calculation measures on the basis of physical and logical columns
	Using Calculation wizard
Creating dimensional hierarchies and level based measures	
	Creating dimensional hierarchy
	Use level based measures 
	Create Rank and Share measures
Using partition or fragments	
	Identifying reasons to segment data
	Techniques to model partitions 
	Value based partitioning
Using variables	
	Presentation Variables
	Repository variables
	Session variables
	Initialization Blocks
Using aggregation	
	Importing Aggregated Tables into Repository
	Modeling aggregate tables to speed processing
Merging Repository	Merging Repository
Overview on Multiuser Environment (MUD)	Overview on Multiuser Environment (MUD)
Modeling time series data	
	Types of SCDS
	Technique & solutions to slowly changing dimensions
Modeling extension tables	
	Purposes of extension tables and modeling extension tables
Security	
	About security measures
	Creating users and User groups, assigning of permissions etc
Cache management	
	Purge cache and event handling tables
	Making the table cacheable
	Setting of cache in NQSCONFIG.INI file
Application implementation security	
	Security at object and data levels
Application Development/Report Designing	
Working with Oracle answers	
	Building Busines Requests using answers
	Write back feature
	Adding filters to Business requests
	Views and charts in requests
Creating Oracle Intelligence Dashboards	
	Per-configured and personalized views, dashboard prompts
	Configuring guided navigation links 
	Guided navigation link, using links
	Conditional links and conditional section
Administering Applications	
	Using catalog management to maintain web catalog	
	security creating group, issuing privileges etc	
Using Oracle Delivers		
	Configuring delivery devices	
	Add delivery profiles	
	Build Oracle alerts	
	Create ibots	
	Configuring Oracle scheduler database	
	Configuring of Event poll tables	
Overview of Advanced Topics		
	BI Applications/ Pre-Built RPO	
	ETL Integration
	BI Publisher