Analyzing app performance to understand what drives success and uncover growth opportunities.
Overview
This project analyzes a Google Play Store dataset to identify the key factors that influence app success. By examining installs, ratings, pricing, and categories, the analysis uncovers patterns that inform product, growth, and monetization strategies.
business context
With millions of apps competing for attention, understanding what drives installs, user satisfaction, and where the market is oversaturated is critical for new app development.
objective
Identify the characteristics that differentiate high-performing apps and uncover underserved opportunities in the market.
Approach
- Cleaned and transformed raw data using PostgreSQL
- Removed 1,170 duplicate records and standardized key fields
- Converted pricing, installs, and reviews into usable numeric formats
- Structured analysis around key business questions
- Built a Power BI dashboard to explore trends and insights
impact
This analysis provides a data-driven foundation for:
- Prioritizing high-growth app categories
- Defining optimal pricing strategies
- Improving product-market fit
- Identifying underserved market segments
key insights
1. High-volume categories dominate distribution
- Game leads with ~590M installs and strong ratings (~4.24)
- Top categories: Game, Communication, Tools, Social, Family
2. Price is not a strong driver of perceived quality.
- Paid apps: 4.26 avg rating
- Free apps: 4.17 avg rating
3. Monetization strategy must align with user expectations
- $0–$5 range have the best balance of installs and ratings
- Apps > $10 have low installs and lower ratings
4. User satisfaction drives visibility and engagement
- High-rated apps have 338K+ average reviews
- Low-rated apps show significantly less with ~180 reviews
5. Clear market opportunities exist in high-demand, low-supply categories
- Saturated: Family, Game, Tools
- Opportunity: Communication, Social, Photography, Video Players, Entertainment
tools
PostgreSQL (data cleaning & transformation)
Power BI (visualization & dashboard)
