This project was completed as a team effort by G.K. Jennifer, Uchanma Adeola Igbokwe, and Amul Gaurav. The goal of the project was to analyze and visualize data from the Google Playstore. It was undertaken as part of a live project organised by an organization named HiCounselor. HiCounselor is an organization that provides career acceleration by offering coaching and resources job seekers and professionals need to land their dream job. We used Python for data cleaning, Google Bigquery and MySQL for running queries on the cleaned data. Then, we created a dashboard using Power BI to display the results.
- Which apps have the highest rating in the given available dataset?
- What are the number of installs and reviews for the above apps? Return the apps with the highest reviews to the top.
- Which app has the highest number of reviews? Also, mention the number of reviews and category of the app
- What is the total amount of revenue generated by the google play store by hosting apps? (Whenever a user buys apps from the google play store, the amount is considered in the revenue)
- Which Category of google play store apps has the highest number of installs? also, find out the total number of installs for that particular category.
- Which Genre has the most number of published apps?
- Provide the list of all games ordered in such a way that the game that has the highest number of installs is displayed on the top.
- Provide the list of apps that can work on android version 4.0.3 and UP.
- How many apps from the given data set are free? Also, provide the number of paid apps.
- Which is the best dating app? (Best dating app is the one having the highest number of Reviews)
- Get the number of reviews having positive sentiment and number of reviews having negative sentiment for the app 10 best foods for you and compare them.
- Which comments of ASUS SuperNote have sentiment polarity and sentiment subjectivity both as 1?
- Get all the neutral sentiment reviews for the app Abs Training-Burn belly fat
- Extract all negative sentiment reviews for Adobe Acrobat Reader with their sentiment polarity and sentiment subjectivity
- Python
- Google Bigquery
- MySQL
- Power BI
- Python for data cleaning
- Google Bigquery and MySQL for running queries on the cleaned data
- Power BI for creating an interactive dashboard
Data was cleaned and stored in Google Bigquery and MySQL for querying, and the results were displayed on a Power BI dashboard.
- Uchanma Adeola Igbokwe
- G.K. Jennifer
- Amul Gaurav
- Fork the repository
- Create a new branch with a descriptive name
- Make changes and test thoroughly
- Create a pull request
Vimeo video links for the presentation of the project are provided below:
-For PowerBi Dashboard: https://vimeo.com/790742845
-For SQL Queries: https://vimeo.com/788420635
-DASHBOARD 1
I was also interested in creating a dashboard specifically tailored to a playstore user, as a result I created the dashboard below:
-DASHBOARD 2
