US IT Solution adopts a hybrid approach that focuses on cost-effective, early delivery of business value by building the data warehouse iteratively. By first defining the target architecture and building towards it incrementally, stovepipe data marts are avoided. The enterprise data warehouse is achieved by adding data marts within this architectural framework. In this way, each data mart delivers both the tactical value and the strategic value of the data warehouse.
Principles and Disciplines
The content and structure of the data warehouse will expand and evolve over time to meet increasing and changing business needs. The key to success lies in starting out with an architected environment that provides a foundation that can be built on to support future growth and expansion.
US IT Solution uses clearly defined architecture principles and reusable components to reduce future development costs and promote integration. Fully documented models of the business and data mart system architecture are built at the conceptual, logical and physical levels. Extract and transformation processes are designed to be modular and reusable. This provides for efficient data acquisition and maintains a detailed set of metadata.
The hybrid approach requires that a longer-term, enterprise vision be kept in mind when designing and building data marts. An enterprise view gives context to the data marts and ensures that they are built with an understanding of how they will evolve into the longer-term vision.
The US IT Solution approach supports the enterprise view with a top-down planning process called business discovery. The goal is to understand the current environment of the client, to obtain the corporate perspective of organizational business needs.
Through interviews and workshops with the client, US IT Solution determines business drivers, goals, performance measures, the types of business analysis to be performed and the information required to support the business analysis. We then align the data warehouse goals with the business goals. This ensures that the data warehouse is targeted directly to clear business need, has a focused audience and a tightly defined scope.