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

So the decision is to build/develop some kind of BI model, let’s assume it’s Sales model. How do you begin? Where do you go? What? Where? How!? Well, as I mentioned in previous posts you should know the business. After you learned it, start to interview your main users, I usually start with the “field” personal. First, those people usually knows best the processes, all the tricks and always can refer you to those unique information sources that you will need. Cherish those

Congratulations!!! So you are starting a BI project, or doing some analysis or looking for patterns. You may receive a Specification Document or after a couple of interviews with your customers/users (there will be a separate post on how to interview your future users and how to write a specification Document) you wrote a requirement document or perhaps you were asked a question that required some data mining or analysis. The most important thing is to start getting to know t

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