gbamwuan-Joshua-sughter/Nigeria-Telecom-Market-Analysis-3MTT-Capstone-Project-
Domain:
digital infrastructureRecord type:
project
Creator:
gba
Host:
# š³š¬ Nigeria Telecommunications Market Analysis Dashboard
## š Project Overview
This project presents an interactive **Power BI analysis of Nigeria's telecommunications market** using industry data from the **Nigerian Communications Commission (NCC)**.
The analysis covers the period from **January 2023 to May 2026** and examines subscriber trends, operator market share, Internet data usage, monthly and year-over-year growth, average data usage per subscriber, and the migration across 2G, 3G, 4G and 5G network generations.
The project demonstrates an end-to-end data analytics workflow, from **automated data extraction using Python** through data preparation, modelling, DAX analysis and interactive Power BI dashboard development.
---
## šÆ Project Objectives
The project aims to:
- Analyse changes in Nigeria's telecommunications subscriber base.
- Examine market-share movements among major network operators.
- Measure monthly and year-over-year subscriber growth.
- Analyse Internet data-usage trends.
- Measure monthly and year-over-year data-usage growth.
- Calculate average monthly data usage per subscriber.
- Analyse the transition from 2G and 3G toward 4G and 5G.
- Build an interactive business intelligence dashboard.
- Extract and prepare telecommunications data programmatically using Python.
---
## š Data Analytics Workflow
The project followed an end-to-end analytical workflow:
```text
NCC Website
ā
Python Data Extraction
ā
Data Cleaning & Preparation
ā
Excel / Clean Dataset
ā
Power BI Data Model
ā
DAX Measures
ā
Interactive Dashboard
ā
Market Insights
š ļø Tools Used
Python
Microsoft Excel
Power BI
Power Query
DAX
š Key Findings
Total subscribers declined from 226.23M to 189.68M, approximately 16.2%.
Internet data usage increased from 517.67K TB to 1.50M TB, approximately 190%.
Average data usage per subscriber increased from 2.34GB to 8.12GB.
MTN's market share increased from 40.65% to 51.13%.
Airtel's market share increased from 26.77% to 34.51%.
Glob ā¦