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. We then created a dashboard using Power BI to display the results. Additionally, we also used Microsoft Excel for data analysis and visualization.
- Python
- MySQL
- Google Bigquery
- Power BI
- Microsoft Excel
- Python for data cleaning
- Google Bigquery and MySQL for running queries on the cleaned data
- Power BI for creating an interactive dashboard
Data is cleaned and stored in MySQL for querying, and the results are then displayed on the Power BI dashboard.
- G.K. Jennifer
- Uchanma Adeola Igbokwe
- 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 Dashoard: https://vimeo.com/790742845 -For SQL Queries: https://vimeo.com/788420635
-DASHBOARD 1
I created a second dashboard specifically for the playstore user. Find below
-DASHBOARD 2
