dreamsss126/Ghana-Import-Trade-Analysis

# Ghana Import Trade Analysis(2021-2025) ### Partner Concentration, Regional Shifts & Trend Insights - SQL + Tableau --- ## 📌 Project Overview This project analyzes Ghana's import trade with the rest of the world between 2021 and 2025, using UN Comtrade partner-reported ("mirror") trade data. It was built end-to-end — from raw CSV cleanup through SQL Server analysis to an interactive Tableau dashboard — to answer a real business/policy question: > **How has Ghana's import profile shifted over 5 years, which trading partners matter most, and where does that concentration create risk?** Every step is documented below and in `(github.com)`, including the mistakes and fixes along the way — the goal is a project that's fully reproducible and honest about its process, not just a polished end result. --- ## 🧰 Tools Used | Tool | Purpose | |---|---| |Microsoft Excel|Data cleaning| | Microsoft SQL Server / SSMS | Data cleaning, consolidation, analytical queries (T-SQL) | | Tableau (Public) | Interactive dashboard and visualization layer | | UN Comtrade | Source data (public trade statistics) | --- ## 🗂️ Repository Structure ``` ghana-trade-analysis/ ├── README.md ├── docs/ │ ├── steps_log.md <- full chronological log, including issues & fixes │ └── report.docx <- written findings report ├── sql/ │ ├── 01_import_verification.sql │ ├── 02_consolidation.sql │ ├── 03_region_lookup_build.sql │ ├── 04_analysis_top_partners.sql │ ├── 05_analysis_yoy_growth.sql │ ├── 06_analysis_concentration.sql │ ├── 07_analysis_regional_rollup.sql │ ├── 08_analysis_rank_shifts.sql │ ├── 09_analysis_data_quality.sql ├── exports/ │ ├── yearly_totals.csv │ ├── top15_concentration.csv │ ├── regional_rollup.csv │ └── rank_shifts.csv └── dashboard/ └── ghana_trade_dashboard.twbx <- Tableau Public workbook ``` --- ## 📊 Data Source Five annual extracts from **UN Comtr …