Video Game Market Sales Analysis

I conducted initial observation on the data, filtering the data to look at certain aspects of the sales. I utilized pivot tables to summarize the data. During the cleaning process, I removed unnecessary columns and rows, incomplete data, and duplicate rows. I performed imputation on some of the data that showed no values, given each cell an average of the respective column. I conducted some reformatting to make it more readable.

Conclusion

• North America has dominated the market in sales over the years, in which there have been a gradual increase in sales up to the late 2000s. Each market region peaked in the late 2000s, specifically 2008 for North America, 2009 for Europe, and 2006 for Japan. Then there is a sharp decrease in sales since the late 2000s, which can be attributed to the introduction of digital sales.  
• North America and Japan’s sales fluctuated over time. Europe and Other regions show a steady incline in sales. North America had strong market sales until 2015, when Europe surpassed it.
• North America, Europe and Other regions share the same top 3 genres: Action, Sports, and Shooter. Japan’s top genre is Role-playing, followed by Action and Sports.
• Top 4 genre sales increased rapidly after 1995 until the late 2000s. The decline can be attributed to the introduction of digital sales.
• Nintendo dominates the market in all regions except Other, where it is 2^nd. North America and Europe share the same top 5 publishers. Japan only shares Nintendo with the other regions. Other region share the top 4 publishers with North America and Europe.

Recommendations

• Further analysis should be conducted to determine if the introduction of digital sales was attributed to the decline in sales.
• Executives should plan for a platform in which they can sell digital games.
• Partner with Nintendo to provide the highest marketing abilities for the release of games.
• Ensure adequate games in the respective popular genres for each region.
• Provide a solid marketing plan for Europe and Other regions to ensure the continuation of video game sales.