Nhlanhla-NM/Government-promise-tracking-system-OpenGov-Africa
Type de record:
project
Créateur:
Nhl
Hôte:
Project about tracking government promises in Central African Republic and Cameroon using news data. An collection, summarizing, and analysis of news articles, generating structured insights for monitoring and reporting.
# Project Background
Project tracks government promises in Central African Republic and Cameroon using news data. Includes data capturing, collecting, summarizing, and analyzing news articles, generating structured insights for monitoring and reporting.
# Project Objective
-Data capturing and updating data, tracking government promises starting from the present administration
-Creating insight updates on Government promises
# AI Automation Workflow
Automation Process:
System is triggered daily consistently per 30 minutes to collect data from the latest news articles
-Input- News Articles retreived using RSS
-Processing- Articles are filtered and cleaned to extract relevant content
-AI Layer- AI tools summarize articles and extract key insights related to government actions and update
-Output- Structured content is stored in Google Sheets and sends an automated reminder of new data via email
Diagram:
News RSS → Data Cleaning → AI Summarization → Insight Extraction to Google Sheets → Email Report
The update of data being collected by automation can be viewed in this link
# Executive Summary
# Visuals
# Insights
-The President holds the highest concentration of goals, with 31.82% more assignments than other 13+ officials, indicating a centralized workload.
-The Economy sector dominates with 36.36% of total goals, making it the most prioritized sector compared to the 5 other sectors.
-Goal updates range from September 2025 to April 2026, reflecting a 7-month monitoring period with unclear update consistency in some goals.
-59.09% of goals are currently in progress, suggesting active implementation, though completion rates remain at 22,73%.
# Recommendations
-Redistribute goals across officials to ensure balanced workload and improved efficiency.
-Maintain focus on key sectors while ensuring equitable sector representation.
-Implement deadlines and milestone tracking for all goals.
# Tools Used
-Google Sheets
-Microsoft Power BI
-Ma …