Jan Gustafsson is the chief operating officer at the office specialist retail chain, Office Depot in Sweden. The company is a result of Office Depot’s acquisition of Frans Svanströms & CO and AGE Kontor & Data AB. As the project manager, Jan is responsible for finding proper tools for measuring the business. Not only do the shops, which constitute one-third of the business, need to be measured, but other parts of the company’s sales that come from sales via customer service, internal sales, e-commerce, and the sales force also need to be measured. The tools are used by corporate management and also by store managers, product managers, sales management and sales staff.
“We have been working with QlikView for quite some time without exploiting the possibilities to the fullest. It was mostly a reporting tool to export information to Excel spreadsheets. This summer, Infozone came into the picture and helped us to utilize the benefits of QlikView, both with new ideas and by bringing structure to our information. This has given us the ability to twist and turn the numbers and break the numeric content down to each order and invoice. It has also made it possible to analyze our sales in detail in every sales channel, product area and by the customer, and also to measure sales growth over time.”
For store managers, it has become possible to see how much the store is selling compared to other stores and follow the products’ and customers’ profitability. Even if the store manager uses the tool for 15–20 minutes a week, it quickly provides a good picture of the situation and where there are possibilities for improvements. This is important because new trends are also developing in office supply stores. For example, paper consumption is steadily decreasing year by year even though it may only be by a small percentage each year. In turn, this means that the use of binders and similar products also decreases. Instead, the “fancier” office products are increasing, the ones that make the office more pleasant and efficient.
The QlikView tool also helps us to keep track of major customers and their habits and also assists in monitoring campaigns and what the results were. In this way, we can optimize the selection in the store and customize our inventory according to demand.
Every night, the database, which is the basis for all analyses of the business, is updated so that the figures are basically presented to the organization in real-time. The most important thing we have achieved is that we do not have to run Excel everywhere and everyone can get the figures they need directly, fast and hassle-free. Regarding the follow-up of products to check campaign results and pricing strategies, the product managers now have a new favorite tool.
It is increasingly important to compare the sales of the different products in different channels. Here, we have the opportunity to look at the individual order line to get the most interesting information. The information that is retrieved gives rise to numerous speculations, and over the long-term, new approaches. That may be why some products are only sold through the website while others are sold online, and how discount rates impact sales and earnings.
The collaboration with Infozone worked very well. They were responsive, flexible and presented valuable solutions reflecting their expertise in handling large quantities of data. They also gave us useful advice throughout the process. The store employees are very enthusiastic and think we have found a fantastic tool. Some have embraced the possibilities and developed compelling decision-making documentation. There are also quick-guides that make it easy to start using the tool and we also travel around and provide support to users in the regions and in stores,” concludes Jan.
Download case study: officedepotcasestudy
Business Intelligence that makes a difference for Carlsberg Sweden
For several years, Infozone has worked together with Carlsberg on a continuous basis to develop their solution for decision suppor...
Infozone helps ClearOn create value in the checkout environment with a unique analysis solution!
Infozone and ClearOn have, in close collaboration, developed an optimal web-based Business Intelligence solution for ClearOn's ope...