Market Research
Case Study
Kingfisher, a FTSE 100 public listed company dedicated to home improvement, boasts a vast network of more than 1,900 stores and a workforce of 82,000 team members. Their retail banners, including B&Q, Castorama, Brico Dépôt, Screwfix, TradePoint, and Koçtaş, serve customers across eight European nations. Through the brick-and-mortar locations and e-commerce channels, they offer an array of home improvement products and services to consumers and trade professionals alike.
Find out more about how we helped Kingfisher drastically improve productivity below.
Project Details
- Client: Kingfisher
- Original: New Project
- Solution: Microsoft Excel Visualisation Tool
- Project Duration: 1 month
- Client Website: www.kingfisher.com
The Challenge
Kingfisher faced the challenge of conducting market analysis to compare its brands with competitors across multiple markets. This required extensive research and data collection to assess market trends and consumer behavior. Furthermore, the company faced complications due to needing foreign exchange conversions, which added another layer of complexity to their operations. Overcoming these challenges was essential to maintaining Kingfisher's competitive edge in the home improvement industry.
The Desired Outcome
In order to increase efficiency of the business as a whole, the ability to view data at a grouped level and drill down to lower levels would enable the company to identify patterns and trends quickly. An intuitive and clean user interface would make the tool easy to use, saving time on training and increasing productivity. The option to change filters on the fly and have it affect all tabs would further streamline the analysis process, allowing for rapid adjustments and decision-making. Ultimately, these features combined would enhance Kingfisher's data analysis capabilities, leading to more efficient and informed business decisions.
The Solution
It was collectively decided to use Microsoft Excel as the platform for the solution. The solution included a floating menu that allowed users to change the data source regardless of their focus, whether on a chart, table, or other element. A hierarchical data structure was implemented to enable drill-down, and a suite of pre-built tables and charts was included for quick analysis and presentation creation. The solution provides users with the ability to analyze data with ease, delivering client-ready slides in a timely and efficient manner.
The Impact
By creating an Excel-based tool, Kingfisher's teams across the globe have realised the following benefits:
- Efficiency - users can now use floating menu for quick alteration of the data source, resulting in saved time and increased productivity.
- Flexibility - users can now explore data at various levels of detail using the hierarchical data structure within the tool.
- Consistency - users can rely on standardized formats and visualizations, leading to more consistent and accurate data interpretation.
Get your free initial consultation.
Book a free, 30-minute initial consultation to discuss your requirements and explore available options with one of our helpful team members.
Contact Us
Address:
Aldgate Tower
2 Leman Street
LONDON
E1 8FA
Email:
info@bettertechnology.co.uk