FSI Blogs All articles
Business Intelligence

Behind the One-Line Email: A Field Account of the 'Quick' Data Request That Ate a Quarter

FSI Blogs
Behind the One-Line Email: A Field Account of the 'Quick' Data Request That Ate a Quarter

Photo: business analyst working late at desk with multiple monitors and spreadsheets, via img.freepik.com

The request arrived at 4:47 p.m. on a Tuesday, and it was, genuinely, one line: 'Can you pull revenue per customer by region for the board deck?' To the sender, it was a fifteen-minute errand. To the analytics team that received it, it was the beginning of an eleven-week odyssey.

This column reconstructs that journey—not to mock the executive who asked, but because the gap between 'quick question' and 'quarter-long project' is one of the most expensive misunderstandings in corporate America, and it persists largely because nobody on either side can see the whole picture.

Week One: The Definition Problem

The first week was spent not on data, but on semantics. Revenue per customer: booked or recognized? Net of returns? Did 'customer' include the dormant accounts the sales team keeps on life support? Three departments offered three confident answers, all different. The analyst scheduled a alignment meeting. The meeting spawned a follow-up meeting.

Weeks Three Through Six: The Archaeology

The regional field in the CRM turned out to be populated inconsistently—sales reps in the Southeast had been free-typing territory names since 2019. The billing system stored customer IDs in a format incompatible with the CRM's. A contractor who built the original mapping had left the company; his documentation was a Confluence page last edited during a different presidential administration.

Weeks Seven Through Ten: Validation and Rework

When the first draft arrived, finance flagged a 6% discrepancy against their own numbers. Both were 'right,' computed on different fiscal calendars. Reconciliation began. Somewhere in week nine, the executive who made the request mentioned, almost casually, that the board actually wanted it 'by channel, not region.'

Why the Timeline Stays Invisible

The executive never saw any of this, and that is the design flaw. From the corner office, a data request is a black box: it goes in, and either a number comes out or silence does. There is no ticket status, no ETA, no visibility into whether the delay is laziness, complexity, or a data quality problem that predates the request by a decade.

The fix is borrowed, unglamorously, from IT operations. When a server goes down at any competent technology organization, nobody wonders what's happening. There is a ticket, a severity level, a published SLA, and a status page. Data functions should operate the same way:

Five Minutes in the Boardroom

The final slide took the executive five minutes to present. The organization spent eleven weeks and roughly three salaries' worth of hours producing it. That ratio is not an argument against asking—it is an argument for seeing. When the true cost of a 'quick' request becomes visible, executives ask better questions, data teams prioritize honestly, and the black box finally gets a window.

All Articles

Related Articles

Flattering the Median: How Benchmark Reports Quietly License Bad Decisions

Flattering the Median: How Benchmark Reports Quietly License Bad Decisions

Beyond the Scripted Demo: Designing a BI Bake-Off That Survives Contact With Your Business

Beyond the Scripted Demo: Designing a BI Bake-Off That Survives Contact With Your Business

Handcuffed to the Stack: The Contract Terms Quietly Eroding Your Data Strategy

Handcuffed to the Stack: The Contract Terms Quietly Eroding Your Data Strategy