My Second Data Analysis Project Experience: I’m Getting Better.

My first project experience has exposed me to the need to keep working on real-life scenario projects. Working on projects is not just about creating a portfolio to showcase my arsenal, but also one of the most important ways for me to learn more and put my skills into practice. The first project I worked on, the sales project, gave me insight into how to evaluate product performance and implement marketing and sales strategies. In the analysis process, I learned how to use other methods apart from the concatenate method to combine data. I, also, learned how to split dates using text to columns and how to combine them using the Day() &"/"&month&"/"&year() method. Furthermore, I learned the limitations of the Vlookup formula, how to combine the index and match functions to look for data, and how to link slicers to all charts. Although I learned all this before, I seem to have forgotten. The truth is, I would have assumed I already knew it if not for the project I worked on. Therefore, since then, I decided to keep on working on projects in order to relearn, learn more, and put my knowledge into practice.

I sourced data from kaggle.com. When navigating the site, I stumbled on Google Playstore data. Actually, I have always been curious to know the number of applications on the Google Play store. So, I believe the Google Playstore will give me more insight into all the applications on the site. I downloaded my data in CSV format and imported it into Microsoft Excel. Having taken a thorough look at the data, I set my goals and objectives for my analysis. Boom! The journey begins.

My first step in the data cleaning was removing the duplicate data and changing the cases (lower and upper to proper). I also used the trim function to clean the cell's space, deleted the blank rows, found and replaced data, and transformed the messy and disorganized data into an organized format. As simple as the stage seems, it took me one and a half hours. Yes, I mean almost two hours. Especially when I want to delete the multiple blank rows. That was such a time-consuming and hectic task for me. But thank God for my friend, YouTube. I learned an easy method through her. The method is simple, but I would not have discovered it if I hadn't been working on this project.

I was able to delete the multiple columns in just a minute. I gained my confidence back. I was like, oshey baddest! (In Davido's voice). After transforming the data to my taste, I created my pivot tables. Analyzing the data was just a smooth ride for me here. But when I wanted to count the total number of applications, I kept on getting zeros with the count function. Thank God for my friends, Google and YouTube. I got to learn the limitations of the count function. It only counts the number of cells in a range that contain numbers. I got to learn the CountA function. It counts the number of cells in all cells that are not empty. I felt very intense learning this again. I was like, "Yes, I am killing the data." lol!

After analyzing the data, I tried to communicate my findings and results as simply and compellingly as possible. I went to my friend, Youtube, to learn more about Dashboard and visualization. After a fastidious study, I started my design and I created this dashboard. Indeed, I’m getting better. I published this project on Github (https://github.com/Awaitingprof/Googleplaystore_project.git).

A toast to my next project!