top of page

GAMECO

Analysis sales history and marketing Shares from 1980s. Find the best-selling genre and platform of video games.

Data

 

Analytical Techniques

  • Pivot tables

  • Data integrity, quality, and accuracy

  • Cleaning, grouping, and summarizing data

  • Conduct statistical analysis

  • Visualize and present insights

  • Used pivot tables to cross assess the most popular items  Used MS Excel to manipulate data

  •  Created different types of visualizations to underscore important point.

  • Analysis of sales trends in different geographies.

  • Identifying patterns in data

  • Drawing conclusions based on the trends and their behavior over time

Results

  • North America has had the largest sales globally, being at or above 50% of Global Sales until 2016 when Europe surpassed, with 38% of Global Sales and North America at 32% of Global Sales.

  • North America has a larger population and could be why they were the top selling region for the longest time, Japan has a smaller population and can play a role into why their sales are so much lower, and Europe is the only region who has had a steady increase in Global Sales.

  • North America has dropped the most being at 52% in 2008 and 32% in 2016. Europe was at 27% in 2008 and 38% in 2016. Japan was at 9% in 2008 and 19% in 2016.

  • Europe now has the largest sales globally.

  • North America and European regions have the same top 2 genres being Action and Shooter.

  • Japanese region’s top 2 genres are Action and Role-Playing.

Recommendations

  • It would be worth investing more into the marketing in Europe as they have a steady climb up in Global Sales. We could see a large increase in sales and therefor profit. Japan is also on the increase by 10%, you could increase the marketing budget and see how much they can increase their sales.

  • The budget should be allocated toward Action genre as all 3 regions have that in their top 2. Working on marketing for games already made in that genre or developing new games.

  • Some of the budget could also be allocated to Role-playing and shooter genre as those were next top genres in the 3 regions. I would not allocate as much as the Action genre would get.

  • As the data changes year to year, it is my recommendation to base budget on what platform has the most sales in each region.

  • C:\Users\cmas9\Downloads\Final-Project-Presentation-for-GameCo.pptx

bottom of page