Jan 31 路 10 min read 路 Why your "Sales by Region" keeps lying to you If a "simple" KPI like Sales by Region keeps changing every time someone moves house or changes team, that's not your dashboard being flaky. That's your data model telling you it only remembers the latest...
Join discussion
Dec 3, 2025 路 2 min read 路 Slowly Changing Dimensions (SCD) Type-2 is the go-to pattern when you need full historical tracking of your dimensional tables. But running a na茂ve column-by-column comparison becomes messy fast. A much cleaner way? 馃憠 Create an MD5 hash of all busin...
Join discussion
Feb 21, 2025 路 5 min read 路 In this blog, I will walk you through a straightforward approach to implementing Slowly Changing Dimension (SCD) Type 2 using Spark SQL and Delta Tables. This method ensures atomicity and maintains the history of records effectively. Introduction to ...
Join discussion