We took Swizzels from Excel overload to self-service sales intelligence.
How a near-century-old British confectionery manufacturer replaced inconsistent reporting with role-based Power BI dashboards across the entire business.
The problem
Swizzels had data – but it wasn't being used. Over-reliance on Excel, inconsistent reporting and no modern analytics capability meant management lacked the timely, accurate insight needed to drive decisions across a fast-paced and rapidly growing business.
‘It flags up issues, if something's in decline, you can quickly reverse that decline by looking at where the negatives are coming from in that report.’
What Anumana delivered
Azure Data Architecture
We built a Microsoft Azure database architecture to consolidate data from Swizzels' IBM iSeries – their core business system – creating a single, reliable foundation for all reporting.
Medallion Architecture in Databricks
A Bronze, Silver and Gold medallion architecture in Azure Databricks transforms raw iSeries data into a clean, consolidated and accurate format, ready for analytics.
Role-Based Power BI Dashboard Suite
A suite of Power BI dashboards tailored by management level – from CEO to account executive – each with appropriate access controls and the depth of insight relevant to that role.
Self-Service Sales Analytics
Teams can now interrogate sales performance against budget and forecast – sliced by customer, product and time period – on any device, with no dependency on IT and no manual Excel extraction.
‘At month end, I would be spending three to four hours working through all my team's numbers, whereas now I'm doing that in as little as ten minutes to actually pull the report.’
Ready for performance gains?
Let's start with a conversation and find the problem worth solving.
Start a conversation