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