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.
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.
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.
2 Leman Street