The Task

Data analysis has been an area of interest in recent times, according to Wikipedia, data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. My team and I had our first task in my data analysis Bootcamp to source a dataset of our choice and make a product sales analysis. It was a bit difficult getting the dataset of my choice but I came across a telecommunication subscription made by Nigerians between November to December of 2018. The task featured Data Scraping, Data Cleaning, and Data Visualization. In the analysis, I could answer the following questions

• Total no. of subscriptions made in that time
• Distinguishing the type of subscriptions made in that time
• Top ten states where subscriptions were made
• Which service provider had the most subscribers?
• Which state will provide the highest revenue from subscription sales?

  The Process

  The Microsoft power bi was the tool I used to carry out this mini analysis. First, I transformed and cleaned the data on the power query editor and ensured my dataset was in good shape and ready to be visualized. There are two subscription types discovered in the dataset (Active Voice subscription and Active internet subscription). The clustered column, clustered bar charts, and cards were the favorites to make it to my canvas. I used the clustered column chart to represent the total subscriptions by subscription type. Then the clustered bar chart represents the top ten states where subscriptions were made. Finally, the cards represent the total subscriptions made and I further used them to split the total subscriptions by the service providers as shown in the image below:

  Conclusion

Insights:

1. It is safe to say that, for more revenue generation and profits, service providers should target Lagos, since it promises a large number of subscriptions.

2. Mtn is the most subscribed network for both voice and internet subscriptions.

3. In Q4 of 2018, users subscribed more for voice calls than they did for Internet subscriptions, which can also be deduced that there were more calls than internet browsing in that period.

Extra

This dataset can be drilled further to find out the state with the lowest subscriptions. Note that Q4 stands for Quarter 4 or Fourth Quarter. Like and drop a comment below.

Data source : https://open.africa/dataset/telcoms_subscriptions_2018/resource/ebb813e0-c984-4efe-a0cb-38ff15a188c6

#data #dataviz #powerbi #dataanalysis