KERALA HEALTH INFORMATICS - DASHBOARD MODULE

PROJECT REPORT

Submitted by

KARTHIK DAYANAND
KMC23MCA-2014

to

the APJ Abdul Kalam Technological University in partial fulfillment of the requirements
for the award of the Degree

of

Master of Computer Applications

Department of Management Studies & Computer Applications

KMCT College of Engineering

Kallanthode, NITC P.O, Kozhikode-673601

APRIL 2025
 DECLARATION

I undersigned hereby declare that the project report “KERALA HEALTH INFORMAT-
ICS -DASHBOARD MODULE ”, submitted for partial fulfillment of the requirements
for the award of degree of Master of Computer Applications of the APJ Abdul Kalam
Technological University, Kerala is a bonafide work done by me under supervision of
Ms. Resmi SR. This submission represents my ideas in my own words and where ideas or
words of others have been included, I have adequately and accurately cited and referenced
the original sources. I also declare that I have adhered to ethics of academic honesty and
integrity and have not misrepresented or fabricated any data or idea or fact or source in my
submission. I understand that any violation of the above will be a cause for disciplinary ac-
tion by the institute and/or the University and can also evoke penal action from the sources
which have thus not been properly cited or from whom proper permission has not been
obtained. This report has not been previously formed the basis for the award of any degree,
diploma or similar title of any other University.

Place: Kallanthode KARTHIK DAYANAND

Date:
DEPARTMENT OF MANAGEMENT STUDIES & COMPUTER APPLICATIONS

KMCT COLLEGE OF ENGINEERING

Kallanthode, NITC P.O, Kozhikode-673601

CERTIFICATE

This is to certify that the report entitled KERALA HEALTH INFORMATICS - DASH-
BOARD MODULE submitted by KARTHIK DAYANAND (KMC23MCA-2014) to the
APJ Abdul Kalam Technological University in partial fulfillment of the requirements for
the award of the Degree of Master of Computer Applications is a bonafide record of the
project work carried out by him under our guidance and supervision. This report in any
form has not been submitted to any other University or Institute for any purpose.

Internal Supervisor Project Coordinator

External Examiner Head of the Department

 ACKNOWLEDGEMENT

I would like to take this opportunity to extend my sincere thanks to people who helped me
to make this project possible. This project will be incomplete without mentioning all the
people who helped me to make it real.

First and foremost I thank Dr. Sabiq PV (Principal, KMCT College of Engineering)
who gave me all support to this project. I also thank Dr. Shamla NK (Dean, KMCT
School of Business), Mr. Ajayakumar KK (Head of the Department, MCA) for provid-
ing all the facilities and resources for my project. I would also like to express my gratitude
towards Ms. Remmya CB(Assistant Professor, MCA) and Ms. Athulya Prabhakaran
(Assistant Professor, MCA) Project Coordinators as well as Ms. Resmi SR (Assistant
Professor, MCA) Project Guide for their continuous support, guidance and supervision
without which the project wouldn’t have been a reality. I would also take this opportunity
to thank all my friends who took time out of their busy schedule to encourage, support and
motivate me which has been the key reason for the successful completion of this project.

Above all I thank God, the almighty for his grace without which it would not have been
possible to complete this work on time.

i
 ABSTRACT

The Kerala Public Health Dashboard is designed to modernize the healthcare system by in-
tegrating advanced data analytics for efficient monitoring and management. This initiative
focuses on enhancing real-time decision-making for health officials by aggregating data
from multiple sources, covering epidemiology, resource management, and emergency re-
sponse. The dashboard incorporates predictive analytics, enabling early detection of health
trends and ensuring prompt intervention.

Currently, health data management in Kerala relies on fragmented systems, leading to in-
efficiencies and delays in accessing crucial insights. The absence of an integrated health
monitoring system creates operational bottlenecks, limiting overall responsiveness to health
crises. Additionally, the lack of user-friendly dashboards affects data interpretation, reduc-
ing the effectiveness of health policies and interventions.

To address these challenges, this project aims to implement a unified AI-driven dashboard
that enhances accessibility and usability. Leveraging real-time data processing, interac-
tive charts, and automated analytics, the system enables health officials to visualize key
performance indicators (KPIs) effectively. This approach ensures accuracy in health data
reporting and optimizes resource allocation across hospitals and clinics.

The dashboard will also streamline healthcare coordination by integrating patient records,
facility management, and outbreak tracking into a centralized platform. AI-powered au-
tomation minimizes manual data entry efforts, ensuring efficiency and reducing human
error. The platform’s intuitive design supports better engagement among healthcare pro-
fessionals, promoting informed decision-making and proactive health interventions.

This project represents a significant advancement in Kerala’s public health sector, trans-
forming how data is collected, analyzed, and utilized.

ii
 Contents

ACKNOWLEDGEMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i
ABSTRACT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ii
LIST OF TABLES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v
LIST OF FIGURES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vi
ABBREVIATIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Chapter 1 INTRODUCTION 1
1.1 General Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.2 Objective . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.3 Scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Chapter 2 LITERATURE SURVEY 4
Chapter 3 SYSTEM ANALYSIS 6
3.1 Existing System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
3.2 Proposed System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
3.3 Module Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
3.3.1 Data Collection Ingestion . . . . . . . . . . . . . . . . . . . . . . 11
3.3.2 Data Processing Integration . . . . . . . . . . . . . . . . . . . . . 11
3.3.3 Visualization Reporting Modules . . . . . . . . . . . . . . . . . . 11
3.3.4 User Management Security . . . . . . . . . . . . . . . . . . . . . 12
3.4 Feasibility Study . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
3.4.1 Operational Feasibility . . . . . . . . . . . . . . . . . . . . . . . . 12
3.4.2 Technical Feasibility . . . . . . . . . . . . . . . . . . . . . . . . . 13
3.4.3 Economic Feasibility . . . . . . . . . . . . . . . . . . . . . . . . . 13
3.5 System Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

iii
 3.5.1 Developer Requirement . . . . . . . . . . . . . . . . . . . . . . . 14
3.5.2 User Requirement . . . . . . . . . . . . . . . . . . . . . . . . . . 14
3.6 Actors and their Roles . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
3.6.1 Admin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
3.6.2 Health Official . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
3.6.3 Data Analyst . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
3.6.4 User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Chapter 4 SYSTEM DESIGN 17
4.1 Methodology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
4.2 UML Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
4.2.1 Use case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
4.2.2 Activity Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
4.2.3 Class Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
4.3 User Story . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
4.4 Product Backlog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
4.5 Project Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
4.6 Database Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
4.6.1 Users Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
4.6.2 Health Data Table . . . . . . . . . . . . . . . . . . . . . . . . . . 28
4.6.3 Health Metrics Table . . . . . . . . . . . . . . . . . . . . . . . . . 29
4.6.4 Geospatial Data Table . . . . . . . . . . . . . . . . . . . . . . . . 30
4.6.5 Notifications Table . . . . . . . . . . . . . . . . . . . . . . . . . . 31
4.6.6 KPI Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
4.6.7 Facilities Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
4.6.8 Vaccination Data Table . . . . . . . . . . . . . . . . . . . . . . . . 34
4.6.9 Mortality Data Table . . . . . . . . . . . . . . . . . . . . . . . . . 35
4.6.10 Historical Data Table . . . . . . . . . . . . . . . . . . . . . . . . . 36
4.7 User Interface Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
4.7.1 Home Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
4.7.2 State Healthcare Dashboard . . . . . . . . . . . . . . . . . . . . . 38

iv
 4.7.3 Regional Distribution . . . . . . . . . . . . . . . . . . . . . . . . 39
4.7.4 Trend analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
4.7.5 Statistics Summary . . . . . . . . . . . . . . . . . . . . . . . . . . 41
4.7.6 Regional Comparison . . . . . . . . . . . . . . . . . . . . . . . . . 42
Chapter 5 TESTING AND IMPLEMENTATION 43
5.1 Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
5.1.1 Test Case-Sprint 1 . . . . . . . . . . . . . . . . . . . . . . . . . . 43
5.1.2 Test Case-Sprint 2 . . . . . . . . . . . . . . . . . . . . . . . . . . 44
5.1.3 Test Case-Sprint 3 . . . . . . . . . . . . . . . . . . . . . . . . . . 45
5.1.4 Test Case-Sprint 4 . . . . . . . . . . . . . . . . . . . . . . . . . . 46
5.2 Implementation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47
5.2.1 Deployment Environment . . . . . . . . . . . . . . . . . . . . . . 47
5.2.2 Software Installation . . . . . . . . . . . . . . . . . . . . . . . . . 47
5.2.3 Backend Development . . . . . . . . . . . . . . . . . . . . . . . . 48
5.2.4 Frontend Development . . . . . . . . . . . . . . . . . . . . . . . . 48
5.2.5 Deployment and Training . . . . . . . . . . . . . . . . . . . . . . 48
5.2.6 Maintenance and Monitoring . . . . . . . . . . . . . . . . . . . . . 49
5.2.7 Continuous Improvement . . . . . . . . . . . . . . . . . . . . . . . 49
Chapter 6 RESULT AND DISCUSSION 50
Chapter 7 CONCLUSION 51
7.1 Future Work . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
REFERENCES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
APPENDICES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

