A Case Study in using data to improve your business
To complete a business wide review to identify opportunities to step change the use of data across the business
When you are a nationwide business supplying your products through 4 of the UK’s largest supermarket chains in addition to your own premises, and you have diversified into providing hotel accommodation, your data strategy becomes a critical part of your success. For this project the client had some very specific requirements that touched on every area of their business; for strategy and decision making they needed a comprehensive summary of all the data and reports produced across their business, for marketing they needed a deep dive into the effectiveness of their promotions, for operations a review of how to improve access to (and use) transaction data was essential, and for stock control and supply chain management they needed to know how to bring 3rd party data back into the business. While also benchmarking against best practice in their sector.
A questionnaire was first circulated across the business. The questionnaire was designed to capture evidence related to ‘As Is’ and ‘To Be ‘processes. The ‘As Is’ questions concentrated on an individuals roles and responsibilities and their ability to make informed decisions, the data available to that individual that was generated both by their own team and provided by other teams, and identified the reports that the individual received. The reports were then ranked in terms of the value they added.
The questions focused on ‘To Be’ processes sought to identify opportunities to improve what they were doing, find barriers and bottlenecks that could stop change in its tracks, and uncover the data that would make a significant difference to their role.
Once the questionnaires had been completed the project team interviewed all the key stakeholders from across the business. This included Board members through to those with responsibility for capturing the data and running the reports.
The RIGHT data in the RIGHT place, reported on at the RIGHT time.
Our toolkit gets results
Documented summary of key data, data sources and reports
Found examples of data and reports used in one part of the business that would be of immediate value to other areas and other reports that were of no value and could be stopped immediately
Highlighted gaps in information and data..
..that we would have expected to find in other sector companies– and identified ways to address these gaps
Measured the effectiveness of promotional activity
Outlined the process and provided template reporting examples to measure the effectiveness of promotional activity. This included analysis of promotions that ran in the previous 3 months.
Completed and shared transaction based analysis
Provided insight on customer purchasing behaviour at individual premises and in turn identified opportunities to improve range and product mix. This used existing data held in the IT team but not accessed or used by the rest of the business
Recommended opportunities to access 3rd party data
Using a user friendly format which would simplify data processing, improve the timeliness of reporting and enable additional insight to be created
Click on an image to see how we are helping our clients get more organised
If you want to know more