Video Game Sales Analysis for GameCo
GameCo, an emerging video game enterprise, aims to leverage data for refining the creation of new games.
Objective: Conduct a descriptive analysis on a video game dataset to enhance comprehension of potential market reception for GameCo’s upcoming releases.
-
Goals
Perform a comprehensive analysis of video game data spanning from 1980 to 2016 to provide strategic recommendations for GameCo in developing their 207 strategy for new game and content creation aimed at company expansion.
-
Skills & Tools
Excel
Translating business requirements
Data cleaning
Data integration
Data transformation
Statistical hypothesis testing
Visual analysis
Forecasting
Storytelling in Tableau
Presenting results to an audience
Analysis
Analyzed regional sales trends across game genres to identify top performing genres.
Highest performing game genres by region:
North America: Shooter
European: Sports
Japanese: Role-Playing
Even though overall global sales have been declining in recent years, we can see the European market has slowly started to take over a higher percentage of overall global sales.
-
Data Limitations
The dataset utilized for analysis comprises historical video game sales data sourced from VGChartz, encompassing diverse platforms, genres, and publishers from 1980 to 2016.
It monitored total units shipped rather than actual sales, thus lacking precise financial figures. Additionally, data collection was incomplete for 2016.
-
Recommendations
Reassess the marketing budget for 2017 as follows: allocate 45% of the budget to the European region, reflecting its increasing share of global sales, while maintaining 40% for the North American region.
The remaining 15% of the budget should be directed toward the Japanese region, which has consistently underperformed over the past decade.
Marketing strategies should be tailored to emphasize the most popular genres within each region, and consideration should be given to partnerships with leading publishers to enhance reach and drive sales.