The Situation
A pharmaceutical and animal-health company needed a full analytics platform, including sell-in/sell-out reconciliation, and a detailed revenue analysis of one of its top customer accounts.
What We Built
Since March 2026 we have built and maintained a full analytics platform comprising 59 tables and 38 views across 800,000+ rows, including sell-in/sell-out reconciliation, backed by 236 automated tests. The platform has been through three audits, with all 69 identified issues resolved. Separately, delivered in March 2026, we also completed a 3-year revenue analysis for one of the client's top-3 customer accounts: R50.71 million gross revenue and R41.09 million net revenue, with product-mix, discount and risk analysis.
Verified Scope
- Platform: 59 tables, 38 views, 800,000+ rows
- Sell-in/sell-out reconciliation
- 236 automated tests
- 3 audits, 69/69 issues resolved
- Customer deep-dive: 3-year revenue analysis, R50.71M gross / R41.09M net, product-mix, discount and risk analysis, for a top-3 customer account, delivered March 2026
- Platform build ongoing since March 2026
About This Case Study
Client identities are withheld; engagement facts are drawn from our delivery records, verified 30 July 2026.