A look at how QlikView adds value to Orthomedics’ ERP system
Customer Company Size
Mid-size Company
Region
- Africa
Country
- South Africa
Product
- QlikView
Tech Stack
- ERP
- AQL (Associative Query Logic)
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Industries
- Healthcare & Hospitals
- Retail
Applicable Functions
- Sales & Marketing
- Human Resources
Use Cases
- Real-Time Location System (RTLS)
- Predictive Quality Analytics
Services
- System Integration
- Training
About The Customer
Orthomedics is an importer and distributor of medical products. Headquartered in Cape Town, the company has branches and salespeople throughout South Africa. The company began trading in 1986 and in February 2000 was awarded the Medi-Clinic Supplier of the Year 1999. Orthomedics continues to be a market leader in the Orthopaedic and Spinal markets within South Africa. The company also services non-orthopaedic markets such as gynaecology, plastics, cardiology and vascular surgery.
The Challenge
Orthomedics, a leading importer and distributor of medical products in South Africa, was facing challenges with its existing ERP system. The system was successful in storing information but lacked high-performance data analysis tools. This resulted in managers spending more time sorting out IT issues rather than analyzing the data. Other problems included the time taken to retrieve the information and distribute reports. With a national footprint, the timely distribution of accurate information was critical. The company had reached a point where it needed to generate over 150 sales analysis reports to cover various requirements.
The Solution
Realizing that a vital aspect was missing from the ERP system, the company took the decision to implement the business intelligence (BI) and data analysis software – QlikView. They chose QlikView because it runs in-memory and does not use OLAP based technology. This gives much better response times and simplifies the implementation and use of BI significantly. QlikView also teaches people to focus on analysis instead of reporting. The 150 sales analysis reports where replaced with a single sales data model that also provides guided analysis. Apart from the fact that it is much simpler to manage, users now have easy access to relevant information which they can manipulate as required – they don’t need to ask an IT person for assistance.
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
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.
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
How Sirqul’s IoT Platform is Crafting Carrefour’s New In-Store Experiences
Carrefour Taiwan’s goal is to be completely digital by end of 2018. Out-dated manual methods for analysis and assumptions limited Carrefour’s ability to change the customer experience and were void of real-time decision-making capabilities. Rather than relying solely on sales data, assumptions, and disparate systems, Carrefour Taiwan’s CEO led an initiative to find a connected IoT solution that could give the team the ability to make real-time changes and more informed decisions. Prior to implementing, Carrefour struggled to address their conversion rates and did not have the proper insights into the customer decision-making process nor how to make an immediate impact without losing customer confidence.
