Responsibilities
Conducted detailed analysis on large datasets to provide simple and clear insight to feed into company category strategy.
This could be to incorporate new business initiatives, address inefficient categories, increase sales, reduce waste or simply run ‘what if?' scenarios. Post launch reviews were carried out to identify what sales benefits were attributed directly to my space insight, using a process I was instrumental in creating.
Data was sourced, combined, manipulated and solutions identified using Excel, Teradata, SQL, Alteryx, Tableau and in house tools.
Processes were changed or improved where efficiencies were spotted and training materials written and amended and relevant colleagues trained and upskilled.
Key Achievements
Provided the analysis and recommendations for ASDA's biggest ever space swap. Ran the team that implemented the recommendations.
This resulted in the first positive like for like sales in over 7 years
Addressed the waste issues in the company's worst 50 stores without damaging sales and cause little disruption for colleagues in head office, store and the customers.
Early indications are that these stores are to have a waste saving of £20k per store per annum, little sales loss, with positive feedback from store managers.
Refined and ran an initially cumbersome clustering process that identified sales patterns in stores. The process took data inputs from several different sources and used linear regression to spot trends.
Categories that implemented the ‘clustered approach' showed sales of 1.5% incremental in clustered stores based versus none clustered stores.
Created the first ever post launch review process that could attribute the cash benefit of the space change element alone.