Greetings, As I previously mentioned, Snowflake and Star Schema comes often in data warehouses, but what happens when your model contains multiple facts? In Qlik products, there are 2 techniques: Concatenate fact tables Key-Table Concatenate and Key-Tables are ways to resolve synthetic keys, which formulate due to the presence of multiple fact tables, which I know I implement only in the PNL model (which we will mention in the future). Between those 2 techniques, I always wor

Greetings, When we work with ERP/CRM databases or some other transactional system, we meet database that usually normalized and designed for fast writing in it. It is one of the main purposes of that systems, it is being able to write many data/transactions very fast. On the other hand, in BI we are building schema than can be read from it very fast, it is in a highly de-normalized state, which is why the dimensional modeling is very common. The classic schema of dimensional

Hello and welcome My name is Dima Kaptsan and no, I am not a blogger:-). In my career I had many different titles but, I would like to summarize it to one --> a"Data Lover" title. I've been dealing with those materials since 2003 and over those years I have gained some experience in many industries such as: Hi-tech Fashion Food industry Manufacture Services Call centers Agriculture Farms Local government and many more So in this blog I'll try to reflect my knowledge, demonstr