Prajwal Bukkan

Google Play Store-Data Analysis

The Google Play Store is the largest and most popular Android App Store. It is a digital distribution service operated and developed by Google allowing users to browse and download applications. It serves as the official app store offering Music, Books, Television shows, Games, Movies.

Objective:

The project aims to analyze the raw data set on Google Play store and provide meaningful insights in terms of App downloads, Ratings and Categories by creating Dashboards using QlikView which is one of the fastest evolving BI tool.

Overview of Dataset:

Features of the Dataset:

App- The name of the application.

Category-(Comics, Family, Games, Education , Business, Lifestyle).

Rating- Ratings by user vary from 0–5.

Type-Type of app whether Free or Paid.

Content Rating-(For teens, Adults, Everyone).

Installs-Number Of Installs.

Genre-A style or category of the app.

Analysis:

The dataset is cleaned, transformed and converted into a Dashboard using QlikView which enables us to easily access & read the data for better understanding & deriving conclusions from it.

The dashboard helps to monitor activities at a glance & provides key insights. You can explore the data that is shown in a visualization by using the title, drilling up or down columns, hovering over the charts and viewing the details of a data point in tables in QlikView. Exploration of this dataset leads to many interesting observations.

Take a quick look at the dashboard below-

  1. Pricing Strategy — Free Vs Paid?

One of the most prominent factor in determining the success of an app is its price, the above chart indicates that over 75% of all the apps are free. By this we can draw the conclusion that though the quality and offerings of the paid apps are better than free apps still Free apps are likely to be favored more than that of paid apps & Paid apps have relatively lower number of downloads.

2)Best Performing Categories-

The above pie chart clearly shows the most downloaded categories of apps & It’s easier to spot these percentages in a pie chart. It shows that Family & Games app have the highest market value. We can also see that Tools, Business and Medical apps are also emerging slowly.

3)Least downloaded Categories-

The pie chart above illustrates the category of the least downloaded apps of all. Clearly, it shows that the apps least used belong to the category of Art & Design, Auto & Vehicles, Beauty and Comics ,Events .

3)Installs wrt category-

As it is clear from the above figure that The Most number of App Installs on the play store are in the category of:

  • Family
  • Business
  • Game
  • Tools

4)Ratings top to bottom -

Ratings provided by users are very important factor as it is the mechanism to get feedback from the users & it determines whether the user will download the app or not. The funnel chart gives the clear picture of the Ratings of the apps from top to bottom & it shows that about 60% of apps don’t have any ratings. The top rated apps belong to the Business, Games or Family Category. Ratings form these three categories dominates the overall distribution. It is also interesting to find that the ratings vary from 1–5 & the average rating for all apps is 4.19.

5)Content Ratings-

Here in the above figure we have taken content rating as our dimension for the given Dataset & the bar chart on Content rating gives us a picture of the locally relevant content ratings like teens ,mature 17+ users that help to improve app engagement by targeting the right audience for the content on apps on the app store.

6)Categories bar chart wrt genre-

The bar chart On Categories with respect to Genre shows that the most common genre to make apps in or most used apps are Tools, Entertainment & Education. Business & Medical Apps also see good grossing. It shows that People are less likely to be satisfied with Photography, Action, Beauty, Comics.

Conclusion-

The analysis leads to the following conclusions that out of the 10838 apps , the Society is more inclined towards family, business, tools, games & medical apps & much less towards art & design, comics, beauty, parenting, events. The result also says that that we have drifted away from the traditional method of watching the news, shows ,entertainment on TV, and have now reverted to social media apps.

Acknowledgement-

Me, Prajwal Bukkan with my teammate Shweta Bhatnagar created this Blog as a part of the course work under “BI tool: QlikView Tech Workshop” at Suven Consultants , under the mentorship of Rocky Jagtiani Sir. We would like to express our sincere gratitude to Rocky sir for giving us the opportunity to create this blog.

Dataset: Googleplaystoredata.csv

References: QlikViewfileofAnalysis.qvw

Recommended: https://datascience.suvenconsultants.com

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store