• AIPressRoom
  • Posts
  • Knowledge Modeling for Mere Mortals — Half 2: Dimensional Modeling Fundamentals | by Nikola Ilic | Sep, 2023

Knowledge Modeling for Mere Mortals — Half 2: Dimensional Modeling Fundamentals | by Nikola Ilic | Sep, 2023

Introducing a four-step dimensional-modeling design method

Are you aware what’s most likely the perfect information mannequin within the Enterprise Intelligence world? Curious to be taught the 4-step dimensional design course of? This text will give you all the basics of dimensional modeling

Within the previous article, you discovered the final ideas of knowledge modeling. Now, it’s time to slim down our studying journey and grasp information modeling ideas and methods which might be particularly related to enterprise intelligence eventualities. And, each time we’re speaking about information modeling for enterprise intelligence, dimensional modeling is unquestionably the primary idea.

Earlier than we come as much as clarify why dimensional modeling is called like that — dimensional—let’s first take a short tour by some historical past classes. In 1996, a person referred to as Ralph Kimball revealed a ebook, “The Knowledge Warehouse Toolkit,” which remains to be thought-about a dimensional modeling “Bible”. In his ebook, Kimball launched a totally new method to modeling information for analytical workloads, the so-called “bottom-up” method. The main target is on figuring out key enterprise processes inside the group and modeling these first, earlier than introducing further enterprise processes.

Kimball’s method is pretty easy and consists of 4 steps, often known as the “4-Step Dimensional Design course of”. Every step is predicated on a call.

  1. It begins with choosing the enterprise course of. To be constant, let’s use the identical instance as within the earlier article and picture that promoting a ticket for an occasion is the enterprise course of we’re taken with

2. The subsequent step is to declare the grain. Grain? What on Earth is grain? Merely mentioned, that’s the lowest degree of element captured by the enterprise course of. In our instance, the bottom degree of element is the person ticket sale. We are going to come…