Some organizations have already invested a significant effort into gathering requirements and developing a preliminary schema, but require additional guidance before completing and implementing the model. You can leverage the Kimball Group’s decades of dimensional modeling experience by engaging us in an onsite design review.
Typically, a Kimball Group consultant will make a two day onsite visit. Prior to the onsite visit, the consultant will review background documentation such as the project charter and scope, business requirements, and existing schema. In addition, we ask the client to provide a list of questions, issues and/or concerns related to the dimensional data models. During the onsite visit, the Kimball Group consultant will facilitate discussion of the client’s modeling questions and issues and provide feedback regarding Kimball Group’s review of the dimensional models.
While each client engagement is different, topics may include dimensional modeling best practices, Kimball Group identified design issues, client identified design issues, tradeoffs of alternative design options, and data warehouse architecture alternatives.
Most clients take detailed notes during the onsite visit and develop written documentation summarizing the key learnings and recommendations resulting from the design review. Kimball Group will then review and comment on this summary document. Alternately, the Kimball Group consultant can provide a written summary for an additional fee.
A typical design review project consisting of the background materials and existing schema review, the two day onsite session, and review of the written summary document is provided for a fixed bid amount of $10,000, plus associated travel and living expenses. Reviews outside the US or reviews requiring more than two days onsite can be provided for an additional fee.
Contact Bob Becker to discuss how the Kimball Group can help with a Design Review project. If you’re interested in a Design Review based on the Microsoft SQL Server environment, contact either Joy Mundy or Warren Thornthwaite.