GameCo
Client
CareerFoundry
Year
2021
A new video game developer company wanting to use historical sales data to inform its decision making for creating new games and developing a marketing strategy
Assumptions
-
​Sales have stayed constant across geographical regions
-
Focusing mainly on Action / Adventure games will generate the most unit sales
Tools
-
Excel
-
PowerPoint
Data
-
Historical video games sales data
-
Source: www.vgchartz.com/
-
Data: (Excel)
Skills
-
Grouping & summarising data
-
Descriptive analysis
-
Visualisations
-
Presenting results
Analysis & Insights
Game Co.’s dataset was cleaned and analysed in Excel. Graphs were created to derive insights and to draw conclusions.dventure sales are declining
-
Sales declining since 2009 indicating fierce competition
-
Proportional sales by region have changed in recent years. A decline in NA and an increase in Japan sales
-
Respective market shares of Sports and Shooter games are growing whilst Action / Adventure sales are declining
Conclusions
-
Proportional sales by region have been changing over time
-
Action / Adventure games genre sales have been proportionately declining
Recommendations
-
Adjust the Marketing budget allocation in line with recent trends:
-
Increase Marketing spend in EU and Japan regions
-
Decrease Marketing spend in NA region
-
-
Focus resources across the four largest genres:
-
Increase resource allocation on Sports and Shooter games as these are growing markets where there is potential to increase the company’s market share
-
Offset against a reduction of investment in Role- playing (and possibly Action / Adventure) games which show declining market shares
-