← Back to customers

Proof, client by client.

Fifteen engagements, from a single dashboard to a five-year platform. Every one started with numbers somebody did not trust, and ended with a view they could act on.

Filter by sector
Order

Showing 15 of 15 case studies

Arla Foods Monthly market reporting, from 20 days to 10 minutes, across 16 markets 16 markets20 days to 10 minutes Sixteen markets each reported Nielsen data their own way, so a consolidated view took around 20 days of manual preparation every month. Optia now harmonises 60+ files into one Power BI environment. Five years on, it is opened more than 100 times a day. Read the case study → Campari One Total Trade view with no average of averages 14 dashboard pages4 data providers Distribution means weighted distribution in retail and an outlet count in the on-trade, so the two channels cannot simply be joined. Optia built the Total Trade model in the reporting layer, and if periods do not align, no Total Trade figure is published. Read the case study → Starbucks EMEA 33 monthly reports, consolidated into one explorable model 16 markets33 reports consolidated Sixteen markets produced 33 separate monthly reports that were hard to compare or trend. Optia consolidated them, reconstructed 13 missing periods, then built an intelligence layer that drafts commentary from three different commercial perspectives. Read the case study → Bacardi 40+ hours a month of manual reporting, removed 8 source systems40+ hours a month (project 1) On-trade and off-trade data arrived separately, and a total trade view needed manual reconciliation that was not always done. Two projects later, eight source systems feed one automated model and report generation runs in minutes rather than days. Read the case study → Australian Vintage £26m of misclassified sales, caught before the board saw it £26m of category reporting corrected~793 SKUs recovered A classification problem in no and low alcohol misstated around £26 million of category performance, and a later delivery dropped about 793 SKUs. Optia's validation controls caught both before publication and secured corrected historical data. Read the case study → Golden Acre Foods One weekly view across Tesco, Sainsbury's, Asda and Morrisons 4 major retailers30% less time Thousands of product records had incomplete SKU information and there was no historical depth to tell a real trend from a weekly wobble. Optia now delivers a harmonised view across Tesco, Sainsbury's, Asda and Morrisons every Wednesday, with two full years of comparable history behind it. Read the case study → Samworth Brothers One board-ready view across six categories 6 categories~1 week reclaimed Six operating companies each reported their own way, so the group board pack took around a week of Excel work every month. Optia harmonised five external sources with internal submissions into one model, and a data quality review caught reporting errors that had gone unnoticed. Read the case study → Vit Hit Distribution and promotion, finally visible next to sales 3 categories3 years of history Previous reporting told Vit Hit what had happened but not why. Optia built a model across four categories and three market levels, with three years of weekly history, so the sales team could see whether growth came from distribution, promotion, price or rate of sale. Read the case study → International Beverage Monthly leadership reporting, no longer built by hand by one person 6 data sources156 weeks loaded The monthly leadership pack was built by hand by a single insight manager, across seven sources on different calendars. Optia is building one governed model to feed both the Power BI environment and the existing PowerPoint, with history extended from 13 weeks to 156. Watch this space → In progress Samyang Foods Sell-out, sell-through and sell-in, side by side 5 European markets3 data layers Buldak's rapid European growth left three views of the business being managed separately, with no simple way to explain why they disagreed. Optia is building one model across five markets so demand, distributor sales and supply can be compared directly. Watch this space → QTS Data Centres Twelve months of maintenance, compressed into nine and a half 45MW site12 months into 9.5 Thousands of assets, three handover phases and a web of redundancy and seasonal constraints meant no simple way to prove every rule had been respected. Optia's constraint-based model cannot produce a schedule that breaks them, and returned a full replan in five days. Read the case study → Inspired Learning Group Reporting built around the decisions heads can actually make ~25 settings5 source systems A group P&L can run to hundreds of lines, only a few of which a head can influence, and the data sat across five systems on different rhythms. Optia connected all five and structured the reporting around who needs to make the decision. Read the case study → Henkel Eleven categories, down to individual SKU and retailer 11 categories2 years of history Share moves at a much lower level than the category total, but the same product could appear as a unit, multipack, refill or variant depending on retailer and source. The project resolved that mapping first, then let users move from total category down to a single SKU. Read the case study → Confidential engagement A Tier-One Global Bank Zero Priority 1 incidents during peak regulatory periods 30,000 recordsZero P1 incidents A global bank operating across APAC jurisdictions has to show not just the result but how it was produced, which data was used and who touched the process. Optia maintains the pipelines and rule logic underneath, with no dashboard layer at all. Read the case study → Oracare Group Three dental brands and multiple countries, reported as one group 3 practice brandsMulti-country estate Three practice brands across multiple countries each produced patient, treatment and revenue data in their own structure. Optia consolidated them into one prepared source and replicated the reporting leadership already recognised, rather than replacing it. Read the case study →

No case studies in that sector yet. Choose another filter, or tell us what you are working on.