Geoinfotech-Web/Transportation-Cost-Intelligence-Dashboard

Transportation Cost Intelligence Dashboard is an interactive geospatial analytics platform desiged to monitor, analyse and visualize Premium Motor Spirit (PMS) fuel prices and transport cost trends across all 36 states and the Federal Capital Territory of Nigeria. # Nigeria PMS & Transportation Cost Dashboard An interactive web-based dashboard displaying PMS (fuel) and transportation cost data across Nigeria's 36 states from November 2024 to March 2026. ## Features ✨ **Interactive State Selection** - Click any of 36 state cards to view detailed analytics - Hover over states to preview latest fuel and transport prices - Reset selection at any time 📊 **Data Visualization** - Time series charts showing fuel price and transport cost trends - Monthly hike charts tracking price changes month-over-month - Summary cards with latest averages across all states 📈 **Detailed Statistics** - State overview with latest month data - Average prices and overall trends - Percentage change calculations from start to latest period - Complete period coverage information 📥 **Report Export** - Download state-specific data as CSV - Includes all months from November 2024 to March 2026 - Ready for further analysis in Excel or other tools ## Setup Instructions ### Option 1: Using Your Real Data (Recommended) 1. **Prerequisites**: Python 3 with pandas ```bash pip install pandas openpyxl ``` 2. **Convert Excel files to JSON**: ```bash python process_data.py ``` This will read the Excel files in `Dashboard Data/` folder and create `data.json` 3. **Open the dashboard**: - Open `index.html` in your web browser - The dashboard will load your real data ### Option 2: Using Sample Data 1. Simply open `index.html` in your web browser 2. The dashboard will automatically generate sample data 3. You can use this to familiarize yourself with the interface ## Files Structure ``` Dashboard/ ├── index.html # Main dashboard UI ├── styles.css # Styling ├── data-loader.js # Dashboard logic and interactivity ├── process_data.py # Excel to JSON converter ├── data.json # Generated data file (created by process_data.py) ├── README.md …