Gaddiel05/PAEIP-Project

A web-based interactive dashboard displaying Economic metrics of East-African countries # 📊 Pan-African Economic Intelligence Platform (PAEIP) This project is a Flask-based web application that provides an interactive economic dashboard for East African countries, built using: - Flask (backend) - SQLite (database) - Chart.js (interactive charts) - HTML/CSS/JS (front-end) - CSV export functionality - User authentication (signup/signin) It loads macroeconomic data from the JSON file, East-African-data.json, and stores it into an SQLite database (paei.db). ## ✨ Features ### ✅ Dashboard Interactive dashboard showing: - Population - GDP growth - GDP sector composition - Employment sectors - FDI - Unemployment - Inflation - Nominal GDP All displayed as dynamic charts (Chart.js) and KPIs. ### ✅ Filters - Filter by country - Filter by year - Auto-refresh of charts and KPIs ### ✅ Authentication - User signup - User login - Sessions - Password hashing (Werkzeug) ### ✅ Database - SQLite with: - metrics table (economic indicators) - users table (name, email, hashed password) ### ✅ CSV Export - A dedicated page to download the full dataset - File generated dynamically from the SQLite database - Only available for logged-in users ### ✅ Clean UI - Modern layout - Soft gradient background - Light-blue brand color (instead of the darker purple) ## 📁 Project Structure ``` ├── app.py ├── create_db.py ├── requirements.txt ├── README.md ├── paei.db # auto-created after running create_db.py │ ├── East-African-data.json # cointains the dataset in json format │ ├── templates/ │ ├── base.html │ ├── home.html │ ├── signup.html │ ├── signin.html │ ├── dashboard.html │ └── download.html │ └── static/ ├── css/style.css └── js/dashboard.js ``` ## 🛠 Installation & Setup ### 1. First option: Run the deployed version using: ``` paeip-dashboard.onrender.com ``` ### 2. Second option: Clone and run the program locally 1️⃣ **Clone the Project** ``` git clone github.com cd paei_dashboard ``` 2 …