Atheon Analytics has moved its entire SKUtrak® database system from SQL Server to EXASOL, freeing the log-jam of data for major FMCG and retail brands for the best data-driven decisions at speed. This has provided Atheon Analytics’ confidence in the SKUtrak® platform’s ability to deliver to their customers with the following improvements:
- Reports for Atheon Analytic’s clients now complete at 7:30am instead of 3pm, resulting in actionable insights being available at the start of the day
- On average a 5x improvement in performance compared to the previous SQL Server implementation
- Vastly improved concurrency means more clients can use the system simultaneously without adversely affecting performance
EXASOL, London, 14 August 17: EXASOL today announces that Atheon Analytics, the big data retail analytics consultancy that works with more than 400 FMCGs and all major supermarkets in the UK, has now completed the move of its entire SKUtrak® platform’s analytical infrastructure onto EXASOL. This has delivered superior reliability and analytic performance, dramatically speeding up access to granular and visual data insights for FMCG and grocery. The improvements this brings SKUtrak® has resulted in increased collaboration between grocery and their suppliers, empowering them with the ability to make faster, better decisions in areas such as the supply chain, forecasting and promotions. Ultimately this delivers a better customer experience to shoppers, while reducing working capital and increasing profits.
FMCG brands and retailers generate enormous amounts of data each day and Atheon Analytics has billions of rows of this data under management. This means they not only need the fastest database to help them deliver the best insights to their clients, but they also require superior reliability, concurrency and scalability.
Using EXASOL, Atheon Analytics has dramatically reduced the time to on-board new clients and can now offer a better service to existing clients. One example of this is Müller: with its 45 million rows of data Atheon Analytics wasn’t able to load Müller’s whole dataset into its previous SQL Server database, so had to use aggregated data which meant extra work and lost insights.
Atheon Analytics also struggled with concurrency at peak times before EXASOL was introduced: if 30 queries were requested, only three could run in SQL Server. This is no longer an issue, which creates peace of mind for Atheon Analytics and a first-class service for its clients. The implementation has also delivered significant cost savings by reducing overheads. Now Atheon Analytics can focus its time on SKUtrak’s product development rather than on database administration tasks.
Supermarkets are being pushed to be more transparent with their supply chains. Legislation known as Groceries Supply Code of Practice (GSCOP) encourages the principle of fair dealing, and as a result, supermarkets are becoming more open with their data. However conversely, grocers expect their suppliers to be well-informed and to work towards the mutually beneficial goal of increased sales. This means they need an understanding of who their ultimate consumers are. Retailers often classify their stores by local demographic data but Atheon Analytics’ intelligent algorithms can highlight which stores don’t behave as expected and recommend suppliers adjust accordingly.
An example of this was the insight gained in a local supermarket in Stratford. Demographically, the borough of Newham is classed as deprived but the Stratford store had several anomalies. One such anomaly was the outperformance of almond milk. It was found that due to its proximity to Westfield shopping centre, and its relatively wealthy transient population, the Stratford store behaved as if it were in an affluent area.
Guy Cuthbert, managing director, Atheon Analytics says: “To be able to derive insights like this we need the most granular data at SKU level, however we were experiencing a log-jam with our SQL database that was holding us back. By speeding up reporting times and increasing concurrency, we have been able to deliver the best data insights, at speed, to our customers. In turn, they are able to use their data to its full potential and build better relationships with their own customers. This ultimately helps them make the decisions to increase profitability in a highly competitive and tight-margined marketplace.”
Atheon Analytics is also looking towards artificial intelligence to make better predictions and to move down the supply chain. Guy continues: “With the power we have in EXASOL, we now want to improve our decisions and become more forward-looking by integrating technology such as artificial intelligence into our solutions. We want to ensure our supply chain insights are as good for fresh as they are for ambient with many weeks of lead time.”
EXASOL is passionate about helping companies to run their businesses smarter and drive profit by analyzing data and information at unprecedented speeds. The company develops the world‘s fastest database for analytics and data warehousing, and offers first-class know-how and expertise in data insight and analytics. The in-memory analytic database is the first database to combine in-memory, columnar compression and massively parallel processing, and is proven to be the world‘s FASTEST, topping the list in the TPC-H Benchmark tests for performance. For more information, go to www.exasol.com
About Atheon Analytics
Atheon Analytics has been researching, developing, implementing and training in visual analytics tools and techniques for nearly ten years. The founders come from backgrounds in computer science and grocery retail, and the company has delivered over one hundred commercial consulting projects for clients in the grocery retail & consumer goods sectors – for both international retailers and global consumer goods manufacturers. Atheon’s retail analytics platform SKUtrak® is used by over 350 consumer goods companies to understand optimise and communicate trading performance with their retail customers. More information can be found at www.atheonanalytics.com