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
Dec 2, 2024 路 3 min read 路 Introduction to Slowly Changing Dimensions (SCD) Type 2 Slowly Changing Dimensions (SCD) Type 2 is a data warehousing technique used to track historical changes in dimension data over time. Unlike SCD Type 1, which overwrites old data, Type 2 preserv...
AAruna commented
