GameCo Video Game Market Analysis

Assess GameCo’s video game sales and market trends, using Excel to analyze customer preferences, game performance, and regional opportunities; then report findings with PowerPoint.

Data:

VGChartz data set

VGChartz’s methodology

Techniques Applied:

Grouping Data, Summarizing Data, Descriptive analysis,

Visualizing results in Excel, Presenting Results

Overview:

GameCo is a new video game company aiming to leverage data for game development. Executives seek insights from historic market data to guide the publication of new games. Stakeholders are most interested in: Popular Genres, Market Competition, and Variation in Sales across regions over time.

1. Data Collection and Preprocessing

  • Data was sourced from internal sales records and third-party market reports. The dataset included game genres, sales figures, and customer demographics across regions.

  • Data was cleaned and analyzed in Excel, ensuring accurate trend analysis and market forecasting.

2. Key Visuals and Insights

  • Geographic Sales Trends
    Sales in North America have declined by 19% since 2010, while Europe has grown by 9% and now accounts for 38% of GameCo’s market share. This shift suggests the need for a more regionally focused sales strategy.

  • Top-Selling Genres by Region
    Shooter and Action genres remain the most popular globally, with Shooter games seeing a 34.76% increase in Europe. Racing and Simulation genres have significantly declined in popularity across all regions.

  • Publisher Competitiveness
    Major publishers like Electronic Arts and Ubisoft continue to dominate, with GameCo needing to evaluate potential partnerships or collaborative development to stay competitive.

3. Key Recommendations

  • Expand Focus on Europe:
    With Europe’s 38% market share, GameCo should shift at least 20% of its marketing budget to this region. Focus on Shooter and Action games, which are trending up across Europe.

  • Capitalize on the Shooter Genre:
    With Shooter games seeing significant growth, GameCo should develop new titles or form partnerships with top-performing publishers like Ubisoft to capture more of this market.

  • Reallocate Resources from Declining Genres:
    Genres such as Racing and Simulation are on the decline. GameCo should reduce development efforts in these areas and reallocate resources to more profitable genres.

  • Leverage RPG Growth in Japan:
    While RPG sales have declined globally, Japan remains a strong market for these titles. GameCo should localize RPG offerings and focus on culturally relevant content to increase sales.

  • Adopt Data-Driven Marketing:
    Use Excel’s analytics capabilities to track customer behavior and adjust marketing strategies dynamically. Real-time data can optimize campaign effectiveness and increase engagement across target regions.

This analysis offers a clear roadmap for GameCo to expand its market share by focusing on Europe, capitalizing on Shooter and Action genres, and adapting to regional trends with data-driven insights.

Previous
Previous

Influenza Staffing Plan Analysis