GameCo. Regional Sales Analysis
Project Overview:
GameCo, a new gaming company, is looking to allocate its marketing budget and plan development projects. They seek to leverage historical market trends to inform their decisions and determine if sales in various geographical regions have remained consistent over time.
​
Objective:
Tools:
Microsoft Excel
Microsoft PowerPoint
​
My Role:
For this project, I served as both a business intelligence analyst and storyteller. I managed the data from start to finish, delivering business insights and presentations, and sharing insights and recommendations with the executive team.
​
​
Data Overview
Data Set:
​
Skills and Techniques:
Exploratory analysis
Data cleaning
Grouping and summarizing data
Pivot tables, creating new variables
Descriptive analysis
Insight development
Data visualization
Presentation development
Storytelling
​
Key Business Questions:
Current company hypothesis: the sales among geographical regions have stayed the same over time?
Genre of games most popular?
Platforms leading in sales?
Publishers leading in sales?
​
​
​
Current Company Hypothesis
​
Using Excel, the data was explored, cleaned, and analyzed to address business questions effectively.
The current understanding can be easily challenged based on the provided data. GameCo's hypothesis that video game sales have remained consistent across various geographical regions over time is incorrect.
A line graph reveals that regional sales in North America, Europe, and Japan have fluctuated over the past five years.
​
​
Proportion of Regional Sales Over the Past 5 Years
Regional sales proportions have fluctuated over the past five years.
North America and Europe have had similar sales levels, while Japan has consistently had lower sales.
Japan experienced a slight increase in sales from 2015 to 2016.
North America led in sales until 2016, when Europe surpassed it.
​
Top Regional Sales per Genre
Top Regional Platforms
Top Regional Publishers
Analysis and Visualizations
Total Regional Sales Per Genre for Last 5 years
​
Top genres in North America: Action, Shooter, Sports
Top genres in EU: Action, Shooter, Sports
Top genres in JP: Role Playing, Action
​
Total Regional Sales Per Platforms
​
North America: X360 and PS2
Europe: PS3 and PS2
Japan: DS and PS2
​
Top Regional Publishers
North America: Electronics Arts, Activision, Nintendo
Europe: Electronic Arts, Activision, Nintendo
Japan: Nintendo, Namco Bandai Games, Capcom
​
​
Sales Trend Insights
​
Sales Trends and Regional Insights (1980-2016)
Fluctuating Sales: Sales have varied over the years, declining after 2008.
Regional Performance:
North America led in sales from 1997 to 2015 but declined rapidly post-2008, equaling Europe by 2016 when Europe surpassed it.
Japan consistently had the lowest sales but remained relatively stable.
Popular Genres:
North America and Europe: Action, Shooter, and Sports
Japan: Role-playing and Action
Leading Platform:
PS2 dominates sales in all three regions.
Top Publisher:
Nintendo ranks among the top three publishers in all regions.
Recommendations For Marketing Budget
