Skip to content

PostgreSQL, SQL, and Tableau project that analyzes video game sales over a 40 year time period

Notifications You must be signed in to change notification settings

stephenaigner/VideoGame-Sales-Report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Video Game Sales Analysis

Project Description:

This project was an analysis on video game sales during their year of release in different regions from 1980 to 2020. The data was sourced from a public site: Data Source. I developed a PostrgreSQL database, imported the data (csv file) into the table, and performed a series of queries to analyze the data (see below). I then created interactive data visualizations with Tableau BI Software linked here: Tableau Data Visualizations.

Dashboard key metrics:

  • Video game sales performance during release year
  • Total sales count and percentage for each region
  • Yearly sales from 1980 - 2020
  • Sales for top 5 platforms, genres, and publishers
  • Filters for year, platform, genre, and publisher

Tableau Dashboard:

Screen Shot 2023-11-20 at 6 26 55 PM Screen Shot 2023-11-20 at 6 27 12 PM

Regional and global sales for each genre:

Screen Shot 2023-11-09 at 11 12 09 PM

Top 10 selling video games around the world:

Screen Shot 2023-11-09 at 11 14 14 PM

Top 10 selling video game platforms:

Screen Shot 2023-11-09 at 11 17 22 PM

Top 10 selling video game publishers:

Screen Shot 2023-11-09 at 11 18 40 PM

Regional and global sales over the years:

Screen Shot 2023-11-09 at 11 22 33 PM Screen Shot 2023-11-09 at 11 25 04 PM

Best-selling games from the top 3 genres:

Screen Shot 2023-11-09 at 11 27 04 PM Screen Shot 2023-11-09 at 11 28 15 PM Screen Shot 2023-11-09 at 11 28 45 PM

Best-selling games from the top 3 platforms:

Screen Shot 2023-11-09 at 11 30 10 PM Screen Shot 2023-11-09 at 11 31 14 PM Screen Shot 2023-11-09 at 11 32 01 PM

About

PostgreSQL, SQL, and Tableau project that analyzes video game sales over a 40 year time period

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published