Course Content
Datawarehouse Concepts  
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
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’
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
Bi Publisher
High level Design  Low Level Design
Unit Testing
Real time Scenarios’

No comments:

Post a Comment

Popular Posts