Quick, Relevant and Convenient Information Analysis: QlikView Allows Van Oirschot to Gain Consistent Insight into Its Data
Customer Company Size
SME
Region
- Europe
Country
- Belgium
Product
- QlikView
- Microsoft Dynamics Warehouse Management
- Microsoft Dynamics
- SQL Server
- Excel
Tech Stack
- QlikView
- Microsoft Dynamics
- SQL Server
- Excel
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Customer Satisfaction
- Cost Savings
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Sales & Marketing
Use Cases
- Supply Chain Visibility
- Inventory Management
- Predictive Replenishment
Services
- Data Science Services
- System Integration
About The Customer
Van Oirschot is a supplier of heating and installation materials for professional installers in Flanders. Founded in 1967, the company operates five branches and a central distribution centre in Flanders. Its broad assortment and more than 90 employees with in-depth technical expertise meet all the needs of the professional installer. Van Oirschot is a family company and acts as distributor for Belgian installers. It creates added value by handling additional aspects for its customers, such as transport, stocking, provision of credit, collection and splitting, packaging and repackaging, services, guarantees, returns, information provision and training. The company is constantly striving to maintain and reinforce its competitive strengths.
The Challenge
Van Oirschot, a supplier of heating and installation materials for professional installers in Flanders, was facing the challenge of implementing a reporting and analysis tool that ensures consistent information provision and provides easier insight into Microsoft Navision data. The company operates five branches and a central distribution centre in Flanders. It creates added value by handling additional aspects for its customers, such as transport, stocking, provision of credit, collection and splitting, packaging and repackaging, services, guarantees, returns, information provision and training. However, it was crucial for the company to remain competitive and innovative in the face of increasing competition, chain integration and cost pressure. Moreover, their customers were expecting greater flexibility, longer opening hours and automated ordering processes.
The Solution
Van Oirschot decided to implement QlikView, a reporting and analysis tool, to gain consistent insight into its data. Every day, Van Oirschot’s sales representatives and management use one or more of their eight QlikView applications to independently analyse procurement and sales processes, financial data, service levels, stock levels and stock movements. The company developed eight different QlikView applications in the field of sales, procurement, logistics, organisational management, finance & cash flow, stock levels and stock movements. All Van Oirschot’s sales representative and its management teams use these applications on a regular basis. QlikView enhances their insight into their margins, allows them to quickly make adjustments, and improves customer satisfaction by quickly identifying potential issues for each customer.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Remote Temperature Monitoring of Perishable Goods Saves Money
RMONI was facing temperature monitoring challenges in a cold chain business. A cold chain must be established and maintained to ensure goods have been properly refrigerated during every step of the process, making temperature monitoring a critical business function. Manual registration practice can be very costly, labor intensive and prone to mistakes.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
