OBIEE –SIEBEL ANALYTICS
Course Content
Datawarehouse Concepts
datawarehouse
Data mart
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
Why 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 Golbal Comsistency
Adding Muiltiple 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
Calcution Measures new calculation measures
Calculation measures on basis of physical and logical columns
Using Calculation Wizard
Creating Dimentional hierarchies and level based measures
Creating dimentional 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
Technoques 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
Assing 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
Administreting 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
DAC
OBIA
Bi Publisher
High level Design Low Level Design
Unit Testing
Real time Scenarios’
No comments:
Post a Comment