Google Play Store App Analytics Dashboard

Table of Content

• Project Overview
• Key Business Questions
• Data Description
• Tools Used
• Dashboard Overview
• Visuals
• Key Strategy Groups
• Outcome
• Author

Project Overview

This Project explores insights from a public dataset of Android apps on the Google play store. Using Excel and Power BI , I performed cleaning, visual analysis, and strategic recommendations based on metrics like installs, ratings, reviews, pricing and more.

Key Business Questions

A. App OvervieW

• What is the total number of apps?
• What percentage of app are free vs. paid?
• Which app category dominates in quantity and popularity?
• What is the average rating of all apps?
• Which app are the most installed?

B. Pricing Strategy

• What is the average price of paid apps?
• How many apps are priced above $5, and are they worth it based on rating and installs?
• Is there a pricing trend based on app category or size?

C. Performance & Popularity

• Is there a correlation between app rating and number of install?
• Do high-rated apps also have high reviews or installs?
• Which app rank highest in installs but lowest in rating (or vice versa)?

D. Update Behavior

• How often are top-performing apps updated?
• Which Update frequency correlates with high installs or better rating?
• How does content rating relates to installs?
• Are larger apps getting more installs or better reviews?

Data Description

• App_Play_Store_raw_dataset
• App_Play_store_cleaned_dataset

Tools Used

• Excel (data cleaning & transformation)
• Power BI (visualization & dashboard)
• DAX (KPI metrics & calculations)

Dashboard Overview

• Playstore_App_Dashboard
• Playstore_KPIs_Summary

Visuals

• App_Play_Store
• Recommendation_Insight_Summary

Key Strategy Groups

1. App Category Strategy

• Focus on less saturated but high demand categories like Finance and Education.
• Avoid entering high saturated ones (e.g., Family, Games, Tools) unless you offer a strong differentiator.

2. ** Rating & Review Managements**

• Maintain regular app updates.
• Monitor user sentiment through reviews and use that to improve features.

3. ** Pricing & Monetization Strategies**

• Over 90% of apps are free-freemium or ad-based models work best.
• Test pricing strategies using A/B testing and keep under $5 where possible .

4. ** Update Frequency Strategy**

• Apps updated every 1-8 months perform better.
• Plan a consistent monthly update cycle based on user feedback.

Outcome

This project showcases data storytelling and strategy development using public app data. It’s ideal for mobile developers, product managers, and business analysts seeking to understand app performance and market entry strategies.

Author

Elujulo Margaret Kehinde [elujulomargaret@gmail.com](mailto: elujulomargaret@gmail.com)