v
 List of Tables

4.1 User story . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22

4.2 Product Backlog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
4.3 Project Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
4.4 Users Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
4.5 Health Data Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
4.6 Health Metrics Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
4.7 Geospatial Data Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
4.8 Notifications Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
4.9 KPI Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
4.10 Facilities Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
4.11 Vaccination Data Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
4.12 Mortality Data Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
4.13 Historical Data Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

5.1 Test Case Sprint 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

5.2 Test Case Sprint 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
5.3 Test Case-Sprint 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
5.4 Test Case-Sprint 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46

vi
 List of Figures

4.1 Use case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

4.2 Activity Diagram: Dashboard Activity diagram . . . . . . . . . . . . . . . 19
4.3 Class Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
4.4 Home Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
4.5 Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
4.6 Regional Distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
4.7 Trend analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
4.8 Statistics Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
4.9 Regional Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42

vii
 ABBREVIATIONS

API Application Programming Interface

e.g. exempli gratia - Latin for ”for example”

CSRF Cross-Site Request Forgery

EHR Electronic Health Record

MySQL My Structured Query Language

viii
 Chapter 1

INTRODUCTION

The Kerala Health Informatics Project, developed in collaboration with the Centre for
Development of Imaging Technology (C-DIT), Kerala, is an online system that provides
a detailed overview of the state’s healthcare network. Designed as a comprehensive digital
solution, the platform offers real-time data on healthcare facilities, medical services, and
public health trends, ensuring accessibility for both citizens and policymakers. The system
enables users to retrieve key details, such as the number of healthcare institutions, hospital
capacities, available medical resources, and health performance indicators.

The platform enables users to track district-wise health statistics, including mortality rates,
vaccination coverage, and disease prevalence. It also integrates with government databases
to present real-time updates on hospital resources like bed availability, medical equipment,
and healthcare workforce distribution. Predictive analytics help anticipate health crises and
resource shortages, improving decision-making. To enhance accessibility, support centers
in rural areas assist individuals with limited internet access in navigating the system and
retrieving necessary information.

The Kerala Health Informatics Project represents a major step forward in Kerala’s public
health infrastructure. Through its collaboration with C-DIT, the system not only enhances
healthcare transparency but also streamlines data management and decision-making pro-
cesses, ultimately improving health outcomes for the state’s population.

1
1.1 General Background

The general background of the Kerala Health Project highlights the increasing need for
a centralized and data-driven approach to managing public health information. In tradi-
tional systems, healthcare data was often scattered, difficult to access, and lacked real-time
updates, making it challenging for policymakers, researchers, and citizens to obtain reli-
able insights. With the growing emphasis on digital health initiatives, an integrated health
information system provides a structured and accessible way to track hospital capacities,
disease prevalence, vaccination coverage, and other key health indicators. This system en-
ables users to explore district-wise health statistics, monitor trends, and make informed
decisions based on real-time data. It enhances coordination among healthcare institutions,
ensuring that resources are allocated efficiently and services are delivered effectively. By
digitizing the process, the platform reduces administrative burdens, improves transparency,
and strengthens public health planning, leading to better healthcare outcomes and a more
responsive healthcare system.

1.2 Objective

The objective of the Kerala Health Project is to provide a centralized, user-friendly platform
for accessing comprehensive health data and statistics across the state. The project aims
to enhance accessibility by allowing policymakers, healthcare professionals, and citizens
to easily explore hospital capacities, disease prevalence, vaccination rates, and other key
health metrics. Transparency is a primary focus, ensuring that real-time updates on public
health trends and hospital resources are readily available to all stakeholders. Additionally,
the system promotes accountability by integrating with government health departments,
ensuring accurate data reporting and informed decision-making. The project also seeks to
improve efficiency by streamlining data collection, enabling faster analysis and resource
allocation. To bridge the digital divide, local service centers assist individuals in rural and
remote areas in accessing health-related information, ensuring that vital healthcare insights
are available to everyone, regardless of their location or digital literacy.

2
1.3 Scope

The scope of the Kerala Health Project encompasses the development, deployment, and
continuous enhancement of a comprehensive digital healthcare platform aimed at improv-
ing healthcare service delivery, resource allocation, and public health monitoring across
the state. The platform is designed to serve as a centralized hub for collecting, processing,
and analyzing healthcare data, ensuring real-time insights into various facets of the state’s
healthcare system.
The system will cover a broad spectrum of public health services, offering detailed and
structured information on hospital capacities, available medical resources, disease preva-
lence, vaccination coverage, epidemiological trends, and other crucial health performance
indicators. The platform will aggregate data from multiple sources, including government
health reports, real-time updates from hospitals and clinics, national health surveys, and
community health assessments. By leveraging these diverse sources, the system aims to
provide an accurate, up-to-date, and holistic view of the state’s healthcare landscape.
One of the key objectives of this project is to facilitate seamless collaboration between gov-
ernment health departments, hospitals, clinics, and other stakeholders. The platform will
enable efficient coordination and data-sharing among various healthcare entities, fostering
better communication and informed decision-making. Additionally, mechanisms will be
put in place to ensure data privacy, security, and compliance with relevant healthcare regu-
lations and standards.
To enhance accessibility and inclusivity, the project also prioritizes support for individuals
in rural and remote areas who may have limited digital access. Physical service centers and
community outreach programs will be established to assist people in obtaining healthcare
information and navigating the digital platform effectively. Moreover, mobile-friendly ap-
plications and multilingual support will be incorporated to ensure ease of use for a diverse
population.

3
 Chapter 2

LITERATURE SURVEY

The integration of advanced data analytics into public health systems has revolutionized the
monitoring and management of community health. According to Kumar et al. (2023) [1],
implementing real-time data dashboards enables health officials to promptly identify and
respond to emerging health trends, thereby enhancing the effectiveness of public health
interventions. These dashboards aggregate data from various sources, providing a com-
prehensive view of health metrics across different regions. Similarly, Sharma and Iyer
(2024) [2] emphasize that user-friendly interfaces in health data dashboards facilitate bet-
ter engagement among health professionals, leading to more informed decision-making
and improved patient outcomes. Their study indicates that intuitive design elements, such
as customizable views and interactive charts, significantly enhance the usability of health
information systems.

The book Healthcare Data Analytics and Visualization by Nair and Menon (2023) [1] pro-
vides a comprehensive insight into the role of data-driven dashboards in improving public
health decision-making. It highlights how integrating various health departments, such
as epidemiology, resource management, and emergency response, into a unified system
enhances data accessibility and coordination, ultimately improving healthcare efficiency.
In Digital Health Technologies in Public Administration by Rajan (2024) [2], the author
discusses the impact of interactive dashboards in analyzing large-scale health data. The
book explores how real-time data visualization aids health officials in tracking disease out-

4
breaks, managing hospital resources, and optimizing health service delivery. Additionally,
the website [Link] (2025) [3] examines the practical benefits of using AI-
driven dashboards in healthcare administration. The site emphasizes how these systems
improve decision-making by providing predictive analytics, reducing manual workload,
and enhancing collaboration between government agencies and healthcare providers. AI-
powered dashboards are recognized as a transformative tool in streamlining health data
management and ensuring more efficient public health responses

In addition, according to Nair and Krishnan (2023) [4], AI-driven dashboards are increas-
ingly being used to manage health data analytics, providing time-saving benefits and ensur-
ing accuracy in decision-making. Menon and Pillai (2022) [5] report that integrated health
management systems improve efficiency by combining clinical data with administrative
insights, reducing response times, and enhancing healthcare service quality. Thomas et al.
(2021) [6] emphasize the role of interactive data visualization in empowering health offi-
cials with real-time insights, reducing manual reporting efforts. Ramesh and Gupta (2020)
[7] found that incorporating predictive analytics into public health dashboards improves re-
source allocation and emergency preparedness. Finally, Bhatia and Rao (2021) [8] discuss
how AI-driven automation enhances health data management by streamlining reporting and
improving accuracy in health monitoring systems.

