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 DecisionWorks’ decades of dimensional modeling experience by engaging us in an onsite design review.
Typically, a DecisionWorks 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 DecisionWorks consultant will facilitate discussion of the client’s modeling questions and issues and provide feedback regarding DecisionWorks’ review of the dimensional models.
While each client engagement is different, topics may include dimensional modeling best practices, DecisionWorks-identified design issues, client-identified design issues, and trade-offs of alternative design options.
Most clients take detailed notes during the onsite visit and develop written documentation summarizing the key learnings and recommendations resulting from the design review. DecisionWorks will then review and comment on this summary document. Alternately, the DecisionWorks 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 $11,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.