Consulting: Data Integration Assessment/Strategy
Most data warehouse projects strive to deliver integrated data which supports decision makers throughout the organization. We suggest you couple the organizational desire, with a proven approach and framework (data warehouse bus architecture) before prematurely jumping to technical solutions.

Whether you’re just getting started or dealing with a dozen existing stand-alone data marts, the Kimball Group will help define an extensible data architecture to ensure integration and consistency. Working with the project team and business stakeholders, we’ll create the data warehouse roadmap, listing the performance measurement data that will be ultimately integrated in warehouse/marts, along with the common linkages (i.e., conformed dimensions). The resulting enterprise data warehouse bus matrix is a critical planning, communication, and development tool.

For organizations that have already built data repositories, we assess the current environment, in conjunction with the target bus matrix, to develop a strategy and implementation plan for bridging from the current state to the ultimate end goal.

If data warehouse teams fail to focus on integration and consistency, their warehouse deliverables will merely provide easier, faster access to inconsistent data. While that may address short-term needs, it likely won’t be resilient over time. We recommend that you establish a data integration strategy as early as possible to minimize downstream rework.

Contact to discuss how Kimball Group can help you with your Integration Strategy.