Google Play store: Analysis of Applications

Inspiration

The Play Store apps data has enormous potential to drive app-making businesses to success. Actionable insights can be drawn for developers to work on and capture the Android market!

1. Prepare

1.1 Source: 

https://www.kaggle.com/datasets/lava18/google-play-store-apps

1.2 About the Data:

One CSV file of 2 MB was available.

2. Process

2.1 Tools Used:

Google Sheets

SQL BigQuery

Tableau

2.2 Data Cleaning and Sorting:

Duplicate rows were deleted and data types were corrected.

3. Analysis

3.1 To analyse what are the most installed app categories in Google Play store:

SELECT COUNT (apps) AS TotalApps, SUM (installs) AS installs, category

FROM `total-palisade-363411.play_store.apps2`

GROUP BY category

ORDER BY TotalApps DESC  

3.2 Content Rating of Apps in Play store

SELECT COUNT(apps)AS Apps, content_rating

FROM `total-palisade-363411.play_store.apps2` 

GROUP BY content_rating

ORDER BY Apps DESC 

3.3 To analyse what are the most popular Game genres in Google play store:

SELECT COUNT(apps) AS Games, genres

FROM `total-palisade-363411.play_store.apps2`

WHERE category = "GAME"

GROUP BY genres

ORDER BY Games DESC

3.4 To understand how many game applications are free

SELECT

(SELECT COUNT (apps) FROM `total-palisade-363411.play_store.apps2` WHERE category = "GAME") AS TotalGameApps,

(SELECT COUNT (1) FROM `total-palisade-363411.play_store.apps2` WHERE type = "Free" AND category = "GAME" ) AS FreeApps,

(SELECT COUNT (1) FROM `total-palisade-363411.play_store.apps2` WHERE type = "Paid" AND category = "GAME") AS PaidApps

4.Share 

4.1 Most installed app categories in Google Play store: 

Game applications are the most installed app category in google play store, followed by communication. 

4.2 Content Rating Apps in Google Play store

Most of the apps have a content rating of Everyone. Which means most application companies are targeting a larger audience. Apps with content rating of Everyone is 80% followed by Teen 11%. The least content rating apps is Adults Only 18+ with only 0.03% apps in Google Play store.

// Now we will be taking a closer look at games, as Games are the most installed application type in Google Play store.//

4.3 Popular game genre on Google play store:

When it comes to game genres, Action games are much more popular than Adventure and Racing, followed by Arcade games. 

4.4 Free vs Paid games on Google play store: 

92% of games on the play store are free to play games while only 8% are paid games. Which means free games on Google Play store are the type of applications which are dominating the application market.

Conclusion and Recommendations

Game applications are the most in demand and preferred applications by people on Google Play store. 

If a company wants to dominate the application market, it should consider developing free to play game applications on Google Play store. 

To view the above visualizations on my Tableau dashboard, click here