An Excel based descriptive analysis of global video game sales for GameCo, a fictitious company, to advise of new marketing strategies
Perform a descriptive analysis on global video game sales to inform the development of new video games
Descriptive analysis, Grouping data, Summarizing data, Visualizations, Presenting Results
Excel, PowerPoint
Profiling Data
Cleaning Data
Create Pivot tables to group data
Create calculated Fields
Conduct descriptive analysis to help answer business questions
Utilize Excel to create visualizations of insights gained
Utilize PowerPoint to present insights
•To allocate the marketing budget most efficiently, in North America and Europe focus on the top performing genres; Action, Sports, and Shooter games. In Japan, the marketing budget should be focused on Role-playing, Action, and Miscellaneous games.
•Focus on the EU region; North America has had a steady decrease in sales while EU has steadily increased passing NA in proportion of global sales this year
•Even though Nintendo, Electronic Arts, and Activision are the biggest competitors in North America and Europe, we should keep a close eye on Take-Two Interactive as they are our biggest competitor in Action games in those markets.
TAKEAWAYS
Assumptions should never be taken as fact but rather tested for validity as this analysis disproved the original GameCo assumption.
Copyright © 2022 Shey LeGras - All Rights Reserved.
Powered by GoDaddy
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.