CHAPTER 20

image

Estimating ETL Projects

Out of the various duties assigned to the ETL project manager or architect, one of the most critical is the establishment of a project estimate. When considering a new project of any type, executives, managers, and other decision makers will ask first, “How long will it take?” Appropriately setting time frame expectations is critical to the success of the project.

In this chapter, I’ll discuss the challenges and the various components of effective project estimation. Although I won’t define a silver-bullet formula here, you should walk away with some things to keep in mind when constructing estimates for level ...

Get SQL Server 2012 Integration Services Design Patterns now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.