Siebel Contents

SIEBEL ANALYTICS/OBIEE

Introduction to Siebel Analytics

* Why the Siebel Analytics
* Advantages
* Siebel Analytics architecture
* Client, Analytics servers, Analytics Scheduler, Data sources
* Standalone and application architecture

Server Architecture

Analytics 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 Presentation Layers

* Object of Presentation Layer
* Properties of the presentation layers
* Building Presentation layers repository

Testing and validating repository

* Checking Repository Consistency
* Checking Global Consistency
* Inspecting Siebel 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 Calculations 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 Aggregation

* Importing Aggregated Tables into Repository
* Modeling Aggregate Tables to Speed Processing

Using Variables

* Repository Variables
*

Session Variables
*

Initialization Block

Modeling Time Series data

* Time Comparison for Business analytics
* Time Series Wizard

Modeling Slowly Changing Dimensions

* Types of SCDS
* Technique & Solutions to Slowly Changing Dimensions

Modeling Extension Tables

* Purposes of Extension tables and Modeling extension Tables

Analytics Security

* About Security Measures
* Creating User Groups, Assigning of Permissions etc

Cache Management

* Purge Cache and Event Handling Tables
* Marking the Table Cacheable
* Setting of Cache in NQSCONFIG.INI files

Application Implementation Security

* Security at and event handling tables
* Responsibilities, Positions and Organizations to Restrict User Access

APPLICATION DEVELOPMENT/REPORT DESIGNING

Working with Siebel Analytics answers

* Building Analytics Requests Using answer
* Adding Filters to Analytics Requests
* View ans Charts in Requests

Creating Intelligence Dashboards

* Per-Configured and Personalized views,Dashboard Prompts
* Configured and guided Navigation Links
* Guided Navigation Link, Using Links
* Conditional Links and Conditional Section

Administering Siebel Analytics Aplications

* Using Catalog Management to maintain analytics web catalog
* Analytics security Creating Group, Issuing Privileges etc

Using Siebel Delivers

* Configuring Delivery devices
* Add Delivery Profile
* Build analytics alerts
* Create Ibots
* Configuring analytics Scheduler Database

WAREHOUSING ARCHITECTURE

SRMW content & Installation

* Pre-built schema of SRMW
* Vertical and Horizontal schema
* Types of Tables i.e SCDS, Facts, Dimensions, aggregate etc
* ETL Clients, ETL Servers, ETL Repositories

ETL Process

* Need of ETL
* Sources Depended Extraction Mapping
* Source Independent Loading Mappings

Working with Informatica Power center

* Workflow Designer
* Workflow Manager
* Workflow Monitor
* Informatica Repository Server etc
* Types of Transformations Process
* Mapping, Creation of sources and targets etc

SDE and SIL Mapping

* Source Dependent Extraction Mapping
* Source Independent Loading and Mapping

DAC

* Configuaring Data warehousing Application console
* Execution Plan Subject area, table groups, tables index etc

Population Siebel Relationship Management warehouse

* Role of DAC in Populating SRMW and Monitoring
* Controlling the data to be entered into SRMW
* Optimizing Mappings