Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Warehouse Development Process Expand / Collapse
Author
Message
Posted Saturday, April 6, 2013 2:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, September 7, 2014 5:45 PM
Points: 55, Visits: 343
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
Post #1439553
Posted Thursday, April 11, 2013 12:48 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
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.
Post #1441437
Posted Thursday, April 11, 2013 12:50 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
It would be nice if I told you where to go! Chapter 2: Project Plan List
Post #1441439
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse