No.1 obiee 11g training institute at marathalli

No.1 obiee 11g training institute at marathalli Bangalore

·         Specially
Designed Course Material

·         Tailor-made
Course Curriculum

·         Domain
Experts as Faculty

·         State-of-the-art
Infrastructure

·         Industry
Experts as Trainers

·         Affordable
Fee Structure

·         Industry-centric
Approach

OBIEE TRAINING COURSE CONTENT

OBIEE –SIEBEL ANALYTICS

Course Content
Data warehouse Concepts 
data warehouse
Olap(Online Analytical Processing)
Oltp(Online Transaction Processing)

Dimensional Modeling
Dimensional table
Fact table
Aggregate table
Star schema
Snowflake schema
Star schema Vs Snowflake schema
Types of Facts
Types of Fact tables
Types of Dimensions
level of Granularity
Grain of fact


Introduction to Siebel Analytics/OBIEE

Advantages
Obiee Architecture
Obiee Client Components
Types of Reports
Types of Applications
Repository Basics:-
Building Physical Layer of a Repository
Objects of Repository
DSN for Data Source
Build Physical Layer
Building Business Model and Mapping layer
Object 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 Layers
Building Presentation Layers in repository
Testing and validating Repository
Checking repository consistency
Checking Global Consistency
Adding Multiple Sources to dimension
De-normalizing tables structures in databases 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 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 Aggregation
Importing aggregated tables into repository
Modeling aggregate tables to speed processing
Using partition or fragments
Identifying reason to segment data
Techniques to model partitions
Value based partitioning
Using Variables
Repository Variables
Session Variables
Initializations blocks
Modeling time series data
Time Comparision for business analytics
Time series wizard
Modeling extension tables
Purpose of extension tables and modeling extension tables’
Security
About Security measures
Creating users and user group 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
Responsibilities,positions and organizations to restrict user access
Application Development/Report Designing
Working with Answers
Building analytics requests using answers
Applying filters to analytics requests
Views and charts in requests
Creating intelligence dashboards
Per configured and personalized views, dashboards prompts
Configuring guided navigation links
Giude navigation link using links
Conditional links and conditional section
Administrating Siebel analytics applications
Using catalog management to maintain analytics web catalog
Analytics security creating group, issuing privileges etc
Using Siebel delivers
Configuring delivery devices
Add delivery profiles
Build analytics alerts
Creating ibots
Configuring analytics scheduler database

Unit Testing
Real time Scenarios