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?















