A LOOK INTO 9ja's 2021 TELECOMMUNICATIONS STORY USING EXCEL AND POWER BI

The telecommunication industry is a big game and Nigeria is one of the main players. Globally, Nigeria ranks 11th in the absolute number of internet users and 7th in the absolute number of mobile phones. Nigeria is ranked one of Africa's largest ICT market, and data shows that it accounts for 82% of the continent's telecoms subscribers and 29% of internet usage.

Telecommunication products and services include Customer premises equipment (CPE), Local area networks (LANs), Modems, Mobile phones, Teleprinters, Fax machines, Routers, Wireless devices. As an entrepreneur in Nigeria looking to break into the industry or invest in it, deciding where to site your business can be mind-boggling as Nigeria is a large country with 36 states and a Federal Capital Territory (FCT) with a land mass of 923,768 km².

This project aims to help solve this problem and provide insight on the best location to establish a telecommunication company in Nigeria.

This report includes information about the dataset, analytical process, result and insights, and conclusion.

Analysis

Here's a step-by-step outline of our project:

1. Retrieve and Download raw data set from https://nigerianstat.gov.ng/elibrary/read/1240
2. Cleaned raw data on Excel, arranging all the subscription data by Quarter and total subscription then moved the data to a new worksheet
3. Using filter we were able to determine our insights
4. After successfully cleaning on Excel.
5. Loaded and Transformed the Data on Power BI.
6. Analysed the data on Power BI using insights culled intended to solve a likely problem for any business person
7. Created a dashboard on Power BI and used the Pivot Chart to generate insights.
8. The Top 5 states by Internet Subscription was visualized using the Column Chart
9. The Bottom 5 states by Internet Subscription was visualized using the Stacked Column Chart.
10. The Top 5 states by voice subscription was visualized using Stacked Bar Chart.
11. The Bottom 5 states by voice subscription was visualized using Stacked Bar Chart.
12. The Voice subscription by quarter was visualized using the Line Chart.
13. The Internet Subscription by quarter was visualized using the Line Chart.
14. Cards were used to show the total voice subscriptions, total internet subscriptions, average voice subscriptions, average internet subscriptions.
15. Slicers were used on the quarter visualizations for ease of data selection.

Conclusion:

The following insights were obtained from a thorough analysis of the data set:

1. Top 5 states by Internet subscriptions
2. Bottom 5 states by Internet subscriptions
3. Top 5 states by Voice subscriptions
4. Bottom 5 states by Voice subscriptions
5. Voice and Internet subscriptions by quarter
6. The total number of voice and internet subscriptions

In the year 2021, there were 766 million voice subscribers and 567 million internet subscribers. This number is quite large given that Nigeria contains about 206 million people. Care observation shows that the distribution of the subscription is not uniform across the states as some states contain more subscribers than others. Across both voice and internet subscription, it is seen that Lagos state tops both groups and other states are Kano, Oyo, FCT, and Ogun states. Interestingly, this states are the top players in both subscription categories.

Thus, it is safe to say that these five states are the best locations for a telecommunication company to thrive in Nigeria as the target audience is here with Lagos state being the best.

Also, the analysis showed that Bayelsa, Ebonyi, Ekiti, and Zamfara states are the least players in both voice and internet category with Taraba state being an addition to the least subscribers to the internet and Gombe state being an addition to the least subscribers to the voice plan.

An additional insight that was obtained from the analysis was the subscription by quarter. The analysis showed that the first and second quarter are the best periods of the year as regards to subscription and there is a gradual and sharp decline which starts around the third quarter. The implication of this is that these periods should be the period where the entrepreneur intensifies his means to obtain sales such as increase in advertisement so as to maximize this period.

This is a project by Team 9(THE NINE) of the portfolio Bootcamp an initiative of Side hustle Ng using Excel and Power BI which are powerful analytical tools, with visualization that would assist us in understanding the Nigerian dynamics in 2021 . CC:

Okpara Kingsley, Busari Rokibat, Aneke Esther, Oluwatobi Oni, Toyeebat Nababa, Addo Victor, Iwu Janet, Christiana Adegoke, Chinwendu Nwosu, Joy Gabako,