Siebel: Analytics: Data Warehouse Developer (Siebel 7.7)

Course Overview

Analytics: Overview (Siebel 7.7) is the required pre-requisite for this course.

The goal is to enable participants to perform the tasks required to successfully complete a Siebel Business Analytics deployment.

This course is designed for those individuals on the implementation team who are responsible for extracting, transforming, and loading data from Siebel applications and other data sources into the Siebel Relationship Management Warehouse. The course teaches students about the architecture and contents of the Siebel Relationship Management Warehouse. Students learn about the different methods used to modify the Siebel Relationship Management Warehouse to support specific analytical application requirements, as well as how to weigh performance issues related to the various modifications.

This course offers an in-depth examination of best-practice data warehouse design concepts, covering the tools that are used to extract, transform, and load data from Siebel applications and other data sources into the Siebel Relationship Management Warehouse. Students acquire hands-on experience with Informatica Server, its metadata repository, and the tools used to modify and manage the standard Siebel ETL process, including the Siebel Data Warehouse Administration Console. Students also learn how to improve ETL performance by extracting only a subset of data relevant to specific business needs, and how to customize the Siebel Relationship Management Warehouse by extending the existing schema.

By completing this course, students will gain valuable insight into database design requirements and the trade-offs necessary to mutually support both high-performance analysis, and the loading and extending of the Siebel Relationship Management Warehouse.

This course is appropriate for Analytics 7.7 and 7.8.

Audience

• Functional Implementer
• Technical Consultant

Prerequisites

• • A working knowledge of Informatica PowerMart or PowerCenter and SQL, plus dimensional modeling or data-warehouse design skills
  • Understanding of the underlying architecture of Siebel applications
• Domain experience in business intelligence, data warehouse design, and database design
• Ability to navigate within Siebel application
• Analytics: Overview (Siebel 7.7)NEW

Skills Gained

Enable students to install, design, customize, and configure the Siebel Relationship Management Warehouse, employing recommended methods and practices for successful implementation

Siebel: Analytics: Data Warehouse Developer (Siebel 7.7) / D44740GC10