Data Warehouse Requirements Analysis
Overview
This two-day seminar covers specific modeling and analysis techniques that focus on how to develop complete, and clear specifications with, and for, your Data Warehouse clients. Learn project-saving techniques unique to specifying Data warehouse requirements. This course teaches proven and practical techniques – which can be easily applied to your DW projects – to gather and prepare quality specifications for Data warehouses, Data Marts and Decision Support Systems.
Type
Instructor-Led
Target
Business Analysts, Business Systems Analysts, Project Leads
Pre-requisite
None
Duration
2 days
Credits
14 PDU’s/CDU’s
Popularity
4 Stars
Rate
Call for pricing
Dates
Call to schedule
Purpose
To learn and apply practical techniques for eliciting requirements for Data Warehouse and BI projects
- Data Warehouse Best Practices
- Determining the Data Warehouse Project Objectives and Scope
- Identifying Informational Requirements for the Data Warehouse
- Defining the Metadata Model & Data Transformation Rules
- Conducting the Data Warehouse Requirements Discovery Session
- Identify & document the information requirements of a data warehouse so that it is meaningful to the key business and systems users
- Identify & document the information so that it is organized by subject area, usage & data
- Perform dimension modeling and learn how to deal with slowly changing dimensions
- Establish granularity, metrics & historical storage requirements of fact tables
- Define and describe data transformation rules
- Use a Business-Focused DW Inquiry Process
- Produce Clear, Complete Specification