Data Dragons and the Politics of the Locked Spreadsheet

Wrestling with hidden grit, territorial hoarding, and the high price of proprietary knowledge in the modern office.

Wrestling with a sticky ‘Enter’ key while staring at a locked Salesforce dashboard is not how I envisioned my Tuesday morning, but here we are. Riley M.K. here, currently picking the last few stubborn coffee grounds out from between the mechanical switches of my keyboard with a pair of tweezers. It is a slow, rhythmic, and deeply frustrating process. Every time I think I have cleared the debris, I tilt the chassis and 6 more tiny black specks migrate from some hidden crevice to jam the spacebar. It is a perfect, if somewhat literal, metaphor for the state of modern corporate data architecture: messy, obstructed, and full of hidden grit that shouldn’t be there in the first place.

I am looking at a request from the Marketing Director. She needs the raw conversion data from the last 16 months to prove that the Q3 spend actually moved the needle. The Sales VP, however, has sent back a 46-page PDF. It is a beautiful document, full of glossy charts and rounded percentages, but for an algorithm auditor like me, it is a crime scene. A PDF is where data goes to die. It is static. It is unqueryable. It is a deliberate wall built to prevent anyone from asking a follow-up question that doesn’t have a pre-approved answer. This isn’t a technical limitation. Sales has the Salesforce seats. They have the API access. They simply refuse to share it, citing ‘security protocols’ that seem to have been invented roughly 6 minutes after the request was filed.

The Data Dragon Reality

This is the reality of the ‘Data Dragon’ phenomenon. In the high-stakes theater of office politics, information isn’t just a resource; it is the primary currency of survival. If I give you access to my raw numbers, I am giving you the ability to fact-check my narrative. I am giving you the power to find the 236 leads that we let go cold because our follow-up process is broken. I am giving you the leverage to argue for a bigger slice of the budget based on my failures. In a healthy organization, this would be called ‘transparency’ and ‘growth.’ In the 86 percent of dysfunctional companies I have audited, it is viewed as an act of professional suicide.

Polishing Our Own Piles of Gold

I’ve been guilty of it too.

Let’s be honest. Last year, I spent 36 hours building a proprietary script to automate my audit trail. When a junior analyst asked if they could use it, I told them it was ‘too unstable for general deployment.’ That was a lie. It worked perfectly. I just didn’t want to become obsolete. I wanted to be the only person who knew how to turn the crank. We criticize the dragons while we’re busy polishing our own tiny piles of gold. It’s a contradiction I live with every day. I advocate for open data pipelines while password-protecting my own methodology because, at the end of the day, being the ‘source of truth’ is a very effective way to ensure your desk is still there on Monday morning.

This hoarding behavior creates a fragmented reality. When I look at the company’s performance, I see 46 different versions of the truth, each one meticulously curated to make a specific department head look like a visionary. Marketing says the ROI is 106 percent. Finance says it’s 46 percent. Sales says it’s ‘immeasurable but significant.’ Because there is no single source of truth, the loudest voice in the room wins. The data doesn’t speak; the person with the most political capital speaks for the data. This is why cross-functional projects fail before they even start. You can’t build a bridge if one side is measuring in meters and the other is measuring in the ego-driven whims of a middle manager.

The Cost of Fragmentation: Logistics Nightmare

I remember an audit I did for a logistics firm a few years back. They had 1006 different spreadsheets tracking the same fleet of trucks. Each spreadsheet was owned by a different regional coordinator. If you wanted to know why a shipment was late, you had to call three different people, all of whom would give you a different reason that conveniently blamed someone else. The friction was costing them $676 per hour in lost productivity, and that’s a conservative estimate. They didn’t need a faster database. They needed to stop rewarding people for hiding their mistakes behind private Excel tabs. But how do you fix a culture where ‘knowing something others don’t’ is the only path to a promotion?

Data Sources: One Truth vs. Many Silos

1006 Spreadsheets

90% Noise

1 Centralized Source

98% Accuracy

The Technical Fix: Building the Flow State

It usually starts with a catalyst-something that forces the dragons out of their caves. Sometimes it’s a massive failure that can’t be hidden, and sometimes it’s an executive who realizes that the company is starving in a room full of food because no one will share their plate. The technical fix is actually the easiest part. You build a centralized pipeline. You create a neutral zone where data is cleaned, normalized, and made available to anyone with a legitimate need. You take the human element out of the ‘request’ process. If the data is already in the warehouse, there is no one to say ‘no’ for ‘security reasons.’

The Political Shift: Protection to Optimization

Hoarding Fights

Protection

Focus on ownership.

➡️

Optimization Debates

Flow

Focus on meaning.

This is where the real transformation happens. When you move from a culture of hoarding to a culture of flow, the politics shift. People stop fighting over who owns the data and start fighting over what the data actually means. That’s a much more productive argument to have. It moves the needle from ‘protection’ to ‘optimization.’ But you have to be careful. If you build the pipeline without addressing the underlying fear, the dragons will just find new ways to hoard. They’ll start poisoning the data at the source, or they’ll create ‘shadow’ databases that only they can access. It’s a game of cat and mouse that I’ve played 26 times in the last decade.

The Neutral Zone: Architecture as Prerequisite

To really break the cycle, the organization has to stop treating data access as a reward and start treating it as a prerequisite. It requires an infrastructure that exists outside the reach of department-level gatekeeping. In my experience, the most successful shifts occur when a company brings in an outside perspective to architect the flow-someone who doesn’t have a dog in the political fight. This is why services that specialize in objective data extraction and pipeline management are so vital. If you want to bypass the internal gatekeepers, you need a system that treats information as a utility rather than a luxury. For instance, leveraging a robust architecture like

Datamam can provide that neutral, high-integrity foundation that refuses to play the games of ‘security’ theater often used to mask simple territorialism.

$566

Software Spend

$46,666

Meeting Waste

76%

Time on Janitorial Work

It is an absurd waste of human potential. We have people with PhDs in statistics spending 76 percent of their time acting as data-janitors, begging for access to tables that should be public. It’s a form of institutional madness. The gatekeepers think they are protecting the company, but they are actually strangling it. A company that cannot see itself clearly cannot move quickly. And in a market that changes every 6 seconds, standing still is the same thing as moving backward.

The cost of a secret is often higher than the value of the knowledge itself.

– An Unlocked Truth

Setting the Information Free

I finally got the ‘Enter’ key working. It took 16 minutes and a can of compressed air that smelled like ozone and regret. I sent an email back to the Sales VP. I didn’t ask for the PDF. I didn’t even mention it. I simply CC’d the COO and asked for the direct API credentials for the audit. Magically, those ‘security concerns’ evaporated within 6 minutes. It turns out the dragon isn’t so scary when the king is watching. But I shouldn’t have had to do that. No one should. We have to move past the era of the information fiefdom. We have to recognize that the power of data doesn’t come from holding it; it comes from what happens when it’s finally set free.

The Path Forward: Utility Over Luxury

⚙️

Data as Prerequisite

Not a reward for tenure.

👁️

Forced Clarity

Breaks the need for narrative cover.

⚔️

Executive Backing

Necessary to bypass gatekeepers.

The question is: are you brave enough to let people see what’s actually happening in your department, or are you still busy polishing your pile of gold while the rest of the world moves on?