Saturday, March 18, 2023

Visualization of Healthcare Indicators – Delivery Load per Facility VS Per Capita Delivery Load for Staff Nurse

 

Image Reference - https://images.pexels.com/photos/7578652/pexels-photo-7578652.jpeg?auto=compress&cs=tinysrgb&w=175&fit=crop&h=275&dpr=2


Generally, insightful visualizations express the hidden meaning within a given set of data. Data collected as healthcare indicators are no exception to this generalization. In this blogpost, an attempt is made to illustrate following two healthcare indicators by plotting in cartesian co-ordinates: -

  1. Delivery Load per Facility – ‘Delivery Load per Facility’ to represent average number of deliveries per facility and be expressed as a “Decimal Number”. Delivery load may be calculated across a given geography for a given period of time (usually quarterly or yearly). If the delivery load is calculated from futuristic perspective, an estimated number of deliveries be calculated based on demographic and biological (like (say) fertility rate) considerations. If the delivery load is assessed for analysis of historical data, actual number of recorded deliveries be taken into consideration.

  2. Per capita delivery load for Staff Nurse – ‘Per capita delivery load for Staff Nurse’ to represent average number of deliveries a single nurse has to attend and be expressed as a “Decimal Number”. Per capita delivery load for a staff nurse may be calculated across a given geography for a given period of time (usually quarterly or yearly). If the per capita delivery load is to be calculated from futuristic perspective, an estimated number of deliveries a nurse would have to attend is estimated based on historical data and based on predictive analysis of dynamics healthcare ecosystem. However, if the indicator is used for a period in the past, the actual recoded values of staff nurses be used. 

Now, these indicators should include data from both public and private healthcare services. However, mostly, it is observed that such data are available only for public sector healthcare services. So for now, let us consider the above indicators to indicate public sector healthcare service provisioning.

Keeping in mind the above discussions, let us attempt to show the above indicators in cartesian co-ordinates with Delivery Load per Facility in Y axis and Per Capita Delivery Load for Staff Nurse in X axis (refer to the graph is Figure - 1).


Figure – 1: Delivery Load per Facility versus Per Capita Load for Staff Nurse


It is evident from Figure – 1 that broad understanding on availability of staff nurses can be broadly assessed based on data visualization of the above mentioned two indicators. Assuming optimal utilization, the geographies with high Per Capita Delivery Load for Staff Nurses (average) and with high Delivery Load per Facility (average) could be considered to have good numbers of staff nurses and facilities may be getting utilized well. Similarly, assuming optimal utilization, the geographies with low Per Capita Delivery Load for Staff Nurses (average) and with low Delivery Load per Facility (average) could be considered under-utilized facilities. A low Delivery Load and high per Capita Deliver Load for Staff Nurse may indicate facilities with under-staffed nurses. And a high Delivery Load and low per Capita Deliver Load for Staff Nurse may indicate facilities with over staffed staff nurses.

However, while doing the above analysis (as depicted in Figure -1), the assumptions are as under: -

  1. It is assumed that all other aspects influencing the above indicators remain unchanged.

  2. All historical data are recorded accurately and future predictive analysis are reasonable.    

  3. Facilities are largely similar with nearly the same size and capacity, so that, averages taken into account hold reasonably well for analysis.

This is just to illustrate that a set of two chosen healthcare indicators may insist on resource utilization of healthcare facilities. When such an analysis is used, it is quite likely that within a significantly diverse geography and across a substantial period of time, the real data may fall in different ordinates of the cartesian shown above. In such a situation, meaningful inputs to healthcare management be given.




/**********************************/


Wednesday, March 8, 2023

Visualization of Healthcare Indicators – Institutional Deliveries VS Available Delivery Points

 


Image Reference - https://www.pexels.com/photo/people-discuss-about-graphs-and-rates-3184292/


Generally, insightful visualizations express the hidden meaning within a given set of data. Data collected as healthcare indicators are no exception to this generalization. In this blogpost, an attempt is made to illustrate following two healthcare indicators by plotting in cartesian co-ordinates: -

  1. Institutional Delivery – Institutional Delivery be expressed as “Percentage of Institutional Deliveries with respect to estimated total Deliveries”  

  2. Delivery Points – Delivery Points be expressed as “Percentage of Delivery Points with respect to estimated requirements of Delivery Points”

Now, these indicators should include data from both public and private healthcare services. However, mostly, it is observed that such data are available only for public sector healthcare services. So for now, let us modify the above indicators to indicate public sector healthcare service provisioning. So, the above indicators may be considered as: -

  1. Institutional Delivery in Public Delivery Points in Percent (ID@PDP) – Institutional Delivery be expressed as “Percentage of Institutional Deliveries in Public Facilities with respect to Estimated Total Deliveries in Public Sector Facilities”  

  2. Public Delivery Points in Percent (PDP) – Delivery Points be expressed as “Percentage of Public Delivery Points Available with respect to estimated requirements of Public Delivery Points”

But, both the indicators could be collated for different hierarchies of geography within a state. Commonly used hierarchy of geography for a federal states in India (going smaller geography to larger geography) are as under: -

  1. Village

  2. Revenue Village

  3. Block

  4. Tehsil

  5. District

  6. Division

  7. State

Going with the administrative design, a block can be considered as the smallest geographical unit of governance for implementation of schemes or for understanding healthcare indicators. Keeping this in view we will consider that the above mentioned indicators are organized at block level. Thus, the indicators may be modified as: -

  1. Block Wise Institutional Delivery in Public Delivery Points in Percent (ID@PDP)

  2. Block Wise Public Delivery Points in Percent (PDP)

Keeping in mind the above discussions, let us attempt to plot the above indicators in cartesian co-ordinates.


Figure – 1: Institutional Deliveries in Public Facilities versus Available Public Delivery Point


It is evident from Figure – 1 that block wise utilization of public delivery facilities can be observed based on data visualization of the above mentioned two indicators. Assuming optimal utilization, the block with high PDP(%) and high ID@PDP(%) could be considered that nearly good number of PDPs are available to accommodate Institutional Deliveries taking place in the block under consideration. Similarly, assuming optimal utilization, the block with low PDP(%) and low ID@PDP(%) could be considered as having inadequate numbers of PDPs (Public Delivery points) to accommodate Institutional Deliveries taking place in any block falling in this region of cartesian co-ordinates as plotted above. A low PDP(%) and high ID@PDP(%) may mean that the PDPs are stretching beyond the capacity to accommodate Institutional Deliveries taking place in any block. And a high PDP(%) and low ID@PDP(%) may mean that the PDPs are remaining under utilized despite catering to Institutional Deliveries taking place in any block.

However, while doing the above analysis (as depicted in Figure -1), the assumptions are as under: -

  1. For every block, an estimate for (Total) Deliveries (usually based on demographic data and fertility rate) is accurate.

  2. Only a percent of estimated (Total) Deliveries as above may avail the services of Public Sector facilities. This percent is assumed to be chosen correctly. And, thus, the estimated total Delivery in Public Delivery Points is reasonably close to real value.

  3. Non-Institutional deliveries are suitably factored.

  4. All Institutional Deliveries taking place in Public Sector facilities are recorded accurately.    

  5. PDPs are largely similar with nearly the same size and capacity as average taken into account for every block.


Figure – 2: An Imaginary Example for comparing Institutional Deliveries in Public Facilities versus Available Public Delivery Point for blocks of two divisions


In Figure-2, an illustration of two imaginary divisions having contrasting PDPs is shown. This is just to explain the point made above through an example, which may not be very unlikely to find in real data pertaining to two different divisions located within one (or different) federal state of India.


/**********************************/