Hero Image
Why Your Pipeline Finishes Later Every Month

Let me tell you about a graph that changed how I think about data engineering. A junior engineer on my team — let’s call her Priya — had been tracking something nobody asked her to track. Every morning for two months, she’d noted the timestamp when our main analytics pipeline completed. She wasn’t trying to make a point. She was just curious, because the finance team kept mentioning their dashboards weren’t ready when they arrived at 8 AM anymore.

Saturday, April 18, 2026 Read
Hero Image
Data Modelling Showdown: Kimball vs One Big Table vs Relational

Introduction When architecting a data warehouse, one of the most crucial decisions is choosing the right data modelling approach. Like selecting the right tool for a job, each modelling methodology has its strengths and ideal use cases. Today, we’ll explore three popular approaches: Kimball’s dimensional modelling (star schema), the one big table approach, and traditional relational modelling. The Dataset: Understanding Our Example To illustrate these approaches, let’s consider a retail sales system with these core components:

Saturday, January 25, 2025 Read