{"id":260,"date":"2023-11-22T11:05:39","date_gmt":"2023-11-22T10:05:39","guid":{"rendered":"https:\/\/bitwise.exposed\/?p=260"},"modified":"2026-03-16T09:38:48","modified_gmt":"2026-03-16T08:38:48","slug":"dimensional-modeling-introduction","status":"publish","type":"post","link":"https:\/\/bitwise.exposed\/index.php\/2023\/11\/22\/dimensional-modeling-introduction\/","title":{"rendered":"Dimensional Modeling Introduction"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Dimensional Modeling is a key componend of designing effective data warehouses. This is an introduction, so the most important topics are only addressed below.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-surface-brand-primary-color\">Traditional transactional systems<\/mark> are not optimized for analytic purposes, leading to the need for a specialized structure like in data warehouses. In contrast Data Warehouses could also be seen as <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-surface-brand-primary-color\">analytical systems<\/mark>. Dimensional Modeling is a design technique that organizes data for easy and efficient querying and reporting. Roughly speaking it&#8217;s a <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-variant-text-accent-color\">more normalized approach<\/mark> commonly used in transactional systems. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This leads us to the <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-surface-brand-primary-color\">concept of <a href=\"https:\/\/bitwise.exposed\/index.php\/2023\/11\/24\/facts-and-dimensions\/\" data-type=\"post\" data-id=\"275\">fact and dimension tables<\/a><\/mark> and the importance of creating <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-surface-brand-primary-color\">star schemas<\/mark> or snowflake schemas to organize tables for <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-variant-text-accent-color\">more simplicity and performance<\/mark>. In this normalizing approach, fact tables containing quantitative data, for performance measures. While dimension tables describing the context of the fact data, resp. measures.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To gain further performance there is also the <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-surface-brand-primary-color\">concept of granularity<\/mark>. There is a leverage by choosing the appropriate level of detail for data stored in the data warehouse or at least in the published symantic layer aligned to the needs of the business useres.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Since I am always a bit petty when using the terms Business Intelligence and Data Science, there is to emphasize the business context. In this context dimensional modeling needs to be aligned with the key business processes of an organization, ensuring that the data warehouse is closely tied to the business&#8217;s analytical needs. As a conclusion, building a data warehouse is <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-variant-text-accent-color\">&#8218;Business Process Dimensional Modeling&#8216;<\/mark>. A tailor-made data model reduced to what is necessary and adaptive to change.<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-border-secondary-color\"><\/mark><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dimensional Modeling is a key componend of designing effective data warehouses. This is an introduction, to the most important topics. <\/p>\n","protected":false},"author":1,"featured_media":265,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-260","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-warehouse"],"_links":{"self":[{"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/posts\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":10,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"predecessor-version":[{"id":294,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/posts\/260\/revisions\/294"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bitwise.exposed\/index.php\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}