Analytics: Advanced Data Warehouse Developer - LVC


What you will learn
The required pre-requisites for this course are:
Analytics: Overview (Siebel 7.7)
Analytics: Data Warehouse Developer (Siebel 7.7)

This course is part of a comprehensive training program intended for members of Siebel Analytics implementation teams. The goal of the program is to enable participants to perform the tasks required to successfully complete a Siebel Analytics deployment.

This course is one of three advanced role-based Analytics courses. This course provides advanced training in topics related to the tasks performed by an Analytics Data Warehouse Developer. It is intended for individuals on the implementation team whose major role is to configure, customize, and administer the Siebel Relationship Management Warehouse (SRMW), Informatica, and Data Warehouse Application Console (DAC) for Siebel Analytics. This course provides instructor-led training on advanced topics and concepts beyond those covered in the base course, Analytics: Data Warehouse Developer (Siebel 7.7).

The course presents material in five sections. In the SRMW Configuration section, students learn advanced SRMW configuration concepts, including advanced change capture concepts, change capture deletes, auxiliary change capture process, and slowly changing dimensions. In the DAC Configuration section, students learn advanced DAC configuration topics, including populating a custom set of date dimension values, using command line option to access the DAC server, and configuring ETL to selectively refresh the SRMW. In the ETL Migration section, students explore the processes used to migrate Informatica mappings and workflows, Informatica repository, and DAC repository. In the Siebel Analytics Applications Upgrade section, students learn about the various bridge applications that are available to provide compatibility between different versions of Siebel Analytics Applications and Siebel CRM applications. In the Performance Tuning section, students learn to employ best practices for configuring SRMW.

This course is appropriate for Analytics 7.7 and 7.8.

Live Virtual Class (LVC) Access Policy:

  • You are prohibited from allowing other unregistered individuals to view your LVC Event
  • You may not make unauthorized recordings, copies or transmissions of LVC Event content
  • You must view the LVC Event from the country listed in your LVC Event registration

Students attending LVC events should enroll at least two working days in advance of the event to ensure adequate time to download student materials and confirm their system setup. To learn more about the system and setup requirements for participating in a Live Virtual Class, please click here.



Audience
Functional Implementer
Technical Consultant

Prerequisites
Analytics: Overview (Siebel 7.7)
Analytics: Data Warehouse Developer (Siebel 7.7)

Course Objectives
To enable students to apply advanced techniques when configuring, customizing, and administering Siebel SRMW, Informatica, and DAC for Siebel Analytics


Course Topics

Exploring the Change Capture Process

Capturing and Applying Deletes

Building Auxiliary Change Capture

Building Slowly Changing Dimensions

Using Command Line to Access the DAC Server

Populating a Custom Set of Date Dimension Values

Configuring ETL to Selectively Refresh the SRMW

Migrating ETL Mappings and Workflows

Migrating Informatica Repository

Migrating DAC Repository

Reviewing the Siebel Analytics Bridge Applications

Employing Best Practices for Configuring the SRMW

Configuring the SRMW for Global Deployments


Related Courses
Analytics: Advanced Application Developer
Analytics: Advanced Server Architect
Analytics: Application Developer (Siebel 7.7)
Analytics: Overview (Siebel 7.7)
Analytics: Server Architect (Siebel 7.7)
Analytics: Data Warehouse Developer (Siebel 7.7)