GameCo Video Sales Trend Analysis
Project Overview
The purpose of this project is to present a descriptive analysis of sales for a video game company using Excel to analyze data from 2012 through 2016 in order to present a marketing budget recommendation for the year 2017. The project aims to:
Analyze Game Popularity Trends: Assess the popularity of different game genres over time by examining sales figures, user ratings, and active player counts.
Competitive Market Analysis: Identify key competitors in various gaming markets by analyzing market share, game performance, and publisher activities.
Sales and Regional Performance Analysis: Investigate how the sales of various games have changed over time across different geographic regions.
Data Source
Video game sales data set. was drawn from the website VGChartz.
Tools & Skills
Software: Excel
Data Cleaning
Descriptive Analysis & Visualization
Deliverables
Key Questions
Are certain types of games more popular than others?
What other publishers will likely be the main competitors in certain markets?
Have any games decreased or increased in popularity over time?
How have their sales figures varied between geographic regions over time?
Analysis Process
1. Understand Business Questions
Identify and define key business questions to guide the data analysis process and align with project objectives.
2. Data Cleaning
Remove inaccuracies and inconsistencies to ensure data quality and reliability for analysis.
3. Conduct Descriptive Analysis
Analyze data to summarize and describe its main features, providing a clear overview of patterns and trends.
4. Visualize Insights
Create visual representations of data to highlight key findings and facilitate understanding.
5. Storytelling with Data
Craft compelling narratives using data to effectively communicate insights and recommendations to stakeholders.
Key Insights
North America is the largest market that has the highest sales numbers, followed by Europe and then Japan.
The gap between North America and Europe is narrowing. North America's share of the market is declining to 39% in 2016 and Europe's share is increasing to 33%
Action Games have sold more than 440M units, followed by Shooter games and Role-Playing games
Genre popularity can vary by region. The popularity of Role-Playing Games is higher in Japan, while Action, Shooter, and Sports games are higher in North America and Europe.
Recommendations
Our analysis has resulted in the following summary recommendation on how to allocate the 2017 marketing budget:
Additional Suggestions
Data-driven approach: Continuously monitor market trends, competitor activity, and campaign performance to adjust marketing budget allocation throughout the year.
Ability to adapt: Be prepared to adjust marketing budget allocation based on emerging trends, new products or platform releases, and unexpected market shifts.
Other factors: Look into other factors such as product development, operational costs, distribution channels, culture, and government regulations when allocating marketing budgets.