Why does every report take three weeks?
5 min readUpdated
A business question usually takes weeks because the work is not the query. It is finding which system holds the data, agreeing what the terms mean, waiting in a shared analyst queue, and reconciling numbers that disagree between systems. The query itself is often minutes. Shortening the cycle means removing the handoffs, not hiring faster analysts.
Where the three weeks actually go
- Finding the data (days)The answer is spread across a CRM, a finance system, and a warehouse. Knowing which one holds the authoritative version is institutional knowledge, held by a small number of people who are busy.
- Waiting in the queue (a week or more)Requests land with a small central team that is already committed. Your question is not hard; it is fourteenth.
- Arguing about definitions (days)Does revenue include intercompany? Is a customer counted on signature or first invoice? This conversation happens again for every request because the outcome is rarely written down anywhere reusable.
- Reconciling (days)The CRM says one number, finance says another, and both are defensible. Someone has to work out why before anyone can present it.
- Running the query (minutes)The part everyone thinks is the bottleneck.
Why hiring more analysts does not fix it
Adding people to the queue shortens the queue. It does not touch the other four steps, and it adds a new one. More people who each answer the definitional question slightly differently, so the reconciliation problem grows rather than shrinks.
The teams that get this right do not make the queue faster. They remove the need to join it for the ordinary questions, and keep their analysts for the genuinely hard ones.
What has to be true to remove the handoff
- The person with the question can ask it directlyIn their own words, without knowing which system holds the answer or what the tables are called.
- The definitions are decided onceWritten down somewhere the tool reads, so the answer does not depend on who asked or on which day.
- Permissions come along for the rideSelf-service stops immediately if the security review concludes people can see things they should not. Access has to be enforced automatically, per person.
- The answer can be checkedFinance will not present a number they cannot trace. If the tool cannot show where a figure came from, it will be used for exploration and never for anything that matters.
The honest caveat
Removing the queue does not remove the need for analysts, and any vendor who implies it does is selling you a disappointment. What changes is what they spend the week on: the definitional work and the genuinely difficult analysis, instead of re-running variations of a report that eleven people have already asked for.