Experience

Expertise

Excellence

Qual IT Solutions
About Us

Services
Qual IT Institute

Careers
Contact Us

Business Requirements Curriculum

Course Schedule

Course Costs

E-Learning

Other Services

Register

 

 

 

Data Warehouse Requirements Analysis

 

Course Reference: DWRA

Overview

This two-day course teaches participants how to use a business-focused data warehouse inquiry process that will produce a clear and complete specification that is ready to begin designing a data warehouse.

Course Content

Data Warehouse Best Practices

·          Data Warehouse development concepts; Short Development Life-Cycles, Warehouse Evolution, Analysis & Requirements Elicitation Practices

·          Completing analysis quickly, accurately with a business client focus.

·          Ensuring that Data Warehouse Requirements are accurate, complete, clear for all users (Business & Technology) and flexible enough to accommodate changes.

The Business Case Exercise

·          Opportunities to practice the concepts and techniques to conduct an effective Data Warehouse Requirements Analysis.

·          Demonstrations of how these practices work, with real world and sample exercises.

Determining the Data Warehouse Project Objectives and Scope

·          "Business Case" Justification; getting a real return on the Data Warehouse Investment.

·          Aligning with Corporate Objectives.

·          Developing the Warehouse Domain Model.

Identifying Informational Requirements for the Data Warehouse

·          Identifying the Business Questions.

·          Business Fact Modeling; Identifying the Business Facts needed for the Business Questions.

·          Data Sourcing; Locating the Business Facts.

·          Fact Dimensions; determining the way Business Facts will be "sliced and diced".

·          Dimensional Modeling; how to organize and represent the Business Facts and Dimensions used to satisfy the Business Questions.

Business Case Justification

·          Business Case Justification Metrics; How to insure the Data Warehouse will add value.

·          Using the Business Case to establish Data Warehouse development priorities.

Defining Data Transformation Rules

·          System Data vs. Business Knowledge; turning transactional data into Business Intelligence.

·          Who, What, When, Where, How, and How Often?

Conducting the Data Warehouse Inquiry Process (WHIP)

·          Facilitating a Warehouse Requirements gathering session with Business Clients / Knowledge Workers.

·          Producing clear, concise and useable deliverables.

Making it work - for you and your company

 

 

Phone 416-518-3450                                             courses@qualitsolutions.com