Central Dashboard

Problem Area

Many Indian States & Union Territories have their own IT solution for managing their inventory/supply chain of Drugs & Vaccines. But their consolidated performance at the national level is the need of the hour, to ensure constant improvement in health care service delivery through effective policy formulation and decision making at the level of Ministry of Health & Family Welfare (MoHFW), Government of India.

To fetch data from heterogeneous data sources from various Indian States & Union Territories and to create a Data Lake & perform various transformations on it and to present it for visual analytics.


The need for a Solution

MoHFW desires to monitor the performance of states & union territories through a Bird’s Eye View on various “Key Performance Indicators” by fetching data from multiple IT solutions and by performing analytics on the fetched data.



Central Dashboard is designed & developed for the MoHFW, GoI to facilitate the aggregation of data on predefined key parameters. Central Dashboard extracts data from Indian states & Union Territories, performs transformations on it, populates the central repository & various data marts and presents data for visual analysis through the web as well as mobile interfaces.


The main Key Stakeholders:


Main Features of Central Dashboard:


ETL High Level Process View:

Central Dashboard


Sample Key Performance Indicators (KPIs):

  • EDL Details
  • Rate Contract
  • Demand and Procurement
  • Stock Details and Expiry Details
  • Usage
  • Stockout details
  • Consumption Pattern
  • Coverage
  • Procurement
  • Storage
  • Demand Supply
  • Quality Control
  • Logistics
  • Summary KPI.
  • State Rank
  • NIN Details
  • Feedback details
  • Functional Facilities
  • Comparative RC
  • Consolidated State Performance
  • Stock Details for COVID 19 Related Essential Drugs

With this holistic approach our solutions provided critical inputs to MoHFW and State Health Authorities to achieve: