﻿{"id":212,"date":"2014-10-10T09:44:17","date_gmt":"2014-10-10T09:44:17","guid":{"rendered":"http:\/\/www.codereview.co\/?page_id=212"},"modified":"2014-10-13T14:04:39","modified_gmt":"2014-10-13T14:04:39","slug":"dimensional-model-design-review","status":"publish","type":"page","link":"http:\/\/www.codereview.co\/index.php\/dimensional-model-design-review\/","title":{"rendered":"Dimensional Model Design Review"},"content":{"rendered":"<p>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&#8217;s dimensional modeling experience by engaging us in an onsite design review.<\/p>\n<p>Typically, a\u00a0CodeReview 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\u00a0CodeReview consultant will facilitate discussion of the client\u2019s modeling questions and issues and provide feedback regarding\u00a0CodeReview&#8217;s review of the dimensional models.<\/p>\n<p>While each client engagement is different, topics may include dimensional modeling best practices,\u00a0CodeReview identified design issues, client identified design issues, tradeoffs of alternative design options, and data warehouse architecture alternatives.<\/p>\n<p>Most clients take detailed notes during the onsite visit and develop written documentation summarizing the key learnings and recommendations resulting from the design review.\u00a0CodeReview will then review and comment on this summary document. Alternately, the\u00a0CodeReview consultant can provide a written summary for an additional fee.<\/p>\n<p>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 \u00a310,000, plus associated travel and living expenses. Reviews outside the\u00a0EU or reviews requiring more than two days onsite can be provided for an additional fee.<\/p>\n<p>Contact us\u00a0to discuss how\u00a0CodeReview can help with a Design Review project.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;s dimensional modeling experience by engaging us in an onsite design review. Typically, a\u00a0CodeReview consultant will make a two day onsite visit. Prior to the onsite [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/pages\/212"}],"collection":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":1,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/pages\/212\/revisions"}],"predecessor-version":[{"id":213,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/pages\/212\/revisions\/213"}],"wp:attachment":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/media?parent=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}