Project Management

Project Management Central

Please login or join to subscribe to this thread

Topics: Estimating
Effort estimation of ETL
Dear all,
I'm starting an estimation exercise for an ETL/Datawarehouse project. Does any of you knows a proven methodology and benchmark information to be able to estimate the overall effort of an ETL project. We have an idea on the number of tables/fields in the source systems, and a (very high-level) idea on the complexity of the different transformations.

Is there any website/document/whitepaper somewhere where an estimation technique is presented ?


Sort By:
You might try the vendors directly as well as the vendor's user group.
Dear Marc, it has been a while, but a few years back I was involved in a similar effort. As part of our vendor RFI, we asked for and received very good ETL estimation guidelines. Are you working with a vendor product already? You might give your vendor or some of the leaders such as Informatica, Ascential, and SAS a quick call and chat. Good luck! -- Mark Perry, VP of Customer Care, BOT International
We work extensively with Datawarehouse projects and have always had some issues with different estimation models that we tried.

Last year we investigated different estimation methodologies, and finally selected CFFP (Cosmic Full function Point) using the Six Sigma (DMADV) techniques, and then successfully adopted it for use organization wide for all over datawarehousing projects.
You may want to check out CFFP for your organisation. In case you want details about how we did it for our organisation you can get in touch with me (
HTH. Sorry right now can not tell you much about my own organisation.

Please login or join to reply

Content ID:

"The man who views the world at 50 the same as he did at 20 has wasted 30 years of his life."

- Muhammad Ali



Vendor Events

See all Vendor Events