Moreover, recent studies highlight the transformative impact of digital tools in public health
management. According to Joseph and Varma (2023) [9], cloud-based health dashboards
facilitate seamless data access and sharing across departments, fostering better coordina-
tion and faster decision-making. Iyer and Sreedhar (2022) [10] note that mobile-compatible
dashboards are enabling field health workers to input real-time data, improving the respon-
siveness of health interventions. Das and Nambiar (2021) [11] underline the importance of
integrating GIS mapping with health dashboards to identify disease hotspots and plan tar-
geted responses effectively. Meanwhile, Fernandes and Kumar (2020) [12] argue that cus-
tomizable dashboards enhance usability for different stakeholders, allowing tailored views
for administrators, analysts, and frontline workers.

5
 Chapter 3

SYSTEM ANALYSIS

3.1 Existing System

The Kerala Health Dashboard system aims to provide a centralized platform for monitoring
and managing key health metrics across the state. Currently, health officials and adminis-
trators rely on fragmented data sources and manual reporting processes, which pose sig-
nificant challenges in efficiency and accuracy. One of the primary issues with the existing
system is the lack of real-time data integration, leading to delays in decision-making and
resource allocation. For instance, public health officials often struggle to access up-to-date
information on hospital resource availability, disease prevalence, and vaccination cover-
age. Additionally, manual data entry increases the risk of errors, resulting in inconsisten-
cies across different reports and departments. The absence of an interactive dashboard with
automated analytics further complicates efforts to track trends, generate reports, and imple-
ment timely health interventions. The Kerala Health Dashboard is designed to address these
challenges by offering a user-friendly interface with real-time data visualization, predictive
analytics, and automated reporting, ensuring a more efficient and data-driven approach to
public health management.

Moreover, the current health data management system lacks real-time data synchroniza-
tion, which is a critical component of an effective public health dashboard. Without this
functionality, health officials and administrators are unable to access the most up-to-date

6
statistics on hospital resources, disease outbreaks, or vaccination progress. This often re-
sults in delayed responses to emerging health crises and inefficient allocation of medical
resources. Additionally, the absence of automated data updates leads to inconsistencies
in reports, requiring manual corrections that consume valuable time and effort. These in-
efficiencies not only slow down decision-making but also reduce the overall effectiveness
of public health interventions, impacting the quality of healthcare services provided to the
community.

n addition to the limitations in real-time data synchronization, the current public health
management system in Kerala is not fully integrated across various health departments and
administrative units. Different sectors, such as hospitals, primary health centers, disease
surveillance teams, and resource management authorities, operate on separate platforms,
lacking seamless communication and data sharing. This fragmentation creates significant
inefficiencies, as officials must manually compile reports from multiple sources, increasing
the risk of data inconsistencies and delays in decision-making. For example, hospitals may
struggle to update bed availability in real-time, leading to challenges in emergency patient
transfers. Similarly, vaccination tracking systems may not be directly linked with disease
surveillance databases, making it difficult to analyze immunization coverage in high-risk
areas effectively. Without a unified dashboard that consolidates data from various health
services, efforts to monitor and improve public health outcomes remain slow and resource-
intensive.

The lack of integration between health departments and administrative functions further
complicates the management of public health data. Each department operates in isolation,
maintaining separate records for hospital resources, disease tracking, vaccination data, and
patient outcomes. This disjointed approach leads to data inconsistencies, redundancies,
and difficulties in tracking patient progress across different health services. For instance,
when a patient’s case is transferred from a primary health center to a hospital, there is often
a delay in updating critical health information, which can result in gaps in patient care
and miscommunication between medical teams. This lack of seamless data flow not only
affects the quality of healthcare delivery but also burdens hospital staff, who are forced to

7
spend extra time manually cross-referencing and searching for patient data.

Additionally, the existing system does not offer an integrated solution for efficiently man-
aging public health resources, such as hospital bed availability, medical staff schedules, and
supplies. Health officials and administrators have limited visibility into real-time resource
status, leading to scheduling conflicts, overburdened staff, and inefficient distribution of
resources. These inefficiencies cause delays in patient care, longer waiting times, and an
increased administrative burden, all of which contribute to lower overall healthcare service
quality. A unified, data-driven dashboard system would address these issues by offering
real-time updates and providing better resource allocation and management tools.

The current public health management system in Kerala faces several challenges, includ-
ing the lack of real-time data updates, limited integration between various health depart-
ments, and inefficient resource management. Health officials struggle with accessing up-to-
date information, and data inconsistencies between departments lead to delays in decision-
making and resource allocation. These limitations hinder the ability to respond quickly
to emerging health issues and negatively affect patient care. This project aims to replace
the fragmented system with an integrated AI-powered dashboard that offers real-time data
synchronization, predictive analytics, and automated reporting. The new system will pro-
vide seamless integration between health departments, offer better visibility into hospital
resources, and streamline decision-making processes. By improving data accuracy and
operational efficiency, this project aims to enhance public health management, ultimately
improving patient outcomes across Kerala.

3.2 Proposed System

The proposed system for Kerala’s health management aims to address the challenges of
fragmented data and inefficiencies across departments by implementing modern techno-
logical solutions. Central to this system is the development of an AI-powered dashboard
that will consolidate data from various health departments and provide real-time insights,
predictive analytics, and reporting. This unified system will streamline the workflow, re-
duce errors, and improve coordination, ultimately enhancing both operational efficiency
and patient care quality across Kerala.

8
One of the key features of the proposed system is the real-time data aggregation and visu-
alization capabilities. The AI-powered dashboard will allow health officials to view health
metrics, disease prevalence, vaccination data, hospital resource allocation, and KPIs across
multiple districts. This system will provide a centralized platform for tracking trends, gen-
erating reports, and making data-driven decisions to improve health outcomes. By elimi-
nating silos of information, the system will enhance coordination between the healthcare
departments, making it easier to respond to public health needs in real-time.

The proposed system will also integrate predictive analytics to help health officials antic-
ipate trends in disease outbreaks, mortality rates, and resource requirements. By utilizing
historical data, the system will offer forecasts and insights into future health risks, enabling
the timely deployment of resources. This will significantly improve the ability to respond
proactively to public health emergencies, improving patient outcomes and optimizing re-
source allocation.

A critical feature of the system will be the ability to monitor and manage health facility
resources efficiently. Health officials will be able to track hospital bed availability, medical
supplies, and staff schedules in real-time. This feature will help prevent overbooking, min-
imize patient wait times, and ensure equitable distribution of resources across regions. The
system will also allow hospitals to update their resource availability dynamically, ensuring
real-time visibility for better planning and coordination.

The system will feature both a web-based interface for health officials and hospital admin-
istrators and a mobile application for the public to access essential health services. The
web interface will enable officials to monitor health metrics, track resources, and generate
reports. The mobile app will allow users to access health data, receive updates on disease
prevention, and find nearby healthcare facilities. This multi-platform approach will ensure
that the system is accessible to a wide range of users, from policymakers to citizens.

The implementation of the proposed system will follow a structured approach, starting
with the development and integration of the AI-powered dashboard and predictive ana-
lytics models. After integration, the system will undergo extensive testing to ensure data

9
accuracy, real-time functionality, and seamless user experience. Testing will also include
feedback from health officials and administrators to ensure the system’s effectiveness in
real-world scenarios. Upon completion of testing, the system will be deployed across
Kerala’s health departments, followed by continuous monitoring and updates to address
emerging needs.

Overall, the proposed system offers several advantages, including enhanced decision-making
capabilities, improved operational efficiency, and better coordination between healthcare
departments. By leveraging AI and real-time data insights, the system will improve patient
care, optimize resource allocation, and position Kerala as a leader in data-driven public
health management. The implementation of this unified health management system will
provide a more efficient, proactive, and patient-centered approach to healthcare delivery
across the state.

In addition to improving internal healthcare operations, the proposed system will also sup-
port data transparency and public trust. By providing citizens with access to verified health
statistics and updates through the mobile application, the system will empower commu-
nities with knowledge about ongoing health initiatives, vaccination drives, and prevalent
diseases in their area. Transparent data sharing will encourage community participation,
increase awareness, and promote responsible health behaviors. Furthermore, the system
will enable real-time alerts during public health emergencies such as disease outbreaks or
natural disasters, ensuring timely dissemination of critical information to both officials and
the public.

Another significant advantage of the system is its potential to support health policy planning
and evaluation. With comprehensive data collection and advanced analytics, policymakers
will be equipped to assess the effectiveness of existing health programs and design new
initiatives tailored to district-specific needs. Longitudinal data tracking will help identify
gaps in service delivery, monitor improvements over time, and support evidence-based pol-
icymaking. This data-driven approach will contribute to a more equitable health system,
ensuring that under-served regions receive adequate attention and resources, and strength-
ening the overall resilience of Kerala’s healthcare infrastructure.

