top of page

Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

How to Create a Successful Video Game: Metacritic Score Reviews

Date

May 2023

Project type

Google Sheets, Tableau

Full Project Description

Tableau Dashboard

To read the full project report, use the "Full Project Description" link:

Based on data obtained through a Kaggle notebook, information and Metacritic scores for various video games released between 2001 and 2022 was analyzed. The data was obtained through a scrape of the public Metacritic website and manipulated using Google Sheets before being visualized in Tableau.

BACKGROUND:
Metacritic is a popular review website that was released on the Internet in 2001. The website encourages both formal critics as well as casual customers to review movies, TV shows, albums, and video games. The scores of the critics are weighted based on the prestige of the critic, then averaged together to form what is known as a 'Metascore'. I am a junior data analyst for a video game developer looking to release their next big game. The director of marketing has assigned me to look into current and past trends in video game releases.

Through this project, I was able to:
-Collaboratively clean and prepare data in Google Sheets using commands and filters
-Utilize pivot tables to perform analysis on trends in the data over various time periods
-Design an interactive report in Tableau to describe patterns found during analysis

Questions I answered with the data included:
-What time of year are video game releases most popular?
-What day are most video games released?
-Does the choice of console impact the receptiveness towards the video game?

bottom of page