Game Co.
Game Co. is a new video game company that wants to use data to gain a better understanding of how their games will fare in the market for the upcoming year. Game Co’s executives assume that sales across various regions have stayed the same over time
Objective: Perform descriptive analysis of a video game data set to gain a better understanding of how GameCo's new games would fare in the market
Procedures: Data Cleaning, Grouping Data, Summarizing Data, Descriptive Analysis, Visualizing results in Excel, Presenting results
Tools used: Excel, Powerpoint
Data: VG Chartz
Are there certain games that are more popular than others?
What other publishers will likely be the main competitors in certain markets?
Have any games increased or decreased in popularity over time?
How have their sales figures varied between geographic regions over time?
KEY QUESTIONS
RESULTS
Sales globally have changed significantly from year to year peaking around 2008 and declining since
Sales in proportion to global sales show that Europe and Japans sales are on an uptick and North America is on the decline
North America historically was top in sales but just recently was passed by Europe
Japan and North America's sales trends are almost mirror opposites
Chose visualizations from 2006-2016 as it was most relevant to forecasting future trends
North America and Europe's most popular genres are: Sports, Shooter & Action
Japan's most popular genres are Role-playing and then Action
RECOMMENDATIONS
The top priority for the 2017 Marketing budget is to focus on North America and Europe as they control about 70% of the market
Special attention to Sports, Shooter, and action genres in North America, Europe, and other
Special attention to Role Playing and action in Japan