GameCo, Video Game Company

Background:

Games Co’s, a new video game company, understanding of sales is that the various geographic regions have stayed the same over time. Whether this is the case or not, the marketing budget needs to be redistributed among the regions in order to maximize return on investment.

Objective:

As a Data Analyst working for GameCo’s, I should perform a descriptive analysis of a video game data set to give a recommendation of how budget should be allocated.

Goal:

Create a presentation that includes visualizations telling the analytical story.

Dataset:

Historical sales of video games (for games that sold more than 100,000 copies) spanning different platforms, genres, and publishing studios. Source: VGChartz and link

First step- Data Exploration and Data Cleaning

getting acquainted with the data by doing aggregations through pivot tables, identifying data limitations (bias), performing data quality and accuracy checks (inconsistent formatting, duplicates, missing values).

Second step- Data Analytics

Perform histograms, bar charts, box and whisker plots, and scatter plots to compare data and discard outliers that affect the main statistics.

Third Step- Insights and Data Visualization

Game Co’s understanding of sales by geographic region assumes that sales and region market shares remained similar over time.

The data suggests that sales have been declining over time since 2009 and regional market shares also changed as well.

Among the major markets, only the European market trended upward. American market trended downward, while Japanese market stayed stagnant.



1. Action, Shooter, and Sport games are dominant genres in European Market and North American Market.

2. Both strategy and role-playing games have highest proportion of Japanese sales

Final Recommendations