Global Sales Trends:

Regional Video Game Sales

Completed March 2023 (CareerFoundry)

  • GameCo Marketing Team and Game Development Department

  • Historical Video Game Sales from Popular Games

    • 1980 to 2016 (Source: VGChartz)

    • Excel Visualizations

    • Regional Marketing Insights

    • Domain-Specific Content Research

    • Data Pre-Processing

    • Grouping Data

    • Geospatial Analysis

    • Time Series Forecasting

    • Descriptive analysis

    • Visualizing Results in Excel

    • Marketing Presentations

    • Business Recommendations

  • Excel, PowerPoint

Context and Objective:

GameCo is a new video game company seeking to analyze global sales trends to inform its marketing budget for game development.

Effective Analyses Challenge Assumptions

The GameCo Marketing Team asked that this analysis address the assumption:

“Sales from geographical regions have stayed the same across time.”

To do this, I answered the following key questions:

  1. How have sales figures between geographical regions varied over time?

  2. Are certain types of genres more popular than others?

  3. Have any games decreased or increased in popularity over time?

  4. What other publishers will likely be the main competitors in certain markets?

Slide from a Powerpoint that summarizes key insights, that total sales have changed over time, both globally and regionally, accompanied by a line chart showing regional time series data

The Process

After familiarizing myself with historical video game sales data from around the world, I zoomed out to regional trends across time. First, I began with Market Sale Trends across the regions of interest: United States, Japan, North America, and Other

After familiarizing myself with historical video game sales data from around the world, I zoomed out to regional trends across time. First, I began with Market Sale Trends across the regions of interest: United States, Japan, North America, and Other. I discovered a steep decline in sales across regions. Setting the scene is the foundation of a good presentation.

Simplifying time series data into clear visualizations essential for storytelling.

Simplifying time series data into clear visualizations essential for storytelling.

I continued to address each question, choosing appropriate visualizations and consistent design across the exploratory analysis.

I continued to address each question, choosing appropriate visualizations and consistent design across the exploratory analysis.

This analysis focused on the changes from 2015 to 2016, specifically, and therefore required direct comparison charts. Callouts allow audience members to attune to the most important details, especially when navigating multiple variables.

This analysis focused on the changes from 2015 to 2016, specifically, and therefore required direct comparison charts. Callouts allow audience members to attune to the most important details, especially when navigating multiple variables.

Finally, I synthesized the results into a coherent PowerPoint presentation, with a clear agenda and focus. I concluded with budgeting recommendations tied to each key insight.

Finally, I synthesized the results into a coherent PowerPoint presentation, with a clear agenda and focus. I concluded with budgeting recommendations tied to each key insight.

Previous

Music Industry: Taylor's Era (Python, Tableau)