Wipro primarily helped the client in assessing the current data warehouse architecture, preparing a roadmap for an EDW and implementing the same using our Global Delivery Model (GDM).

The consultants from Wipro analyzed the existing systems and benchmarked them with the best in-class industry implementations. The study focused on customer’s business issues, information needs, architecture strategy and key processes involved. Wipro provided the client with an assessment findings report that highlighted the gaps which need to be addressed for a successful data warehouse program. The assessment study was complemented by our architecture principles and best practice sessions with the client. Based on the assessment, the Wipro team prepared a roadmap for implementation of enterprise-wide data warehouse. The recommendations included long-term future state data warehouse architecture and approach as well as short-term ‘quick win’ initiatives.

The second part of the engagement involved designing an enterprise-wide data warehouse that can integrate data from various existing operational sources. The engagement with Wipro helped the client to choose an appropriate ETL tool out of the various options available in the market. The data warehouse can accommodate 7 years of historic data and the design is flexible enough to accommodate future requirements. The design also ensures availability of integrated data and retrieves current day sales data.