Too often, communities are caught off guard by preventable health crises due to lack of timely data insights on seasonal disease trends. This project uses Excel + AI-Aided Formula Editor (Copilot) to forecast disease trends based on weather and health data which help policymakers and health workers stay ahead of disease outbreaks.
- Excel dashboard for disease risk analysis
- Forecast future cases using AI-generated Excel formulas
- AI Natural Language Summary
- AI-generated prevention tips
- Insights for health workers and policymakers
- Recommended actions for policymakers and community health workers using SMART HEALTH RISK FORCASTE DASHBOARD data
AI_Health_Risk_Dashboard_Data.xlsx: Main dataset and dashboardCholera_Case_History.xlsx: Main dataset and dashboardAI_Prompt_Questions: Prompt Questionsinsights.txt: AI-generated health insightsRecommended_Action.txt: AI-generated recommendations
- Microsoft Excel
- Excel AI-Aided Formula Editor (Copilot)
- And a lot of community-driven passion
Nwosu Innocent Mmaduabuchi | 3MTT Fellow | https://www.linkedin.com/posts/innocent-mmaduabuchi-nwosu-1439b9157_3mttlearningcommunity-my3mtt-3mttnigeria-activity-7354149318259290115-ZF8q?utm_source=share&utm_medium=member_desktop&rcm=ACoAACWzlIMB76_6yZeZzRj6BvVtASmG4AtGO_s
- Cholera is the top disease
- Ikole LGA is the most affected area
- Rainy season is the season with highest number of cases
- Month of March has the highest of cases, followed by January and February in disease monthly trends.
Recommended actions for policymakers and community health workers using SMART HEALTH RISK FORCASTE DASHBOARD data
As Forecasts allow early intervention, the following is recommended:
- Allocate emergency health teams to forecasted hotspots.
- Use community radio or SMS to share prevention tips from AI-generated summaries.
- Integrate dashboard insights into monthly local health review meetings.