End to End Visibility
Displaying the availability of medicine throughout the supply chain.
Problem Statement
Client has multiple data systems where they capture stock on hand information. They wanted to be able to view the medicine availability throughout the supply chain in order to identify potential issues.
Critical Success Factors
The ability to select a single Item or category of items.
To be able to aggregate the data by Sub-District, District and Province
Secure online platform where users are restricted on what they can use
Solution
Wrote Sql scripts to extract the latest data for each facility from each of the data sources. Linked each data source to a facility and Item master to ensure uniformity across the datasets. Created a workflow to do this semi-automatically.
Created dashboards using tableau desktop where we can visualise the medicine availability through interactive dashboards
Published the views to a server where named users could get access to views linked to the provinces they belong to.
270 Users
1600 Views
9 Reports
10 Data Sources
