William Preddy

“Game Co.” popularity Analysis

• Objective-
  • Perform a descriptive analysis of Game Co.’s data set to foster a better understanding of how Game Co.’s new games might fare in the market. (Project brief)
• Skills-
  • Data Categorizing, Sorting, and Filtering
  • Data Cleaning
  • Using Pivot Tables to Group and Summarize Data
  • Conducting a Descriptive Analysis
  • Developing Insights
  • Visualizing Insights
  • Storytelling with Data

• Data-
  • Video games sales– provided by CareerFoundry (Sourced from VGChartz)
  • VGChartz’s data collection methodology

• Tools-
  • Microsoft Excel
  • Microsoft Word
  • Microsoft PowerPoint

Process Highlights

Problem: Sales’ mean was higher than the median.

Solution: Summarized the data and used “quartile.exc” function to identify outliers.

Problem: Not all data was useable.

Solution: Identified inconsistent or incomplete data using pivot tables and remove any entries that might affect results.

Data insights

Nintendo and Sony have been the top publishers over the last 35 years.

North American sales have been declining over the last 4 years.

The FIFA Soccer video game is the main contributor to the increase in sales in Europe.

In Japan, the most popular genre of video games is role-playing.

In contrast, in the rest of the world, action is the most popular genre.

Recommendations

PowerPoint reporting (Final report)

• Promote Top Publishers
  •  Allocate a larger percentage of marketing funds towards games published by Nintendo, Electronic Arts, and Sony Computer Entertainment.
• Emphasize North American Sales
  • Research decline in North American sales. Redistribute funds in the region to re-capitalize on large market.
• Support Emerging Games
  •  Allot more resources to games growing in popularity, like FIFA Soccer, in rising markets.