10
3.3 Module Description

3.3.1 Data Collection Ingestion

Data Sources: The system will integrate various data sources, such as hospital records, gov-
ernment health databases, and public health surveys, to ensure comprehensive data collec-
tion. These sources will be identified and linked to the central system for seamless access
and real-time data [Link] Processes An efficient ETL (Extract, Transform, Load)
process will be set up to ensure the data from different sources is standardized, cleansed,
and accurately loaded into the system. This will guarantee that all data is consistent and of
high quality before further processing.

3.3.2 Data Processing Integration

Cleaning Validation: The collected data will be processed to remove errors, inconsisten-
cies, or duplicates. This step will ensure that the dataset remains accurate and reliable
for [Link] Aggregation Data from multiple sources will be combined into a
unified dataset, which will be essential for generating insightful analysis. This aggregation
will help provide a holistic view of the healthcare status across the state.

3.3.3 Visualization Reporting Modules

Dashboard Visualizations: The system will feature a set of dynamic visualizations, such as
charts, graphs, heatmaps, and other tools, to clearly present health data. These visualiza-
tions will simplify the understanding of complex health statistics for various stakeholders.
Interactive Reports Users will have the ability to interact with the data, drilling down into
specific areas like district-level health metrics or hospital performance. This functionality
will allow for deeper exploration of data to uncover key insights. Customizable Views Dif-
ferent user roles (public users, health officials, administrators) will have access to tailored
data views that meet their specific needs. This customization will ensure that relevant in-
formation is easily accessible to each user group.

11
3.3.4 User Management Security

Access Control: Strict user roles and permissions will be defined to control access to sensi-
tive health data. This will ensure that only authorized personnel can access certain levels of
information, maintaining privacy and [Link] The system will incorporate
strong authentication mechanisms to confirm the identity of users before granting access to
the platform. This is critical for safeguarding patient and hospital data.

3.4 Feasibility Study

The feasibility study evaluates the practicality of implementing the Kerala Health Dash-
board. This system aims to collect, process, and visualize health data from various sources
to improve healthcare delivery in Kerala. The study examines technical, operational, eco-
nomic, and legal considerations to ensure the proposed system can be successfully inte-
grated and provide value to health officials, administrators, and the public.

3.4.1 Operational Feasibility

The proposed Kerala Health Dashboard will centralize health-related data, enabling real-
time insights into key health metrics, disease prevalence, vaccination rates, and hospital
performance. By integrating various data sources, such as hospital records, public health
surveys, and government health databases, the system will provide health officials and ad-
ministrators with the necessary tools for informed decision-making. The dashboard will
offer interactive reports and visualizations, allowing users to drill down into specific data
for districts, hospitals, or departments. Given Kerala’s strong digital infrastructure and the
growing adoption of technology in healthcare, the operational feasibility is high. Stake-
holders will be trained to use the system, ensuring a smooth transition to the new platform.

12
3.4.2 Technical Feasibility

The Kerala Health Dashboard will be technically feasible given the state’s existing digital
health infrastructure. The dashboard will leverage data from various sources, which will
be processed, cleaned, and integrated using modern ETL (Extract, Transform, Load) pro-
cesses. Data will be aggregated to create comprehensive datasets for analysis. The system
will use advanced analytics, including statistical analysis, trend forecasting, and geo-spatial
mapping, to track health trends and resource utilization. The use of cloud technologies will
ensure scalability, real-time data processing, and seamless updates. Additionally, the dash-
board will be accessible via both web-based interfaces for health administrators and mobile
apps for the public, ensuring wide accessibility and ease of use.

3.4.3 Economic Feasibility

The economic feasibility of the Kerala Health Dashboard is favorable, as it is expected

to bring significant long-term cost savings to the healthcare system. By centralizing and
automating the collection and analysis of health data, administrative workloads will be re-
duced. The dashboard will help health officials make more informed decisions, improving
resource allocation and healthcare service efficiency. The system will also enable early
detection of health trends and potential outbreaks, which could help in preventing costly
public health crises. The initial investment in system development and infrastructure will
be offset by reduced operational costs and improved healthcare delivery, making the project
financially sustainable in the long term.

13
3.5 System Environment

3.5.1 Developer Requirement

[Link] Hardware Requirement

• Processor : Intel Core i5 or above

• Ram : 8 GB or above

• Storage : 500GB Hard disk

[Link] Software Requirement

• Operating system : Windows 8 or above

• Front end : React JS

• Back end : Laravel,PHP

• Database : Mysql

• IDE : Visual Studio

• Web browser : Google Chrome/Firefox

3.5.2 User Requirement

• Any smartphone/Computer/ Laptop

• Stable internet Access

14
3.6 Actors and their Roles

3.6.1 Admin

The Admin is responsible for overseeing and managing the overall system.

• Manage user accounts (Health Official, Data Analyst, User)

• Monitor system analytics and generate reports

• Configure system settings and notifications

• Approve data submissions and reports from Health Officials and Data Analysts

• Generate and view performance reports

3.6.2 Health Official

Health Officials are responsible for monitoring and analyzing health-related data.

• Monitor health data and trends (disease prevalence, vaccination rates, etc.)

• Generate public health reports based on collected data

• Coordinate with the Admin to ensure data accuracy

• Share updates about health-related issues and guide the public in emergencies

3.6.3 Data Analyst

Data Analysts work with the collected health data to extract actionable insights.

• Aggregate and clean health data from various sources

• Perform statistical analysis to determine key health indicators (e.g., incidence rates,
mortality rates)

• Analyze trends and make forecasts related to health metrics

15
 • Conduct geo-spatial analysis to identify patterns across regions

• Present data visualizations and reports to Health Officials and Admin

3.6.4 User

Users are typically members of the public or patients who interact with the dashboard to
access health information.

• View general health data (disease prevalence, vaccination statistics, etc.)

• Book and manage appointments with health facilities

• Make payments for healthcare services

• Submit feedback, complaints, or suggestions related to the system or services

• Access interactive health reports based on personal or regional data

16
 Chapter 4

SYSTEM DESIGN

4.1 Methodology

This project adopts the Agile methodology for system design. Agile focuses on iterative
development, where requirements and solutions evolve through continuous collaboration
among cross-functional teams and stakeholders. This approach encourages adaptive plan-
ning, early delivery, and continuous improvement, allowing for flexibility in responding to
changes. By breaking the development process into smaller, manageable tasks, the project
can be adjusted based on feedback, ensuring that the system meets the needs of both the
hospital staff and patients. Agile promotes frequent testing, close communication, and
quick adjustments, resulting in a more responsive and efficient system that aligns with user
expectations and operational requirements. Moreover, Agile fosters an environment of col-
laboration, where all team members actively contribute to decision-making processes and
solutions evolve in real-time. This methodology is particularly beneficial for complex sys-
tems like a Hospital Management System, as it allows for regular updates and refinements,
ensuring that the system remains aligned with the hospital’s dynamic needs throughout its
development and beyond.

17
4.2 UML Diagrams

4.2.1 Use case

Figure 4.1: Use case

18
4.2.2 Activity Diagram

Figure 4.2: Activity Diagram: Dashboard Activity diagram

19
4.2.3 Class Diagram

Figure 4.3: Class Diagram

20
4.3 User Story

User As a <Type of I want to <Perform So that I can <Achieve

story Users > some task > some goal >
ID
1 New user Register an account Access the Kerala Health
dashboard
2 Registered user Log in securely to my Access personalized health
account data and features
3 Registered user View an overview dash- Quickly assess overall health
board with key health trends in Kerala
metrics
4 Health official Filter and sort dash- Analyze localized health
board data by re- trends effectively
gion/district
5 Health official Drill down into detailed Understand underlying pat-
reports for specific indi- terns and support decision-
cators making
6 Data analyst Interact with dynamic Explore correlations and
charts and graphs trends over time
7 Health official View geospatial maps Visualize regional variations
representing data distri- and identify hotspots
butions
8 Registered user Customize the dash- Tailor the interface to my spe-
board layout and cific needs
widgets

21
User As a <Type of I want to <Perform So that I can <Achieve
story Users > some task > some goal >
ID
9 Health official Receive real-time alerts Act promptly on significant
and notifications health events or emergencies
10 Admin Manage user roles and Ensure data security and
permissions on the proper access control
dashboard
11 Data analyst Export dashboard re- Share insights with col-
ports in various formats leagues and stakeholders
(PDF, CSV, etc.)
12 Registered user Compare historical data Identify trends and measure
with current metrics the effectiveness of interven-
tions

Table 4.1: User story

22
4.4 Product Backlog

User Priority Size Sprint Status Release Release Goal

