Logo

About

We download apps from the App Store every day and enjoy the fun of App Store games! we have provided the mobile game data, and you will be the analyst to help track bugs and issues, provide a better monetization strategy, and improve user engagement.

Dashboard

Introduction

In this project we used Excel Power Query for data Preprocessing and Transforamtion and Power BI for visualization.
Throughout this challenge, we will identify some interesting questions within an App Store Games dataset.

Questions

  • What is the 5 most popular games from 2008 to 2019 yearly?
  • What game developer had the highest average game rating?
  • Who are the 3 game developers to have most income from their app store games during 2008 to 2019?
  • What is the average rating and price trend for the games from 2008 to 2019?
  • Which is the most popular language for the games in App Store from 2008 to 2019?
  • What are the 3 games to have most user rating count from 2016 to 2019?
  • What are the most popular game genres every 3 years since 2008?
  • For the new developers to start App Store, what is the price recommendation for them?
  • For the new developers to start App Store, what is the genre recommendation for them?
  • Can we find any correlation between genre, game size and size ( bytes)?

    • Recommendation

    The recommended pricing strategy for new developers is 3.40 $. To gain acceptance, it's advisable to offer a free version initially before transitioning to a paid model. The 3.40 $ price point was chosen as it reflects the average cost of paid games.
    The recommended genres for new developers is Simulation, Strategy, Action, Puzzle.
    Am think there is no correlation between genre, game size
    I found over 9400 brows in this data that didn't have a rate and number of rates, so I hide this data to get a correct result after that, the total games I worked on were 7561 games
    I assume that all users who rated these paid games are the ones who spent money on these games.