Project Mgmt for a DW Projects

View previous topic View next topic Go down

Project Mgmt for a DW Projects

Post  thekaps on Thu Aug 19, 2010 1:50 pm

I would like to start a discussion on how Project Mgmt for a DW is different from other projects. Ill start;
I feel that the design phase is longer and the coding phase is shorter than other projects. Agree/Disagree?

thekaps

Posts : 2
Join date : 2010-07-12

View user profile

Back to top Go down

Re: Project Mgmt for a DW Projects

Post  ian.coetzer on Mon Aug 30, 2010 5:30 am

Hi,
I'm starting with a BI project for a subject matter area called: Credit Risk.
And so far I have spent far more time documenting and discussing the requirements, ETL will also be a lot of work but a tad less time will be spent on it.
(That is what I foresee ...)

My approach so far has been to create a strategy document (with an embedded excel workbook) to 'explain' BI and the approach we will follow with a document matrix.

The templates that I have started to create and populate is:

1. Business case assessment
2. Technical Infrastructure Report
3. Non-Technical Infrastructure Report
4. Project Charter
5. Project Plan
6. Requirements analysis
7. Database design
8. ETL Design
9. Meta Data Repository

these may change but this is all a separate physical document and so far it is a bit different from a standard SDLC approach.
avatar
ian.coetzer

Posts : 57
Join date : 2010-05-31
Age : 36
Location : South Africa

View user profile

Back to top Go down

Re: Project Mgmt for a DW Projects

Post  ngalemmo on Mon Aug 30, 2010 1:02 pm

In general, the bulk of the work in developing a data warehouse is specification, documentation and testing. If done right, the modelling and ETL stuff goes real quick. If the project includes developing a BI layer from scratch, this can also be time consuming, but it is fairly easy to coordinate this work... tool installation and configuration early on, metadata development once the data model is complete, and report development as test data becomes available.

A common problem I have seen in staffing DW development is the tendancy to understaff the ETL specification portion and overstaff ETL development. To make things worse, often these efforts are scheduled to start at the same time.

Developing ETL specs (source to target mappings) takes a lot of time and requires coordination between the ETL architect and the subject matter experts on the business side. While this is going on, the ETL developers are sitting on their hands waiting for something to do. It is usually best to stagger the initiation of specification by a few weeks before coding to allow a queue of specifications to build up. Once coding begins, the ETL architect needs to split his/her time between completing the remaining specifications and handling questions from the ETL developers.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Project Mgmt for a DW Projects

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum