John Thacker is the Quality & Support Services Manager for Siemens Security Products with headquarters in Solna, Sweden. This unit of Siemens is known for its innovative security solutions in the areas of access control, integrated security systems, video surveillance and alarms. This includes both hardware and software.
Responsible for quality and support services, John and his team are given the task to streamline business solutions, reporting, and finding solutions that enable the content of the business systems to be more easily accessible and more user friendly. John decided on a QlikView solution because getting the sales figures from the business system got very complicated and time consuming.
The first step in his QlikView solution was an application for analysis of sales. In total, about 2,300 different products were distributed over the product areas of access control, integrated security systems and video surveillance.
The second step in his QlikView solution was a “logistics cockpit”, an application that provides a comprehensive overview of the logistical situation. It shows the inventory levels and gives a forecast of expected sales. An important part of this feature is that you can see early on which products are outside the expected; for example being abnormally high or low stock levels.
“Previously we worked in complex Excel spreadsheets, where we got the numbers from the system once a month. Today the numbers are delivered in real time.”
“The major benefit in the QlikView solution is that we get a much higher visibility of the information. Instead of looking through Excel spreadsheets for abnormalities a month later, we have the opportunity to see deviations and warning signals immediately. We see it in at the product level, geographic level, customer level and we can see and follow how the margins develop. This gives us the opportunity to act much faster and more efficiently.”
“The partnership with Infozone has been fantastic. They are easy to work with, even for us who are a large and complex organization with a variety of requirements on procedures and system demands. But Infozone was extremely flexible and resolved all problems as they appeared. They quickly noticed what we needed and supplied us with good arguments and solutions.”
“Now we have quick access to all of our figures that we can twist and turn to obtain critical business information. We can then present it in an educational way so that what is important in the information easily becomes available and everything is happening in real time. An extra bonus is that we can decrease the number of expensive licenses to the business system because QlikView solves a lot of the employees’ needs at a significantly lower cost.”