GitHunt
ME

meesumkazmi1/video-game-sales-analysis

This project analyzes video game sales data (1980-2020) using SQL and Tableau. The dataset includes game sales by platform, genre, publisher, and region. The project covers data preprocessing, SQL queries for insights, and a Tableau dashboard visualization.

๐ŸŽฎ Video Game Sales Analysis (SQL + Tableau)

๐Ÿ“Œ Project Overview

This project analyzes global video game sales data (1980-2020) using SQL-based data modeling and Tableau visualization. The dataset includes information on game sales by platform, genre, publisher, and region. The goal is to uncover key insights into best-selling games, popular genres, publisher performance, regional trends, and platform dominance.

๐Ÿ”น Key Features:

  • SQL-based data normalization (3NF) & query analysis
  • Insights on top-selling games, genres, platforms, and publishers
  • Tableau Dashboard for interactive visualization
  • Business recommendations based on findings

๐Ÿ”— Live Tableau Dashboard: Click here to view


๐Ÿ“Œ Dataset

  • Source: Kaggle / Public datasets (Sales data for games that sold >100,000 copies)
  • Time Range: 1980 - 2020 (Focus: 1980-2016 due to fewer reported sales post-2016)
  • Data Fields:
    • ๐ŸŽฎ Name: Game title
    • ๐Ÿ† Genre: Game category (Action, Shooter, Sports, etc.)
    • ๐Ÿข Publisher: Company that released the game (Nintendo, EA, Activision, etc.)
    • ๐ŸŽฎ Platform: Console or PC platform (PS2, Xbox, Wii, etc.)
    • ๐Ÿ“… Year: Release year of the game
    • ๐ŸŒŽ Sales: Global and regional sales (NA, EU, JP, Other)

Languages and Tools Used

  • SQL: For database management and queries.
  • Tableau: For creating interactive dashboards.

๐Ÿ“Œ Database Schema (3NF Normalization)

The dataset was transformed into a relational database with the following structure: