Analyzing the Active subscribers and revenue generated in respective telecoms in Nigeria | Using Power BI
# Competitive Analysis and Insights for Telecoms in Nigeria
## Introduction
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 (
nigerianstat.gov.ng), 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._
## Keys Focus Area
- 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
## Skills & Concepts Showcased
- 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
## Modelling
Automatically derived relationships are adjusted to remove and replace them with the necessary information, below is the dataset model.
## Data Vis …