Skip to content

Latest commit

 

History

History
45 lines (34 loc) · 1.86 KB

File metadata and controls

45 lines (34 loc) · 1.86 KB

Playstore App Analysis and Visualization

Project Description

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.

Tech Stack

  • Python
  • MySQL
  • Google Bigquery
  • Power BI
  • Microsoft Excel

Project Overview

  • Python for data cleaning
  • Google Bigquery and MySQL for running queries on the cleaned data
  • Power BI for creating an interactive dashboard

Data format

Data is cleaned and stored in MySQL for querying, and the results are then displayed on the Power BI dashboard.

Team Members

  • G.K. Jennifer
  • Uchanma Adeola Igbokwe
  • Amul Gaurav

How to contribute

  1. Fork the repository
  2. Create a new branch with a descriptive name
  3. Make changes and test thoroughly
  4. Create a pull request

Presentation

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 Play_store_dashboard_1

I created a second dashboard specifically for the playstore user. Find below

-DASHBOARD 2 Play_store_dashboard_2