Courses


Siebel

Course : SIEBEL Duration : 35 Hrs
Course Content : 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
copyright © 2010 eworldclasses.com All Rights Reserved