It’s estimated that more than £40 billion is spent on training in the United Kingdom, making it a significant area of investment for many organisations. However, employee development is notoriously difficult to quantify and, without the right tools in place, Tesco found it challenging to accurately understand what kind of return it was making on its investment.
“Tesco takes employee development very seriously and is extremely proud of its L&D programme,” says Derek Mitchell, Insight and Analytics Manager at Tesco’s Customer Engagement Centre, in the UK. “But prior to using Tableau, it was almost impossible to really understand how that investment was affecting key areas such as employee efficiency, or satisfaction over the long term.” When Derek joined the business in 2019, Tableau was already in use at its Dundee campus, but not to its full potential.
“Employees were analysing single Excel files in Tableau, but there was no consolidation of data sources or advanced functionality in use,” says Derek. “Additionally, a lot of L&D data was stored across multiple disparate sources, making it very hard to analyse in a comprehensive manner.”
Derek’s team began by consolidating all three major L&D data sources – performance data in SQL Server, attendee feedback in Microsoft Forms, and L&D sentiment in Excel – together in Tableau, replacing 74 individual data charts with one single source of truth. His team then combined key information from those data sets together for the first time in a dedicated dashboard, revealing three key areas where ROI could be tangibly demonstrated to the senior leadership team. These areas included: learner sentiment towards the training experience, learner confidence in the topic, and learner performance against KPI’s post-training.
“By comparing attendee feedback from Microsoft Forms against performance data in SQL Server, we started seeing some interesting patterns,” says Derek. “For instance, we were able to see for the first time that simply looking at whether attendees enjoyed an experience was no predictor of a shift in performance post-training.”
“Without Tableau, important insights like this would still be going undiscovered, buried in spreadsheets and forms spread across the business,” continues Derek. “Now we can use them to create tangible links between the training we are providing and the improvements in everyday employee performance, which is invaluable.”