GameCo: planing a marketing budget

OVERVIEW

GameCo is a fictive video game seller present globally with its strongest markets in North America, Europe, and Japan. The management wanted to learn insights from historical sales data to introduce changes in the marketing budget, if necessary.

OBJECTIVE

The goal of this project was to conduct a complete end-to-end analysis of data set using an industry-standard tool Excel. During the data exploration process, summarizing, filtering, and grouping operations were performed with PIVOT tables, VLOOKUP, and SUMIFS functions.

DATASETS

The data set contains 16,600 observations with sales numbers for each game’s title from 1980-2020, as well as the game’s genre, platform, publisher, and publishing year.
VGChartz was the main source of data for this fabricated set.

TOOLS

Excel + PowerPoint

This study project was part of my data analytics course with CareerFoundry.

• PRESENTATION PDF
• PROJECT'S FILES

BACK TO PROJECTS