GameCo
Overview
This project involves conducting an analysis for GameCo, a gaming company, to understand market dynamics, game popularity trends, and sales variations across geographic regions over time.
Context
As a professional data analyst, the ability to comprehend a problem, apply suitable analysis techniques, validate hypotheses using data, and communicate insights effectively is crucial. This project emphasizes developing end-to-end analysis skills, focusing on hands-on technical proficiency using computer software.
Market dynamics in specific regions
Changes in game popularity over time
Variations in sales figures across geographic regions over time
Data
Data Set
historical sales of video games (for games that sold more than 10,000 copies) spanning different platforms, genres, and publishing studios.
From https://www.vgchartz.com/
Process
After cleaning Data set, using Pivot tables and other functions for descriptive analysis by Excel.
Budgeting plan A and B are set with visualizations using Excel
Key Analysis
Although Europe and Japan are expanding markets, only Japanese publishers have seen revenue growth. à Europe is the initial target market, with other regions as a second choice.
Major publishers have their own genre-specific strengths, but Action is the most popular genre and one in which many publishers are equally active. (E.g. Activision: Shooters | EA: Sports | Nintendo: Platform, etc.)
Market Share changes significantly, in 2017 EU will become more important
Japan is the market only for Japanese publishers, not our market
The Action Genre is the most popular, focusing on the Action Gerne