top of page

Ideas for Modern Data Teams
This blog is where we share what's working (and what's not) across modern data architecture, data engineering, and business intelligence.
You'll find:
-
Practical tips and examples from real-world projects
-
Tools we actually use
-
Opinions and insights from our team
-
Updates from our products and community

Search
All Posts


What Your Warehouse Doesn't Know About Deleted Records Could Be a Compliance Risk
Data warehouses are built to integrate information from multiple source systems. But integration creates a specific kind of blind spot: your warehouse may know a record exists, but does it know what state that record is in across every system currently holding it? That question matters more than most data leaders realize, and the answer has direct implications for compliance, governance, and operational risk. The hidden complexity of the same record in five places A customer
Oct 53 min read
Blame the process, not the person
The one secret I have just watched Jake Humphrey's interview with Toto Wolff and I can't stop thinking about it. Jake asked Toto for his one secret, and he said the answer rearranged how he thinks about failure. It has done the same for me. Toto's answer was simple: "At Mercedes, we blame the process. Not the person." Every single time Jake pushed him on it. Every single time? Toto said yes. So Jake pushed again. What if it genuinely is one person's mistake? I'm going to use
Oct 24 min read


Build the Data Foundation First, Then Let AI In
Every client conversation I have at the moment gets round to AI within about ten minutes. Copilots, agents, chat over their documents, predicting which customers are about to leave. The appetite is there and I think that's a great thing. The bit that doesn't get talked about enough is what sits underneath. An AI model is only as good as the data you give it, and most of the organizations have their data spread across a CRM, a finance system, a pile of spreadsheets and a data
Sep 305 min read


Data Contracts: The Discipline That Stops Bad Data Before It Becomes Your Problem
Every organization that moves data between systems has experienced the same failure: something breaks downstream, and by the time anyone notices, the problem has already propagated through multiple processes. You trace it back and find that a source system changed its structure without warning — a column removed, a format altered, a field shifted — and your pipeline absorbed that change silently until the damage was done. Data contracts exist to prevent exactly that, and they
Jul 94 min read


XML in Your Data Warehouse: What to Expect and How to Handle It
At some point in your data platform journey, you will encounter XML. It may not be your team's first choice, and it almost certainly will not be your engineers' preferred format to work with. But it exists in legacy source systems across industries, and for many organizations it arrives as a non-negotiable part of the data landscape. The question is not whether to deal with it — it is how to deal with it well, and how to recognize when the real problem is not the format at al
Jul 75 min read


Getting Data Into Your Warehouse Is Harder Than It Looks. Here's How to Do It Right
Most conversations about data warehousing focus on what happens once the data is inside the platform: transformation, modeling, reporting, AI readiness. What gets far less attention is the step that makes all of that possible in the first place — getting data from your source systems into the warehouse at all. That process, which practitioners call data landing, is where many organizations quietly struggle. The technical complexity is real, but so is the organizational comple
Jul 25 min read


Why Your Data Platform Needs a Strategy for JSON
Semi-structured data is no longer a niche engineering concern. It is arriving at the heart of your data platform every day, and the decisions your teams make about how to handle it will determine how agile, resilient, and trustworthy your data infrastructure becomes over the next few years. The rise of JSON — the most common format for this kind of data — is not a coincidence. Two structural shifts in modern software have driven it. First, organisations have moved to API-firs
Jun 305 min read


How To Start A Data Model
For many data professionals, the hardest part of data modeling is not the technical work. It’s getting started . You sit down with a blank sheet of paper and a request to “produce a data model.” At that moment, the challenge is figuring out where to begin. In a recent Business Thinking Podcast discussion, we explored a practical approach to starting a data model from scratch—especially when working with Data Vault . The goal is not to produce a perfect model immediately. The
Mar 264 min read


When Is The Right Time To Use Data Vault?
Organizations often hear about Data Vault as a modern approach to building data warehouses. But adopting it at the wrong time can lead to disappointing results. The real question is not whether Data Vault is good or bad. The question is whether the organization is ready for it . In this article, we look at the conditions that need to be in place before a Data Vault initiative can succeed. These insights come directly from a discussion on the Business Thinking Podcast about w
Mar 244 min read


When Is Data Vault Not The Right Option?
Modern organizations are investing heavily in data platforms. One approach that often appears in these conversations is Data Vault . Data Vault has gained strong adoption across enterprises because it helps organizations integrate large volumes of data from multiple systems while maintaining historical accuracy and auditability. However, like any architectural method, Data Vault is not always the right solution . Understanding when it works—and when it doesn’t—is critical for
Mar 195 min read


You bought the business. Now fix the numbers
You have just completed an acquisition. Due diligence is finished. You tested the numbers, challenged assumptions, and committed capital based on a clear investment thesis. Your first actions are structural. You reshape parts of the organization. You align resources to strategic priorities. You appoint key managers. These steps reduce cost, clarify accountability, and inject new energy into the business. They stabilize the platform. But they do not yet build value. The next
Mar 165 min read


Is Data Modeling Still Relevant?
Many organizations are investing heavily in data platforms, analytics tools, and AI initiatives. Yet one foundational discipline often gets overlooked: data modeling . In recent years, some teams have questioned whether data modeling is still necessary. Modern data stacks emphasize rapid development, code-first workflows, and large-scale processing frameworks. As a result, design practices like conceptual and logical modeling sometimes get pushed aside. That shift creates ris
Mar 164 min read
bottom of page