April 6, 2013 at 2:45 am
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
April 11, 2013 at 12:48 pm
One of my all time favorites (because it uses a football analogy):
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.
April 11, 2013 at 12:50 pm
It would be nice if I told you where to go! Chapter 2: Project Plan List 🙂
May 24, 2023 at 8:19 am
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