Blessed12370/Nigeria-Tech-Ecosystem-Analytics

A data analytics project exploring Nigeria’s technology ecosystem using Excel . The project includes data cleaning, exploratory data analysis (EDA),interactive dashboard and recommendations # 🇳🇬 Nigeria Tech Ecosystem Analysis ### From Raw Records to an Investor-Ready Dashboard ## 📌 Project Overview Nigeria's technology sector is one of Africa's fastest-growing industries, but the available data is often fragmented and inconsistent. This project transforms a messy dataset of 2,000 Nigerian technology companies into a clean, analysis-ready dataset using Microsoft Excel and presents key business insights through an interactive dashboard. The project demonstrates the complete data analytics workflow—from data cleaning and transformation to exploratory data analysis (EDA), KPI development, and dashboard design. ## 🎯 Project Objectives - Clean and validate a messy real-world dataset. - Remove duplicate records and handle missing values. - Standardize inconsistent naming conventions. - Convert text-based numeric fields into usable data. - Identify and remove logical errors. - Perform exploratory data analysis (EDA). - Build an investor-focused interactive dashboard. ## 📊 Dataset Information | Raw Records | 2,000 | | Cleaned Records | 1,982 | | Initial Fields | 9 | | Final Fields | 10 (including Revenue per Employee) | ## 🛠 Tools Used - Microsoft Excel - Pivot Tables - Pivot Charts - Interactive Dashboard - Excel Functions (PROPER, TRIM, SUBSTITUTE, VALUE, ## 🧹 Data Cleaning Process The following data quality issues were identified and resolved: - Removed duplicate records. - Standardized inconsistent text values and abbreviations. - Converted Employee Count and Annual Revenue from text to numeric values. - Removed companies with impossible founding dates. - Filled missing categorical values with **"Unknown"**. - Replaced missing numeric values using appropriate statistical measures. - Created a new **Revenue per Employee** metric. - Assigned correct data types to all field ## 📈 Dashboard and KPIs - Total Companies - Average Revenue - Total Employees - Revenue per Employee - Company Distribution by Industry - Company Distribution by Location …