Dimensional Model Design Review

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 CodeReview’s dimensional modeling experience by engaging us in an onsite design review.

Typically, a CodeReview 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 CodeReview consultant will facilitate discussion of the client’s modeling questions and issues and provide feedback regarding CodeReview’s review of the dimensional models.

While each client engagement is different, topics may include dimensional modeling best practices, CodeReview 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. CodeReview will then review and comment on this summary document. Alternately, the CodeReview 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 EU or reviews requiring more than two days onsite can be provided for an additional fee.

Contact us to discuss how CodeReview can help with a Design Review project.