Game Co. Budget Analysis

Background

  • GameCo, a new video game company, wants to use global sales data to inform the development of new games.

Objective

  • Perform a descriptive analysis of a video game data set to foster a better understanding of how GameCo’s new games might fare in the market.

  • Answer key questions presented by various stakeholders.

  • Create a presentation catered to GameCo.’s executive staff.

Context

  • This is a project created during the Career Foundry data analytics course.

  • The analysis and visualizations were conducted entirely in MS Excel.

  • The presentation was created in Google Slides.

The data set was gathered from the website VGChartz. The data set can be found here.

Key Questions

Are certain types of games more popular than others?

Have any games decreased or increased over time?

How have the sales figures varied between geographic regions over time?

Current Understanding of video game sales according to GameCo.-

Sales across geographies have remained the same over time.

  • North America - top market

  • European Union, Japan, rest of world- secondary markets

Analysis Steps

  1. Cleaning and wrangling data

  • Identify datapoints with missing values, duplicates, and typos

  • Make corrections with imputation, averaging, or deletion

2. Group and summarize data using pivot tables.

  • Quickly access important data points and compare groupings.

3. Begin conducting exploratory and statistical data analysis.

  • Identify trends.

    • Sales appear to be trending downwards, and market shares are changing.

    • North American sales have dropped to nearly equal those of other regions.

    • EU is now the largest market overall.

    • Japan market has the largest market share for role-playing games.

4. Improve visualizations and create a deliverable.

  • Identifying trends in sales and answering key questions.

  • Action games are the most popular overall with 20% market share.

  • The European Union has overtaken North America in most metrics.

  • Different genres are more or less popular in different areas.

    • Role-Playing Games in Japan are a big market.

    • Racing games are biggest in the EU.