Data
TData sourced from VGChartz
GameCo
Objective
The video game company GameCo wanted to inform the developement and marketing of new games. I performed descriptive analysis to gain insights into the current video game landscape for a marketing and sales’ team planning für 2017.
Techniques applied
Data Cleaning, Data Integrity and Quality (PivotTables), Data Grouping and Summarizing (Calculated Fields), Descriptive Analysis
Tools
Analysis
Key Questions
How did the total sales changed between 2007 to 2016?
Results
Total sales dropped all over the world for the retail sector
Key Questions
Which region has the highest propotion of total sales in 2016?
Results
There has ben a clear change in regional data in recent years as the especially the share of NA-sales in globals sales decreased, while the the share of JP- sales and EU-sales in global sales increased.
Key Questions
Which genre has the highest sales?
Results
Certain genres sell better in the different regions. E.g. shooter are the highest selling genre in north america, while puzzle is the highest selling genre in japan.
Further Insights
Recommendations
- North America market: As the competitiors are losing their retail sales in the NA market, GameCo could gain sales by doing targeted marketing for shooter games.
- Japan market: GameCo should focus their marketing on puzzles and role-playing games in japan.
- European market: The mayor focus should be on the development of the EU market since has the higehst sales propotion of the total sales at the moment. Genres like action, shooter and sports should be marketed.