Melody Software consultants can help you evaluate your organization’s readiness to implement a datawarehouse solution. We work with management to identify a high-priority, manageable initial scope, develop justification, and establish a roadmap for subsequent phases. The project deliverable summarizes our findings and specific recommendations.

We interview the key people in your organization – the prospective users, the sponsors of the project and the various stakeholders. Aligning the data warehouse with the business’s requirements is absolutely critical to a successful data warehousing initiative. Any implementation that does not focus on the business is doomed for failure. The business’s requirements impact almost every decision made during the course of a data warehouse implementation.

Our Project Managers and Business Analysts interview key business management and knowledge workers to understand their business objectives, analytic requirements and associated potential business impact, and project success criteria. In addition, we conduct data discovery interviews with IT representatives knowledgeable about the key source systems to ensure that appropriate, feasible boundaries are established early in the process. Finally, we facilitate a session with business and IT management to reach consensus on next steps.

Building upon the Business Requirements Analysis effort, our consultants work closely with key business liaisons and IT professionals to design flexible dimensional models through a series of joint design workshops. The process results in a design specification describing the fact and dimension tables and associated columns, along with valid values, mapping, and required transformations, where appropriate.