Healthcare
MENA
Tableau Desktop
The client is a renowned hospital chain in the Middle East. The chain spans all of the region’s major cities with around 100+ centres in the form of clinics and hospitals serving patients 24 hours. It caters to approximately 50,000 patients daily and has employed some of the most outstanding medical professionals across several domains.
The client faced frequent challenges related to the availability of essential items required to run the day-to-day operations of their various clinics and hospitals. One such challenge was that while there would be an overstock of drugs available in one clinic, simultaneously, there would be a shortage of the same medicine in the other. The client required an overview of their inventory and stock across various hospitals/ clinics for drugs, equipment etc., to plan better.
The different centres of the client were using their definitions for exact terms. The first was to create a glossary with standard definitions of KPIs of interest. This was followed by creating data using SQL from different client centres. This step, in turn, was followed by data cleaning in Python.
The Python scripts and the data glossary reduced the errors by almost 90%.
Now that the relevant data had been generated, this had to be shown in the form of stunning charts and indicators. Tableau Desktop handled this task.
After the deployment, the client achieved a decrease in the stock of drugs by 50% across the centres, which led to overall efficiency gains.
Back