Story (Low, (Planned, Date
ID High, Progressed,
Medium) Completed)
1 LOW 4 Completed 16-01-2025 Register an account
2 LOW 4 1 Completed 18-01-2025 Login to account
3 MEDIUM 6 Completed 19-01-2025 View an overview
dashboard with key
health metrics
4 MEDIUM 7 Completed 21-01-2025 Filter and sort dash-
board data by re-
gion/district
5 HIGH 9 2 Completed 23-01-2025 Drill down into
detailed reports for
specific indicators
6 MEDIUM 7 Completed 25-01-2025 Interact with dy-
namic charts and
graphs
7 MEDIUM 8 Completed 26-01-2025 View geospatial
maps representing
data distributions
8 MEDIUM 6 3 Completed 26-01-2025 Customize the dash-
board layout and
widgets

23
User Priority Size Sprint Status Release Release Goal
Story (Low, (Planned, Date
ID High, Progressed,
Medium) Completed)
9 HIGH 9 Completed 28-01-2025 Receive real-time
alerts and notifi-
cations
10 HIGH 10 Completed 30-01-2025 Manage user
roles and per-
missions on the
dashboard
11 MEDIUM 8 4 Completed 01-02-2025 Export dashboard
reports in various
formats (PDF,
CSV, etc.)
12 MEDIUM 6 Completed 03-02-2025 Compare histori-
cal data with cur-
rent metrics

Table 4.2: Product Backlog

24
4.5 Project Plan

User Task name Start date End date Days Status

story
ID
1 Register an ac- 15-02-2025 16-02-2025 2 Completed
count
2 Login to account 16-02-2025 18-02-2025 3 Completed
3 Manage user 18-02-2025 20-02-2025 3 Completed
roles and permis-
sions
4 Filter and sort 20-02-2025 22-02-2025 3 Completed
dashboard data
by region/district
5 Drill down into 22-02-2025 24-02-2025 3 Completed
detailed reports
for specific indi-
cators
6 Interact with dy- 24-02-2025 26-02-2025 3 Completed
namic charts and
graphs
7 View geospatial 26-02-2025 28-02-2025 3 Completed
maps repre-
senting data
distributions
8 Customize the 01-03-2025 03-03-2025 3 Completed
dashboard layout
and widgets

25
User Task name Start date End date Days Status
story
ID
9 Receive real-time 03-03-2025 05-03-2025 3 Completed
alerts and notifi-
cations
10 Export dashboard 05-03-2025 07-03-2025 3 Completed
reports in various
formats (PDF,
CSV, etc.)
11 Compare histori- 07-03-2025 09-03-2025 3 Completed
cal data with cur-
rent metrics
12 View user activity 09-03-2025 11-03-2025 3 Completed
reports and ana-
lyze engagement
trends

Table 4.3: Project Plan

26
4.6 Database Design

4.6.1 Users Table

The ”Users Table” is designed to store user information, including their credentials, roles,
and timestamps for creation and updates. Each entry in this table is uniquely identified by
the ”userid” field, which serves as the primary key. This table ensures secure handling of
user data and facilitates role-based access control within the system.

no. name type constraints description

1 user id int primary key, auto unique identifier for the
increment user (primary key)
2 username varchar(255) unique, not null username of the user
3 email varchar(255) unique, not null user’s email address
4 password varchar(255) not null user’s encrypted pass-
word
5 role enum not null, allowed: user’s role (admin,
admin, health of- health official, data
ficial, data ana- analyst, user)
lyst, user
6 created at timestamp default cur- timestamp when the
rent timestamp user was created

Table 4.4: Users Table

27
4.6.2 Health Data Table

The ”Health Data Table” stores health-related data for specific regions and districts. Each
entry is uniquely identified by the ”data id” field, which serves as the primary key. This
table links to the ”health metrics table” via the ”metric id” foreign key, enabling detailed
tracking of health metrics over time.

no. name type constraints description

1 data id int primary key, auto unique identifier for
increment health data entry (pri-
mary key)
2 region varchar(255) not null region for health data
(e.g., kerala, specific
districts)
3 district varchar(255) not null district under the region
4 metric id int not null, foreign foreign key: references
key the health metrics table
5 value decimal(10, 2) not null value of the health met-
ric
6 recorded at timestamp default cur- timestamp when the
rent timestamp data was recorded
7 updated at timestamp nullable timestamp of last up-
date to the data

Table 4.5: Health Data Table

28
4.6.3 Health Metrics Table

The ”Health Metrics Table” defines the health metrics tracked in the system. Each metric
is uniquely identified by the ”metric id” field, which serves as the primary key. This table
provides a standardized way to describe and reference health metrics across the system.

no. name type constraints description

1 metric id int primary key, auto unique identifier for
increment each health metric
(primary key)
2 metric name varchar(255) not null name of the health met-
ric (e.g., disease preva-
lence)
3 description text nullable description of the met-
ric
4 created at timestamp default cur- timestamp when the
rent timestamp metric was added

Table 4.6: Health Metrics Table

29
4.6.4 Geospatial Data Table

The ”Geospatial Data Table” stores location-based health data, including latitude and lon-
gitude coordinates. Each entry is uniquely identified by the ”geo id” field, which serves as
the primary key. This table links to the ”health metrics table” via the ”metric id” foreign
key, enabling spatial analysis of health metrics.

no. name type constraints description

1 geo id int primary key, auto unique identifier for
increment geospatial data (primary
key)
2 region varchar(255) not null region name (e.g., kerala,
district)
3 latitude decimal(9,6) not null latitude of the location
4 longitude decimal(9,6) not null longitude of the location
5 metric id int not null, foreign foreign key references the
key health metrics table
6 value decimal(10,2) not null value of the metric at the
specified location
7 recorded at timestamp default cur- timestamp when the data
rent timestamp was recorded

Table 4.7: Geospatial Data Table

30
4.6.5 Notifications Table

The ”Notifications Table” stores notifications sent to users. Each entry is uniquely identi-
fied by the ”notification id” field, which serves as the primary key. This table links to the
”users table” via the ”user id” foreign key, enabling personalized notifications.

no. name type constraints description

1 notification id int primary key, auto unique identifier for
increment notifications (primary
key)
2 user id int not null, foreign foreign key references
key the users table
3 message text not null content of the notifica-
tion
4 sent at timestamp default cur- timestamp when the no-
rent timestamp tification was sent
5 status enum not null, allowed: status of the notification
read, unread (e.g., read/unread)

Table 4.8: Notifications Table

31
4.6.6 KPI Table

The ”KPI Table” stores key performance indicators (KPIs) for the health dashboard. Each
entry is uniquely identified by the ”kpi id” field, which serves as the primary key. This
table enables tracking and analysis of critical health performance metrics.

no. name type constraints description

1 kpi id int primary key, auto unique identifier for the
increment kpi (primary key)
2 kpi name varchar(255) not null name of the kpi (e.g.,
mortality rate)
3 description text nullable description of the kpi
4 value decimal(10,2) not null value for the kpi
5 measured at timestamp default cur- timestamp when the kpi
rent timestamp was measured

Table 4.9: KPI Table

32
4.6.7 Facilities Table

The ”Facilities Table” stores information about healthcare facilities, including their type,
location, and available resources. Each entry is uniquely identified by the ”facility id” field,
which serves as the primary key. This table enables tracking of healthcare infrastructure
across regions.

no. name type constraints description

1 facility id int primary key, auto unique identifier for
increment healthcare facility
(primary key)
2 name varchar(255) not null name of the facility
(e.g., district hospital)
3 type enum not null, allowed: type of facility (e.g.,
health center, health center, hospital)
hospital
4 region varchar(255) not null region where the facil-
ity is located
5 district varchar(255) not null district where the facil-
ity is located
6 bed count int not null, ≥ 0 number of beds avail-
able at the facility
7 equipment text nullable available equipment at
the facility

Table 4.10: Facilities Table

33
4.6.8 Vaccination Data Table

The ”Vaccination Data Table” stores vaccination records, including the type of vaccine and
the number of doses administered. Each entry is uniquely identified by the ”vaccination id”
field, which serves as the primary key. This table enables tracking of vaccination efforts
across regions.

no. name type constraints description

1 vaccination id int primary key, auto unique identifier for
increment vaccination record
(primary key)
2 region varchar(255) not null region where the vacci-
nation data is recorded
3 district varchar(255) not null district where the vacci-
nation data is recorded
4 vaccine type varchar(255) not null type of vaccine admin-
istered (e.g., covid-19)
5 number administered int not null number of vaccines ad-
ministered
6 recorded at timestamp default cur- timestamp when the
rent timestamp data was recorded

