The Microsoft® Data Warehouse Toolkit: With SQL Server™ 2005 and the Microsoft® Business Intelligence Toolset

Chapter 16. ManagingGrowth

There's no rest for the weary

At this point, unless you plan to include real-time capabilities, you have reached the last step in the Lifecycle. By now, you should have completed the deployment of your first business process dimensional model to great success. The tendency at this point is to feel like you've finished the whole project. We encourage you to celebrate your achievement, and we hate to rain on your parade, but the arrow that goes from the Growth box back to the Project Planning box in Figure 16.1 reminds you that the Lifecycle is an iterative process. You have two major tasks at this point. The first is the obvious extension of the warehouse by adding the next priority business process row in the bus matrix, and by adding new user groups. The second task, now that you've had some success, is to dig in and get the DW/BI system fully woven into the fabric of the organization. This acceptance and integration of the DW/BI system by the business does not happen by accident, and it relies more on political and organizational skills than technical skills.

We start this chapter with a look at how the Lifecycle works as an iterative process and what it means to go back through the Lifecycle for the next implementation round. In particular, we revisit the major sections of the Lifecycle from the perspective of the second and subsequent iterations. Then, we focus on techniques for integrating the DW/BI system into the organization. Most of this effort ...