The telecommunications industry in Nigeria is a highly competitive and rapidly evolving sector. With a diverse and growing market, telecom companies face constant pressure to innovate and improve their services to attract and retain customers. Competitive insights are crucial for understanding market dynamics, customer preferences, and the strategies of key players in the industry. By analyzing factors such as market share, pricing strategies, service quality, and technological advancements, telecom companies can make informed decisions to enhance their competitive edge. This analysis aims to provide a short overview of the competitive landscape in Nigeria's telecom sector, highlighting key trends of active subscribers and actionable insights for stakeholders.
Disclaimer: All datasets was exported from (https://nigerianstat.gov.ng/download/1241133), which contain only voice data and reports do not represent any company, institution or country because data source was not extracted from any of the company database. All info are dummy dataset to demonstrate my capabilities in Power Bi.
- Highlighting key trends of active subscribers month on month and quarterly for year 2021
- Active subscribers revenue genereated Comparison amidst individual telecoms for year 2021
- Data Cleaning and Transformation, Using power query and Data analysis expression (Dax) was used for data transformation, measure, aggregation and manipulation on dataset.
- Exploratory Data Analysis
- Data Visualization (application of different chart like stacked column chart, funnel, silcer and cards).
- Identification of patterns and trends to get actionable insights for stakeholders.
- Dashboard Development
Automatically derived relationships are adjusted to remove and replace them with the necessary information, below is the dataset model.
Data visualization report display below charts for the final interactive dashboard view
Card ( To display the KPI metric) Funnel Stacked column Chart Slicer
From the visual, it is evident that MTN has the largest network service with a significantly higher number of subscribers compared to its competitors, such as Globacom, Airtel, and 9mobile.
In 2021, Globacom received 70% of active subscribers for telephony services, which is lower than MTN and only 2% higher than Airtel Nigeria. This indicates that more subscribers preferred MTN's network over the others.
I would love to delve deeper into the competitive report analysis, especially if the dataset included subscriber demographics and preferred services such as data service, voice service, SMS service, and roaming service. However, the provided dataset only contains information on active subscribers and revenue for voice services.
This dashboard is interactive, filter can be applied on calendar month and drill down/up on 2021 Quarterly/MOM Active Subscribers for Telephony Services by Operators Chart to achieve strictly quarterly information and overall info.