Table 4.11: Vaccination Data Table

34
4.6.9 Mortality Data Table

The ”Mortality Data Table” stores data related to deaths, including the cause and number
of deaths. Each entry is uniquely identified by the ”mortality id” field, which serves as the
primary key. This table enables tracking of mortality trends across regions.

no. name type constraints description

1 mortality id int primary key, auto unique identifier for
increment mortality data (primary
key)
2 region varchar(255) not null region where the data is
recorded
3 district varchar(255) not null district where the data
is recorded
4 cause of death varchar(255) not null cause of death (e.g.,
disease, accident)
5 number of deaths int not null number of deaths due to
the cause
6 recorded at timestamp default cur- timestamp when the
rent timestamp data was recorded

Table 4.12: Mortality Data Table

35
4.6.10 Historical Data Table

The ”Historical Data Table” stores historical health data, enabling long-term trend analysis.
Each entry is uniquely identified by the ”historical id” field, which serves as the primary
key. This table tracks health indicators over time for specific regions and districts.

no. name type constraints description

1 historical id int primary key, auto unique identifier for
increment the historical data entry
(primary key)
2 region varchar(255) not null region where the data is
recorded
3 district varchar(255) not null district where the data
is recorded
4 health indicator varchar(255) not null the health indicator
being tracked (e.g., life
expectancy, disease
prevalence)
5 value decimal(10, 2) not null value of the health indi-
cator
6 recorded at timestamp default cur- timestamp when the
rent timestamp data was recorded

Table 4.13: Historical Data Table

36
4.7 User Interface Design

4.7.1 Home Page

