Back to Projects
Business Analyst (Freelance) · I.P. Pharma GitHub Repo

Pharma Sales Performance (I.P. Pharma)

30% revenue drop
·
0% change in order volume
·
Revenue restored by Q3
Key Takeaways
  • Revenue dropped 30% in Q1 while order volume held flat — the metric everyone was watching showed nothing wrong.
  • Root cause isolated by Q3 through a transaction-level and client-conversation audit.

The Problem

Q1 revenue dropped 30%, but order volume didn't move. On the number everyone tracked, nothing looked wrong — the business was reading a healthy signal off the wrong metric.

The Method

Went past order-volume reporting into transaction-level data and direct client conversations, tracing exactly where revenue and volume diverged instead of assuming the two moved together.

Recommendation & Outcome

Recommended and pushed through the process changes needed to close the gap once the root cause was traced. Revenue returned to its prior run-rate — a real, delivered result, not a projection, since this was resolved on the job rather than as a standalone analysis.

Why It Mattered

The real finding isn't the 30% drop, it's the flat order volume sitting next to it. A team that only tracks order count would have read “steady” as “healthy” and missed this entirely. Catching the disconnect, and closing it within two quarters, is the difference between reporting a problem and owning a fix.