Coming next: The Second Factory →

Back to Library
Data Foundations⚠️ Pitfall

The Wild West of Data (When Everyone Does Whatever They Want)

The Problem

Sales has their own definition of "customer." Marketing has a different one. Finance has a third. Three teams, three different numbers for "total customers." Executives get confused. Trust erodes. Every meeting turns into a definitional debate instead of a decision-making session. Or worse: anyone can access any data, PII is flying around in Slack, compliance is a nightmare, and you're one audit away from a massive fine. It's the Wild West—no rules, no standards, no control. It's like a manufacturing plant where every shift uses different specs for the same product. Some batches are perfect, some are disasters, and nobody knows which is which until customers complain.

The Principle

Set clear rules and enforce them. Define metrics once, centrally, and make that the source of truth. Control data access—not everyone needs to see everything. Audit who's accessing what. Document everything. Make governance boring and systematic, like quality control in manufacturing. The magic happens when everyone uses the same definitions, trusts the same numbers, and can actually make decisions instead of arguing about whose spreadsheet is right. Less chaos, more consistency. That's how you build trust in data.

🎯

3 Steps to Take Action

  1. 1

    Define Metrics in One Place: Pick your top 10 metrics. Lock everyone in a room. Agree on ONE definition per metric. Document it. Build it into the data warehouse as the source of truth.

  2. 2

    Implement Role-Based Access: Audit who has access to what data. Implement least privilege - people only see what they need. PII should be locked down tight.

  3. 3

    Monthly Governance Review: Review data access logs monthly. Who accessed what? Any anomalies? Any policy violations? Make governance boring and systematic, like quality control.

In Practice

A SaaS company had 7 different definitions of "active user" across teams. Product said "logged in this month." Sales said "paid subscription." Customer Success said "used a core feature." Exec dashboard pulled from all three sources and showed conflicting numbers every week. CEO lost faith in analytics. New Chief Data Officer came in, locked everyone in a room, forced one definition: "Active user = logged in AND used a core feature in the past 30 days." Built one source of truth in the data warehouse. Killed all competing reports. Initially, teams complained. Six months later, decision-making speed doubled because nobody wasted time reconciling numbers. Investor board meetings became data-driven instead of data-debated. Trust in analytics went from 20% to 85%. One definition changed everything.

More on Data Foundations

From the book

In the book, a new hire takes six months to become useful, mostly because of table names nobody can read. And there are five definitions of an active seller.

This card is one of 57 drawn from The Auction Block by Brian Cariveau — the story of an analytics leader with 90 days to fix what the cards describe.

Each leadership pattern falls into a few pitfalls most often. Find your pattern.The Analytics Leadership Mirror: free, 5 minutes, no account