A healthcare homepage for Kerala, designed to provide key insights into the state’s health-
care system. At the top, a dark-colored navigation bar displays the title ”Healthcare Tracker.”
Below it, a large, vibrant gradient banner serves as the main visual element, featuring the
bold text ”Empowering Healthcare in Kerala” along with a subtitle that states, ”Provid-
ing quality healthcare to every citizen.” This banner emphasizes the platform’s purpose of
improving healthcare accessibility and transparency. Beneath the banner, three neatly ar-
ranged statistic cards display crucial healthcare data: the total number of hospitals (150),
available hospital beds (7500), and the mortality rate (2.5

Figure 4.4: Home Page

37
4.7.2 State Healthcare Dashboard

A State Healthcare Dashboard is designed with a clean, user-friendly, and structured layout
to ensure that healthcare data is presented clearly and is easy to navigate. The dashboard
serves as a centralized platform for monitoring and analyzing key healthcare statistics rel-
evant to different regions within the state. On the left side of the interface, users will
find a vertical navigation panel that includes several clearly labeled sections such as Main,
Detailed Metrics, Regional Stats, and Summary. The Main section provides an overview
of important statistics and alerts. The Detailed Metrics section offers an in-depth look at
various healthcare indicators including bed occupancy rates, vaccination numbers, disease
trends, and hospital performance. The Regional Stats section presents data segmented by
district or region, enabling users to compare healthcare outcomes across different areas.
The Summary section delivers a concise report that highlights key takeaways and trends in
a simplified format suitable for quick review and decision-making.

Figure 4.5: Dashboard

38
4.7.3 Regional Distribution

The Regional Distribution section of the healthcare dashboard plays a vital role in providing
clear and actionable insights into how patients are distributed across various regions within
the state. This section is designed to help stakeholders understand regional healthcare
demands, resource utilization, and population health trends, allowing for better planning
and [Link] the left sidebar, users can access a well-organized set of navigation
options that help them move between different sections of the dashboard. These options
include the Main section, which offers an overview of key statistics; the Detailed Metrics
section, which dives deeper into specific healthcare data points; the Regional Stats section,
where the current Regional Distribution view is located; and the Summary section, which
presents a consolidated view of major findings. This intuitive layout ensures that users can
easily navigate the dashboard based on their specific needs.

Figure 4.6: Regional Distribution

39
4.7.4 Trend analysis

Trend analysis in the Kerala Health Dashboard UI focuses on visually representing health
data trends over time, making it easier for users to understand patterns and make informed
decisions. Key elements include time series data presented through interactive graphs like
line or bar charts to track metrics such as vaccination rates, disease prevalence, hospital
resource utilization, and mortality trends. The UI should allow users to filter data by time,
district, or health metric, with color coding and annotations to highlight key trends. For
role-specific insights, admins can access statewide trends, health officials can focus on
regional data, data analysts can delve into detailed trends, and users can view general health
updates in their area. This approach ensures all roles can effectively monitor and interpret
health statistics to support decision-making.

Figure 4.7: Trend analysis

40
4.7.5 Statistics Summary

A statistics summary in the Kerala Health Dashboard provides a concise overview of key
health data, presenting essential metrics and trends to help users quickly assess the health
status of the region. This summary typically includes aggregated statistics such as the to-
tal number of cases for specific diseases, vaccination coverage, mortality rates, available
healthcare resources (like beds and equipment), and KPIs (e.g., patient wait times or hos-
pital occupancy). It can also highlight recent changes, comparisons to previous periods,
and regional variations. The UI should display these statistics in an easy-to-understand
format, using numbers, percentages, and simple visual indicators (e.g., gauges, pie charts)
for quick interpretation. The goal is to offer an at-a-glance snapshot of the most important
health data, allowing users to make informed decisions or take necessary actions based on
the current health situation

Figure 4.8: Statistics Summary

41
4.7.6 Regional Comparison

Regional comparison in the Kerala Health Dashboard refers to the process of comparing
health data across different districts or regions within Kerala to identify trends, disparities,
and areas of concern. This feature enables users to evaluate how health metrics such as dis-
ease prevalence, vaccination rates, hospital resource availability, and mortality rates vary
between regions. The comparison can be presented through side-by-side charts, heat maps,
or bar graphs that highlight differences in key statistics, allowing health officials, admin-
istrators, and analysts to quickly spot regions with higher health risks, resource shortages,
or better health outcomes. By providing these insights, the dashboard helps in targeted
decision-making, resource allocation, and intervention planning to improve health condi-
tions in specific areas. For example, one region might show a spike in disease cases, while
another may have high vaccination coverage, prompting tailored health policies or actions.

Figure 4.9: Regional Comparison

42
 Chapter 5

TESTING AND IMPLEMENTATION

5.1 Testing

5.1.1 Test Case-Sprint 1

No. Date Action Expected Result Actual Result Pass?

1 20/03/2025 New user regis- Registration suc- Registration Yes
ters an account cessful; verifica- successful; email
(US1) tion email sent sent
2 20/03/2025 Registered user Secure login; Login successful; Yes
logs in with valid personalized dashboard acces-
credentials (US2) dashboard dis- sible
played
3 20/03/2025 Registered Dashboard dis- Metrics and Yes
user views the plays key health trends visible
overview dash- metrics and
board (US3) trends

Table 5.1: Test Case Sprint 1

43
5.1.2 Test Case-Sprint 2

No. Date Action Expected Result Actual Result Pass?

1 21/03/2025 Health official Dashboard dis- Data filtered cor- Yes
filters dash- plays data filtered rectly
board data by by selected re-
region/district gion/district
(US4)
2 21/03/2025 Health official Detailed report Detailed report Yes
drills down into with supporting shown
detailed reports charts is dis-
for a specific played
indicator (US5)
3 21/03/2025 Data analyst in- Charts update dy- Charts update Yes
teracts with dy- namically to re- correctly
namic charts and flect data trends
graphs (US6)

Table 5.2: Test Case Sprint 2

44
5.1.3 Test Case-Sprint 3

No. Date Action Expected Result Actual Result Pass?

1 22/03/2025 Health official Map displays Map displays Yes
views geospatial health events hotspots correctly
maps repre- with hotspot
senting data markers
distributions
(US7)
2 22/03/2025 Registered user Dashboard layout Layout updated Yes
customizes the updates as per and saved
dashboard layout customization
and widgets and settings are
(US8) saved
3 22/03/2025 Health official Real-time alert Alert received Yes
receives a real- appears with and visible
time alert for an visual/sound cues
emerging health
event (US9)

Table 5.3: Test Case-Sprint 3

45
5.1.4 Test Case-Sprint 4

No. Date Action Expected Result Actual Result Pass?

1 23/03/2025 Admin updates User role updated Role updated; Yes
a user’s role successfully; permissions set
from ”Registered new permissions correctly
User” to ”Health granted
Official” (US10)
2 23/03/2025 Data analyst ex- Dashboard report File(s) down- Yes
ports a dashboard downloaded in loaded; data
report in CSV selected for- present
and PDF formats mat(s) with
(US11) accurate data
3 23/03/2025 Registered user Comparison view Comparison view Yes
compares his- displays histor- displayed as ex-
torical data with ical and current pected
current metrics data side-by-side
(US12) for trend analysis

Table 5.4: Test Case-Sprint 4

46
5.2 Implementation

After thorough planning and analysis, the Kerala Health Dashboard is now in the imple-
mentation phase. This phase involves transforming the designed architecture into a fully
operational system that provides real-time insights into Kerala’s health infrastructure. The
platform will cater to four types of users: administrators, health officials, data analysts, and
general users. Key features such as secure authentication, data visualization, hierarchical
hospital resource tracking, KPI monitoring, and statistical reporting will be integrated. The
dashboard will be hosted on a secure, high-performance server with encrypted data storage,
ensuring privacy and compliance with Kerala’s health data regulations.

5.2.1 Deployment Environment

The Kerala Health Dashboard will be deployed on either a cloud-based infrastructure or

a dedicated on-premise server managed by the Kerala Health Department. The hosting
environment ensures high availability for system uptime during peak usage, scalability
for large-scale health data processing, and security through encryption, access controls,
and multi-factor authentication. Additionally, disaster recovery mechanisms with daily
automated backups and failover systems will maintain data integrity. This infrastructure
supports real-time data ingestion, enabling health officials and analysts to monitor health
statistics across Kerala’s districts seamlessly.

5.2.2 Software Installation

The system utilizes a robust software stack including Ubuntu 22.04 LTS as the operating
system, Laravel 11 for backend development with RESTful APIs and role-based access
control, and [Link] for the dynamic frontend interface. PostgreSQL serves as the primary
database for handling large-scale structured health data, while [Link] and [Link] provide
advanced data visualization capabilities. The development environment employs Docker
for containerization, Git for version control, and Postman along with Selenium for com-
prehensive API and UI testing. This carefully selected technology stack ensures optimal
performance, scalability, and data security.

47
5.2.3 Backend Development

The Laravel-based backend handles critical functions including data processing, role man-
agement, API interactions, and health analytics. It implements JWT (JSON Web Tokens)
for secure user authentication and role-based access control to differentiate permissions
among administrators, health officials, and analysts. The system features RESTful API
endpoints for data submission, retrieval, and analytics, supported by an optimized Post-
greSQL schema designed for efficient handling of large-scale hospital and patient statis-
tics. Security measures include bcrypt password encryption, API rate limiting, and CSRF
protection to safeguard sensitive health data.

5.2.4 Frontend Development

The [Link] frontend delivers an interactive dashboard experience with several key com-
ponents. The user interface displays real-time health metrics, hospital resource availability,
and KPI trends through dynamic visualizations created with [Link] and [Link]. Advanced
filtering and search functionality enables officials to analyze trends based on disease preva-
lence, hospital capacity, and mortality rates. The responsive design ensures accessibility
across various devices including desktops, tablets, and mobile phones, while secure REST
API integration facilitates data retrieval from the backend system.

5.2.5 Deployment and Training

The deployment process involves configuring the Laravel backend and React frontend on
a Linux-based cloud server with Nginx load balancing, implementing SSL certification for
secure HTTPS connections. Prior to deployment, comprehensive testing will be conducted
including unit tests for APIs and UI components, integration tests for data flow verification,
and performance tests to ensure smooth operation with large datasets. Training sessions
will be organized for health officials and data analysts, covering data entry procedures, real-
time monitoring techniques, and report generation to ensure effective system utilization.

48
5.2.6 Maintenance and Monitoring

Centre for Development of Imaging Technology. (CDIT) will maintain continuous moni-
toring of the Kerala Health Dashboard. This includes tracking system performance using
Grafana and Prometheus, conducting periodic security audits, and optimizing database per-
formance through routine maintenance. Automated alert systems will notify administrators
of server downtimes, security breaches, and critical updates, ensuring prompt response to
any operational issues.

5.2.7 Continuous Improvement

The dashboard will evolve through a feedback-driven enhancement strategy involving reg-
ular consultations with stakeholders to identify opportunities for improvement. Future de-
velopment may include new features aligned with evolving health policies, the integration
of AI and machine learning for advanced predictive analytics of disease outbreaks, and
regular updates to documentation to support both developers and end users. Periodic eval-
uations will assess system performance, usability, and data accuracy to guide continuous
updates. Feedback from health officials, data analysts, and field workers will play a key
role in refining the system’s functionalities and improving the overall user experience. A
version control mechanism will be used to ensure stable and smooth feature rollouts. Ad-
ditionally, each major update will be supported by user training sessions and updated man-
uals to ensure seamless adaptation. This continuous improvement approach will ensure the
dashboard remains reliable, user-friendly, and capable of supporting Kerala’s dynamic and
evolving healthcare management needs.

49
 Chapter 6

RESULT AND DISCUSSION

The implementation of the Kerala Health Dashboard has produced promising results. After
comprehensive testing, the system demonstrated stable performance, robust security, and
seamless integration between the [Link] frontend and Laravel 11 backend, utilizing Post-
greSQL for efficient data management. The hierarchical structure for hospital resources,
real-time health statistics, and KPI visualization proved to be highly effective in aiding
decision-making by health officials and analysts.
The interactive dashboard allowed users to monitor health trends across Kerala’s districts,
track hospital resource availability, and generate detailed statistical reports. The deploy-
ment on a secure, high-performance cloud infrastructure ensured reliability, scalability, and
data security, meeting the critical performance benchmarks set during the planning phase.
Feedback from administrators, health officials, and data analysts has been overwhelmingly
positive. Users reported ease of navigating the dashboard, filtering health data, and visual-
izing key performance indicators (KPIs). The system’s role-based access control effectively
secured sensitive data while maintaining accessibility for authorized personnel. The inte-
gration of [Link] and [Link] enhanced data visualization, providing actionable insights into
mortality rates, disease prevalence, and vaccination statistics.

50
 Chapter 7

CONCLUSION

The Kerala Health Dashboard has proven to be an efficient and innovative solution for mon-
itoring and analyzing healthcare data across Kerala. By aggregating and visualizing real-
time health statistics, resource availability, and disease trends, the dashboard provides valu-
able insights to healthcare professionals, policymakers, and administrators. Its structured
approach to organizing health data across multiple districts ensures informed decision-
making, efficient resource allocation, and improved public health response.
The integration of interactive visualizations, real-time analytics, and hierarchical hospital
resource tracking has significantly enhanced the ability to monitor healthcare services. The
dashboard’s role-based access control ensures secure and streamlined access to critical in-
formation, while its scalable cloud-based infrastructure guarantees reliable performance
even under high data loads.
By leveraging modern technologies such as [Link], Laravel 11, PostgreSQL, and [Link],
the Kerala Health Dashboard establishes a new standard in data-driven healthcare manage-
ment. The system not only enables comprehensive health monitoring but also empowers
health officials with actionable insights, leading to more effective healthcare strategies and
policy formulation.

51
7.1 Future Work

Looking ahead, there is substantial scope for enhancing the Kerala Health Dashboard with
additional features and capabilities. Future improvements could include:

• Predictive analytics using machine learning to forecast disease outbreaks and re-
source demands.

• Integration with electronic health records (EHRs) to create a more comprehensive

healthcare database.

• Expansion of mobile accessibility to allow real-time data entry and monitoring through
smartphone applications.

• Implementation of AI-driven insights to automate anomaly detection in health statis-

tics and provide early warnings.

• Strengthening multi-language support to enhance usability for diverse stakeholders.

• Improved data-sharing capabilities with other health information systems to promote

a connected healthcare ecosystem.

Furthermore, continuous feedback from health officials, data analysts, and policymakers
will guide future enhancements, ensuring that the dashboard evolves to meet emerging
healthcare challenges. By embracing cutting-edge technology and data science, the Kerala
Health Dashboard will continue to play a pivotal role in improving public health outcomes
and policy effectiveness.

52
 REFERENCES

[1] S. Kumar, et al., ”Implementing Real-Time Data Dashboards in Public Health,”

Journal of Health Informatics, vol. 18, no. 3, pp. 210-225, 2023.

[2] R. Sharma and M. Iyer, ”User-Friendly Interfaces in Health Data Dashboards:

Impact on Decision-Making,” International Journal of Medical Data Science, vol.
12, no. 1, pp. 98-112, 2024.

[3] P. Nair and L. Menon, Healthcare Data Analytics and Visualization, 1st ed.,
Springer, 2023.

[4] K. Rajan, Digital Health Technologies in Public Administration, McGraw Hill,

2024.

[5] [Link], ”AI-Driven Dashboards in Healthcare Administration,”

2025. [Online]. Available: [Link]

[6] L. Nair and R. Krishnan, ”AI-Driven Dashboards for Health Data Manage-
ment,” Journal of Public Health Technology, vol. 17, no. 2, pp. 50-65, 2023.

[7] A. Menon and S. Pillai, ”Integrated Health Management Systems: Efficiency

and Impact,” Healthcare Systems Review, vol. 10, no. 4, pp. 180-195, 2022.

[8] B. Thomas, et al., ”Interactive Data Visualization for Health Officials: Reducing
Manual Reporting,” Journal of Health Data Analytics, vol. 15, no. 5, pp. 75-90,
2021.

[9] D. Ramesh and P. Gupta, ”Predictive Analytics in Public Health Dashboards:

Improving Resource Allocation,” International Journal of Healthcare Intelligence,
vol. 14, no. 3, pp. 110-125, 2020.

53
 APPENDICES

SCREENSHOTS

Home Page
Hompepage features a promotional or informational graphic titled ”Ayurveda,” highlight-
ing the theme of traditional healing. It emphasizes Kerala as a place where tradition
meets modern excellence, suggesting a blend of ancient Ayurvedic practices with contem-
porary advancements. The graphic also mentions ”Modern Healthcare” and ”Advanced
Medicine,” indicating a focus on integrating traditional Ayurvedic methods with modern
medical techniques.

Homepage

54
Health Achievements
healthcare achievements, showcasing a 94.6 percent patient satisfaction rate, a robust med-
ical infrastructure with 1,280+ primary health centers and 38 medical colleges, and a life
expectancy of 77.7 years. It emphasizes strong healthcare access, with 94 coverage and
0.96 doctors per 1,000 people, along with a low infant mortality rate of 12. Additionally,
the region attracts 50,000+ medical tourists annually with a 95 satisfaction rate, reflecting
its excellence in combining quality care, modern facilities, and patient-centric services.

Health Achievements

55
Epidemiology Dashboard
Epidemiology Dashboard tracking disease trends over a six-month period (February to
June). It highlights 44 cases of Derique Fever, 110 COVID-19 cases, and 250 respiratory
infections, with monthly data points for each. The dashboard provides a clear, comparative
overview of disease prevalence, showing that respiratory infections are the most prevalent,
followed by COVID-19 and Derique Fever. This structured visualization helps in monitor-
ing public health trends and identifying seasonal or emerging patterns in disease outbreaks.

epidemiology dashboard

56
Vaccination Coverage
Vaccination Coverage report segmented by age groups—Childhood, Adult, and Elderly
highlighting immunization rates for two key vaccines. The MMR (Measles, Mumps, Rubella)
Vaccine shows a high coverage rate of 95, reflecting a 2 increase, while the DPT (Diph-
theria, Pertussis, Tetanus) Vaccine achieves 92 coverage with a 1 rise. This data indicates
strong vaccination adherence across demographics, with notable progress in immunization
efforts, particularly for childhood diseases. The upward trends suggest effective public
health campaigns or improved access to vaccines.

Vaccination Coverage

57
Distribution Chart
Distribution of healthcare facilities and staff, categorized into Primary Health, Community
Health, District Hospitals, and Medical Colleges, indicating a tiered healthcare system. Be-
low this, a staff distribution graph (likely a bar chart) quantifies personnel across roles, with
Doctors, Nurses, Lab Technicians, and Other staff represented numerically (e.g., 35,000
doctors). The graph’s scale ranges from 0 to 35,000, emphasizing the workforce alloca-
tion. Together, the data highlights the infrastructure and human resource framework of the
healthcare system, showcasing both facility hierarchy and staffing proportions critical for
service delivery.

Distribution Chart

58
Health Care Updates
Recent Healthcare Updates, highlighting three key developments in Kerala’s medical sec-
tor. First, a New Medical College opened on February 15, 2025, adding 500 seats to en-
hance medical education capacity. Second, Remote Healthcare Expansion on February 14,
2025, extended telemedicine services to 200+ villages, improving access to care in under-
served areas. Third, a Global Healthcare Conference held in Kochi from February 20, 2025,
brought together international experts for a three-day event, fostering knowledge exchange
and collaboration. These updates reflect Kerala’s commitment to advancing healthcare in-
frastructure, accessibility, and global engagement.

Health care updates

59
Health Map
Kerala Health Map, offering a detailed overview of the state’s healthcare system and district-
specific statistics. It highlights Kozhikode district with 4,120 hospital beds, 1.4 doctors per
1,000 people, a low infant mortality rate of 7.3, and a life expectancy of 76.5 years, while
noting cardiac issues and past Nipah outbreaks as common health concerns. The broader
Kerala Health Statistics Overview emphasizes the state’s renowned three-tier healthcare
infrastructure (primary, community, and district/specialized hospitals) and its status as a
leader in health indicators within India.

Health Map

60
Population Health Metrics
The Population Health Metrics section of the dashboard emphasizes critical public health
indicators, specifically infertility and mortality rates. This section is designed to shed light
on the prevalence of these health issues within the population, helping health officials and
policymakers identify areas requiring targeted interventions or further investigation. In-
fertility and mortality are presented as distinct yet comparable metrics, likely intended to
represent two major health concerns affecting a significant portion of the population. Their
side-by-side display allows for a straightforward visual comparison, prompting users to
consider how these issues may relate to broader health trends or systemic factors such as
healthcare accessibility, environmental conditions, or lifestyle influences.

Population Health Metrics

61
Health Dashboard
Health Dashboard, a comprehensive real-time monitoring system for tracking the state’s
healthcare infrastructure and disease surveillance. It highlights key metrics such as 156,789
total patients (a 12 increase across all districts), a 94 recovery rate (up by 2.3 in the past 30
days), 487 critical cases (a 1.1 rise under care), and 328 active facilities (hospitals and clin-
ics with a 1.5 growth). The dashboard provides options to ”Explore Dashboard” and ”View
Reports”, showcasing Kerala’s data-driven approach to healthcare management, with in-
sights into both positive trends like high recovery rates and challenges such as increasing
critical cases.

Health Dashboard

62
Patient Metrics
Patient Metrics dashboard providing an annual overview of healthcare statistics in Kerala.
It tracks monthly trends in patient admissions, recoveries, and mortality rates across all
twelve months of the year, with specific data for August showing 9,100 admissions, 8,500
recoveries, and 180 deceased patients. A comparative analysis titled ”Recovery vs. Admis-
sion” visually contrasts these metrics over even-numbered months (February, April, June,
August, October, December), highlighting fluctuations in patient outcomes. The dashboard
underscores Kerala’s systematic approach to monitoring healthcare performance, empha-
sizing transparency in tracking treatment efficacy (recovery rates) and challenges (mortal-
ity).

Patient Metrics

63
Outbreak Monitoring
Outbreak Monitoring dashboard tracking both disease outbreaks and critical healthcare
resources in Kerala. The Disease Outbreak Tracker highlights current threats, including
Dengue Fever (824 high-severity cases in Thrissur), COVID-19 (1,267 medium-severity
cases statewide), and Cholera (42 critical-severity cases in Malappuram), alongside trends
and locations. The Critical Resources Monitor reveals availability gaps, such as only 22
of ventilators operational in Thiruvananthapuram and 39 of ICU beds in Ernakulam, while
Kozhikode maintains 69 oxygen cylinder stocks. This integrated system enables real-time
surveillance of epidemiological risks and resource shortages, supporting targeted public
health interventions.

Outbreak Monitoring

64
Hospital Status
Hospital search and information dashboard for Kerala’s healthcare system, enabling users
to locate medical facilities by district or type while providing detailed infrastructure in-
sights. It features three districts - Thiruvananthapuram, Kollam, and Pathanamthitta - each
displaying key metrics for their primary hospital, including case statistics (total cases, re-
coveries, active cases, and deaths), operational status, and resource utilization (bed occu-
pancy rates and doctor-to-bed ratios). With Thiruvananthapuram showing 80

Hospital Status

65
District Data Statistics
Recovery Rate by District dashboard with inconsistent and seemingly erroneous data for
Malappuram district, showing recovery rates ranging from 0 to 95.5 without clear context
or timeframes. Below this, the Hospital Status Distribution reveals that 58.3 of facilities are
fully operational, while 16.7 are partially functional and 25.0 are in critical condition, in-
dicating significant infrastructure challenges. The Healthcare Personnel by District section
displays an ambiguous numerical scale (800, 600, 400, 200, 1) without labels or district
names, making interpretation difficult. Overall, the dashboard appears to combine valid
metrics (hospital status) with unclear or duplicate data (recovery rates, personnel num-
bers), suggesting potential data entry errors or visualization flaws.

District Data Statistics

66