Home Business Analyst Training and Coaching Data Warehouse Requirements Analysis

What can IAG do for you

Watch this short video to see what IAG Consulting can do for your organization.

 

Not already a member? Register now for access to our Free Premium Content

How May We Help You?

Contact us to discuss how we can help your organization. Call 1 800 209 3616 toll-free or send us an email.

Join IAG

Join the elite team of IAG Consultants. IAG hires the top consultants in the Business Systems Analysis field. If you consider yourself to be one of the best, contact us and let’s talk.

IAG Consultants were among the 23 Founding Members of the International Institute of Business Analysis.
Data Warehouse Requirements Analysis Print E-mail

 

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 Datawarehouse requirements. This course teaches proven and practical techniques – which can be easily applied to your DW projects – to gather and prepare quality specifications for Datawarehouses, Data Marts and Decision Support Systems.

Name "Data Warehouse Requirements Analysis" (DWRA)
Duration Two (2) days
Type Instructor-led
Target Business Analysts, Business Systems Analysts, Project Leads
Rating 4+ stars
Purpose To learn and apply practical techniques for eliciting requirements for Data Warehouse and BI projects
Pre-req none

 

Course Content:

  • 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

 

Learning Objectives:

  • 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