Oyebola-19/Nigeria-Higher-Institutions-Analysis

A comprehensive analysis of 1,048 Nigerian higher institutions using SQL and Power BI # 🏫 Nigeria Higher Institutions Analysis ## 📌 Project Overview A comprehensive data analysis of **1,048 higher institutions in Nigeria**, covering universities, polytechnics, colleges of education and more. The analysis spans **115 years of history (1908–2023)** and examines ownership patterns, growth trends and geographic distribution across the country. --- ## 🎯 Project Objectives 1. Analyse the distribution of higher institutions across ownership types in Nigeria 2. Identify growth trends in institution establishment from 1908 to 2023 3. Examine the relationship between institution categories and ownership types 4. Highlight the rise of private sector participation in Nigerian higher education 5. Provide data-driven insights to support education policy and planning decisions --- ## 🔑 Key Findings - **Private institutions dominate** with 56.7% (594 of 1,048) of all higher institutions, outnumbering Federal (21%) and State (22.3%) combined - **The 2010s saw the highest growth** — 338 institutions established, driven almost entirely by private sector expansion (249) - **Universities lead by category** with 220 institutions, followed by Colleges of Education (202) and Innovation Enterprises (181) - **Federal Government pioneered** Nigerian higher education from 1908 through the 1970s, establishing 43 institutions in that decade alone - **Private institutions were virtually absent before 1990** — only 4 established before then. From 2000 onward they established 492 institutions (83% of their total) --- ## 🛠️ Tools Used | Tool | Purpose | |------|---------| | **Python (Pandas)** | Data cleaning and transformation | | **MySQL Workbench 8.0** | Data storage and SQL analysis | | **Power BI Desktop** | Data visualization and reporting | --- ## 📁 Repository Structure ``` Nigeria-Higher-Institutions-Analysis/ │ ├── README.md ← Project overview (this file) ├── data/ │ └── Nigeria_Higher_Institutions_Cleaned.csv ← Cleaned dataset ├── sql/ …