Globalising EPOS Data

[Delliott]

Author:

Dave Elliott

Role:

Global Data Innovation Manager

Company:

Mayborn Group

Collaborators:

Chris Davidson, Mark Little

Overview of Use Case

As a business, the Mayborn Group has access to a trove of Electronic Point of Sale (EPOS) data from many of its retailers, along with wider data sets of market performance of competitors. Using Alteryx, they've been able to visualise data to provide an enhanced view of their operations at a global level, while adding increased visibility and access across the entire organization. 

Describe the business challenge or problem you needed to solve

As a consumer packaged goods manufacturer, data is provided from retailers in relation to sales data from stores (EPOS). We receive EPOS data from over 50 retailers, across three regions (EMEA, US and APAC).  That's data for over 4500 stores global, resulting in hundreds of thousands of new rows of data on a weekly basis. Each retailer provides data in different formats. This results in a challenging, time consuming and manual process to collate and blend all these data sources to provide any meaningful analytics.

Data is manually merged, tweaked and processed retailer by retailer, region by region, providing very specific views of performance in isolation to each other.  It's difficult to see the global picture, or in some cases, even the regional level without considerable manual effort and Excel manipulation.

Describe your working solution

Until Alteryx, this global picture was impossible to achieve within the business. Alongside retailer data, the business subscribes to various 'market share' data services, which provides a view of the 'Baby products sector' for all major brands. This data impacts all aspects of the business, from sales, commercial, demand and supply, trade marketing, New Product development and Category through to C-level executives. 

The Global Data Innovation team were tasked with bringing all these data sources in to a single 'Global' view as part of a wider Digital Transformation and Data program.  With the objective of providing self service analytics of not only retailer EPOS data but global market analysis data in one place.    

Our data is received from multiple sources in various formats (mdb, xlsx., csv.)

1. Alteryx Server is utilised as the core 'Data engine' of our Insights platform, blending and preparing data for consumption through Qlik Sense.

• Retailer 1
  

• Retailer 2

Multi retailer EPOS data blending

• Market Share 1
• Market Share 2

2. Data is stored internally within our data center.

3. Qlik Sense is utilized as the analytics and visualisation platform for business user access to the data. 

Describe the benefits you have achieved

Using Alteryx makes me feel that we have the tools behind us to address any data challenge the business throws at us with ease, rapidly and confidently. We have achieved the following benefits as a direct result of Alteryx: 

1. Automated extraction, processing and consolidation of around data 50 sources, reducing manual data preparation. Processing data in under 1 hr., compared to the previous manual process which involved more than 10 users spending days each month pulling and processing data.
2. Removal of data silos, building a centralised (one version of the truth) view of the global EPOS activity, accessible to all. 

The future of analytics is the driving force behind the digital journey we are on as a business, we are constantly horizon scanning for the next step in our journey.  Be it Chat Bots, Assisted Machine Learning, prescriptive analytics or augmented reality or any of the multitude of developments within Analytics, always looking to the next steps enhances the excitement to what we do. Seeing how our users get excited about what we are doing, their enthusiasm and how our solutions are making their work life easier, is the core to what excites me about the future of Analytics.  

[mceleavey]

Nice work, Davey Boy.

[brig]

Great work! Nice and tidy workflows. 🙂 

[usmost]

David,

Thanks for this complex yet insightful EPOS use case.. As these analytics continue to develop, could one anticipate hypothetically that the next project includes developing forecast sales and inventory models. Moreover, if so, what would be the development workflow process within Alteryx using the single 'Global' view concept you have described.

[Delliott]

Hi @usmost,

Thanks for your post, glad you found the case study interesting. You are correct, Sales forecasting and inventory modeling are on our road map. Watch this space for future case studies.

Dave