jeisteve999/AFRICA-ECONOMIC-PROFILE-----AUTOMATED-REPORT

Automated ETL pipeline for African macroeconomic data, integrating World Bank, IMF, and UNDP datasets into Google Sheets for analysis, dashboards, and reporting using Python. # Macroeconomics-Africa-automated-report Automated ETL pipeline for African macroeconomic data, integrating World Bank, IMF, and UNDP datasets into Google Sheets for analysis, dashboards, and reporting using Python. # Project Overview The Africa Economic Profile project is an automated Business Intelligence solution designed to generate country-level economic and governance profiles for African nations. The solution combines data from multiple international organizations, automates data collection through APIs, processes and standardizes the information using Google Apps Script, and presents it through executive dashboards built in Google Sheets. The project was developed for OpenGov Africa to provide decision-makers, researchers, and volunteers with a centralized platform for monitoring macroeconomic, institutional, and development indicators across African countries. ## 🌍 Live Interactive Dashboard The complete interactive dashboard is available online in **Google Sheets**. The file is shared in **read-only mode**, allowing users to explore the dashboards and interact with filters without modifying the original project. 🔗 **View the Interactive Dashboard** # Project Objectives - The project aims to: Automate the collection of economic and governance indicators from trusted international sources. Eliminate manual data updates through ETL automation. Standardize indicators from multiple organizations into a unified data model. Generate executive country profiles. Facilitate cross-country comparison. Support evidence-based policy analysis. Provide interactive dashboards for monitoring development indicators. # Data Sources The project integrates information from internationally recognized organizations: World Bank (WDI) Economic indicators including: GDP GDP Growth GDP Per Capita Inflation Population Trade Infrastructure Education Health Poverty Agriculture Industry Services # International Monetary Fund (IMF) Macroeconomic indicators such as: Ex …