Chiemerie Favour Onyeanusi
$6/hr
Data Analyst – Excel, Power BI, SQL, Python & Tableau
- Reply rate:
- 100.0%
- Availability:
- Hourly ($/hour)
- Location:
- Ihiala, Anambra, Nigeria
- Experience:
- 1 year
THE NIGERIA TELECOM DATA ANALYSIS SUMMARY
Objectives of analysis:
• Purpose: Our aim of this analysis was to know how well different network operators are performing in different regions of Nigeria.
Our goal was to find out the trends and give recommendation.
• Scope of analysis: This analysis covers 6years record i.e. from January 2020 to December 2025 of different network operators, Number subscribers, Revenue, Expenses, Profit, Data usage, and Voice traffic in different Regions in Nigeria. Focusing on finding the trends.
Findings:
• Revenue by regions: The total revenue made was 21.24 trillion-naira. Abuja contributes 21.64% of the total revenue which is 4.60 trillion-naira, Enugu 20.21% which is 4.29 trillion-naira, Kano 21.12% which is 4.49 trillion-naira, Lagos 17.43% which is 3.70 trillion-naira, Port Harcourt 19.62% which is 4.17 trillion-naira.
• Profit by regions: The total profit made was 7.45 trillion-naira. Abuja contributes 21.50% of the total profit which is 1.60 trillion-naira, Enugu 19.83% which is 1.48 trillion-naira, Kano 21.90% which is 1.63 trillion-naira, Lagos 16.93% which is 1.26 trillion-naira, Port Harcourt 19.84% which is 1.48 trillion-naira.
• Expenses by region: The total expenses were 13.79 trillion-naira. In Abuja the expense was 21.71% of the total expenses which is 2.99 trillion-naira, Enugu 20.41% which is 2.81 trillion-naira, Kano 20.69% which is 2.85 trillion-naira, Lagos 17.69% which is 2.44 trillion-naira, Port Harcourt 19.49% which is 2.69 trillion-naira
• Revenue by operators: The total revenue made was 21.24 trillion-naira. 9mobile contribute 25.07% of the total revenue which is 5.33 trillion-naira, Airtel 23.76% which is 5.05 trillion-naira, Glo 25.34% which Is 5.38 trillion-naira, MTN 25.83% which is 5.49 trillion-naira.
• Profit by operators: The total profit made was 7.45 trillion-naira. 9mobile contributes 24.93% of the total profit which is 1.86 trillion-naira, Airtel 24.30% which is 1.81 trillion-naira, Glo 25.59% which is 1.91 trillion-naira, MTN 25.17% which is 1.88 trillion-naira.
• Expenses by operators: The total expenses were 13.79 trillion-naira. 9mobile contributes in 25.15% of the total expenses which is 3.47 trillion-naira, Airtel 23.46% which is 3.24 trillion-naira, Glo 25.20% which is 3.48 trillion-naira, MTN 26.19% which is 3.61 trillion-naira.
How different operators performed in the Regions
• Revenue in Abuja: The total revenue gotten from Abuja was 4.60 trillion-naira. 9mobile contributes 28.22% of the total revenue in Abuja which is 1.30 trillion-naira, Airtel 23.04% which is 1.06 trillion-naira, Glo 22.93% which is 1.05 trillion-naira, MTN 25.82% which is 1.19 trillion-naira.
• Profit in Abuja: The total profit derived in Abuja was 1.60 trillion-naira. 9mobile contributes 28.21% of the total profit made in Abuja which is 451.92 billion-naira, Airtel 23.33% which is 373.80 billion-naira, Glo 23.25% which is 372.47 billion-naira, MTN 25.22% which is 404.03 billion-naira.
• Expense in Abuja: The total expense in Abuja was 2.99 trillion-naira. 9mobile contribute 28.22% of the expense in made in Abuja which is 844.87 billion-naira, Airtel 22.88% which is 685.02 billion-naira, Glo 22.75% which is 681.11 billion-naira, MTN 26.14% which is 782.49 billion-naira.
• Revenue in Enugu: The total revenue made in Enugu was 4.29 trillion-naira. 9mobile contributes 22.66% of the total revenue In Enugu which is 972.76 billion-naira, Airtel 26.05% which is 1.2 trillion-naira, Glo 29.53% which is 1.27 trillion-naira, MTN 21.76% which is 933.97 billion-naira.
• Profit in Enugu: The total profit made in Enugu was 1.48 trillion-naira. 9mobile contributes 22.40% of total profit made in Enugu which is 331.09 billion-naira, Airtel 26.21% which is 386.10 billion-naira, Glo 31.12% which is 460.07 billion-naira, MTN 20.37% which is 301.07 billion-naira.
• Expense in Enugu: The total expenses in Enugu was 2.81 trillion-naira. 9mobile contributes 22.80% of the total expenses in Enugu which is 641.66 billion-naira, Airtel 26.02% which is 732.16 billion-naira, Glo 28.69% which is 807.26 billion-naira, MTN 22.49% which is 632.90 billion-naira.
• Revenue in Kano: The total revenue in Kano was 4.49 trillion-naira. 9mobile contributes 25.25% of the total revenue in kano which is 1.13 trillion-naira, Airtel 25.46% which is 1.14 trillion-naira, Glo 25.56% which is 1.15 trillion-naira, MTN 23.72% which is 1.06 trillion-naira.
• Profit in Kano: The profit made in Kano was 1.63 trillion. 9mobile contributes 24.84% of the total profit made in Kano which is 405.43 billion-naira, Airtel 26.50% which is 432.45 billion-naira, Glo 26.41% which is 430.97 billion-naira, MTN 22.25% which is 363.10 billion-naira.
• Expenses in Kano: The total expenses in Kano were 2.85 trillion-naira. 9mobile contributes 25.49% of the total expenses in Kano which is 727.23 billion-naira, Airtel 24.87% which is 709.65 billion-naira, Glo 25.08% which is 715.66 billion-naira, MTN 24.56% which is 700.84 billion-naira.
• Revenue in Lagos: The total revenue in Lagos is 3.70 trillion-naira. 9mobile contributes 22.12% of the total revenue in Lagos which is 818.89 billion-naira, Airtel 19.05% which is 705.05 billion-naira, Glo 29.50% which is 1.09 trillion-naira, MTN 29.33% which is 1.09 trillion-naira.
• Profit in Lagos: The total profit made in Lagos was 1.26 trillion-naira. 9mobile contributes 21.95% of the total profit made in Lagos which is 277.08 billion-naira, Airtel 18.75% which is 236.64 billion-naira, Glo 29.25% which is 369.19 billion-naira, MTN 30.05% which is 379.21 billion-naira.
• Expenses in Lagos: The total expenses in Lagos were 2.44 trillion-naira. 9mobile contributes 22.21% of the total expense in Lagos which is 541.80 billion-naira, Airtel 19.20% which is 468.41 billion-naira, Glo 29.62% which is 722.65 billion-naira, MTN 28.96% which is 706.52 billion-naira.
• Revenue in Port Harcourt: The Revenue in Port Harcourt was 4.17 trillion-naira. 9mobile contributes 26.51% of the total revenue made in Port Harcourt which is 1.10 trillion-naira, Airtel 24.54% which is 1.07 trillion-naira, Glo 19.76% which is 823.44 billion-naira, MTN 29.19% which is 1.22 trillion-naira.
• Profit in Port Harcourt: The total profit in Port Harcourt was 1.48 trillion-naira. 9mobile contributes 26.56% of the total profit in Port Harcourt which is 392.72 billion-naira, Airtel 25.87% which is 382.57 billion-naira, Glo 18.60% which is 275.00 billion-naira, MTN 28.98% which is 428.56 billion-naira.
• Expense in Port Harcourt: The total expenses in Port Harcourt was 2.69 trillion-naira. 9mobile contributes 26.48% of the total expenses which is 711.91 billion-naira, Airtel 23.80% which is 693.84 billion-naira, Glo 20.40% which is 548.44 billion-naira, MTN 29.31% which is 787.82 billion-naira.
• Yearly Growth Trends:
• Revenue Trends: In 2020 we had 3.57 trillion-naira as our revenue and in 2021 we made 3.76 trillion-naira which means that we had 5% increment, then in 2022 we made 3.38 trillion-naira which is 10% decrement, in 2023 we made 3.51 trillion which is 3.6% increment, in 2024 we made 3.52 trillion-naira which is 0.4% increment and in 2025 we made 3.50 trillion-naira which is 0.6% decrement.
• Profit Trends: In 2020 we had 1.24 trillion-naira as our revenue and in 2021 we made 1.33 trillion-naira which means that we had 7% increment, then in 2022 we made 1.19 trillion-naira which is 10% decrement, in 2023 we made 1.22 trillion which is 3% increment, in 2024 we made 1.25 trillion-naira which is 2% increment and in 2025 we made 1.22 trillion-naira which is 3% decrement.
• Expenses: In 2020 we spent 2.33 trillion-naira as our Expense and in 2021 we spent 2.44 trillion-naira which means that we had 4.6% increment, then in 2022 we spent 2.19 trillion-naira which is 10% decrement, in 2023 we spent 2.28 trillion which is 4.1% increment, in 2024 we spent 2.27 trillion-naira which is 0.8% decrement and in 2025 we spent 2.28 trillion-naira which is 0.7% increment.
• Subscription trends: In 2020 we had 1.82 billion subscribers and in 2021 we had 1.84 billion subscribers which means that we had 1.2% increment, then in 2022 we made 1.17 billion subscribers which is 7% decrement, in 2023 we made 1.66 billion subscribers which is 3% decrement, in 2024 we made 1.74 billion subscribers which is 5% increment and in 2025 we made 1.22 billion subscribers which is 1% decrement.
Correlation findings:
1. There’s 97% probability that for us to make high revenue, we also have to do higher expense
2. There’s 85% probability that for us to make high revenue, we also have to have higher subscribers
3. There’s 91% probability that for us to make high profit, we have to aim higher revenue
4. There’s also 78% probability that for high profit, then higher expenses are required
5. There’s 66% probability for aiming high revenue, higher voice traffic is required
6. There’s 62% probability for high revenue, then higher data usuage is required
7. There’s 75% probability for aiming high data usuage, then higher subscribers are required
8. There’s 77% probability for aiming high voice traffic, then higher subscribers are also needed
Relationship between data usage and revenue of different operators in the regions
• In Abuja: 9mobile & Glo are having high data usage and high revenue, MTN & Airtel are having low data usage and high revenue.
• In Enugu: Glo is having high data usage and high revenue, MTN & 9mobile are having low data usuage and low revenue, Airtel is having high revenue but low data usage.
• In Kano: All the operators are having high data usage and high revenue,
• In Lagos: Glo is having high data usage ang high revenue, MTN is having low data usage but high revenue, Airtel & 9mobile are having low data usage and low revenue.
• In Port Harcourt: Airtel & 9mobile are having low data usage and high revenue, MTN is having high data usage and high revenue, Glo is having low data usage and low revenue.
Recommendation:
After our analysis we decided to come up with some recommendations which will help to improve the revenue and profit of the telecom company. The recommendations are as follows:
• For high Revenue, all operators should make sure that their data usage and voice traffic is high by having high subscribers, and for aiming of having high subscribers, they have to do high expenses in advertisement, marketing and others which will result in fetching them high profit.
• For every operator with low data usage and revenue in any region should provide stronger network coverage and affordable plans in that region.
• For every operator with high data usage and revenue in any region should maintain service quality and replicate success in that region.
• For every operator with low data usage but high revenue in any region should review pricing to boost data adoption in that region.
Conclusion: With the full implementation of the recommendations listed above by the operators, the Telecommunication company will notice and also maintain a steady growth for years to come.
