Data Warehouse Development Process

  • Hi,

    I am trying to create a simple yet robust development lifecycle for my organization. I do not want to create unnecessary artifacts and steps.

    Has anyone created a simple yet effective lifecycle with the corresponding artifacts?

    I have thought of something like this:

    Pre-requisites

    -----------------------

    - ETL Framework & Templates

    - ETL Standards

    - DW Standards (SQL, Oracle etc)

    - Source Code Control Standards

    Requirements Gathering

    -----------------------

    - Data Requirements

    - Sources of Data

    - Subject Area/Business Processes

    Requirements Analysis and Design

    ---------------------------------

    - Bus Matrix

    - Test Scenarios

    - Data Contract (Establish Interface requirement)

    - Business Rules

    - Transformation Rules

    - Solution Design

    Data Modelling

    -----------------------

    - Conceptual Model

    - Logical Model

    - Physical Model

    - Detail Data Design

    - Data Dictionary

    ETL

    ------------------------

    - ETL Specification

    - Source to Target Mapping

    Development

    -------------------------

    - DW Objects

    - ETL Packages

    - Load Data (Execute Packages)

    - Unit Test

    - Code Walkthrough (Peer Reviews)

    - Scheduing (Enterprise Scheduling Tool)

    Testing

    ------------------------

    - UAT

    - Test Cases

    - User Guide

    Implementation

    -------------------------

    - Release Register

    - Source Safe

    - Implementation Manual

  • One of my all time favorites (because it uses a football analogy):

    http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/booksdwlt2/

    Collapse whatever is too detailed. Also, Larissa Moss and Laura Reeves are two of the all time greatest BI/DW project managers. Check out some of their stuff too.

  • It would be nice if I told you where to go! Chapter 2: Project Plan List 🙂

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply