Building a Kimball Data Warehouse


Introduction

I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was pretty cool. With the advent of ‘Big Data’, the various cloud offerings, Big Table, Hadoop, python, Atlas/Atlas SQL, etc., the question arises: is the traditional Data Warehouse (DW) even needed? I noticed that when installing Microsoft SSAS the default for SQL 2022 is now the Tabular data model. So, is the multi-dimensional model even used today?

The traditional, multi-dimensional DW cannot be replaced; it offers data analysis that is unmatched I believe. As I assembled this article, I saw several other writings