Initial Exploratory Data Analysis On Japan Console Game Sales with SQL & Tableau

Japan’s video game market overview from 1980–2015

Introduction

Introduction

This dataset contains a list of video games sales in NA, EU and JP region. It was generated by a scrape of vgchartz.com.

Fields include

1. Rank — Ranking of overall sales
2. Name — The games name
3. Platform — Platform of the games release (i.e. PC,PS4, etc.)
4. Year — Year of the game’s release
5. Genre — Genre of the game
6. Publisher — Publisher of the game
7. NA_Sales — Sales in North America (in millions)
8. EU_Sales — Sales in Europe (in millions)
9. JP_Sales — Sales in Japan (in millions)
10. Other_Sales — Sales in the rest of the world (in millions)

For the purpose of this article, I will be focusing on the Japan region.

Setup

Create Database

mysql> CREATE DATABASE console_game;

Create Table

mysql> CREATE TABLE console_games (
     game_rank integer,
     game_name varchar(1200),
     platform_name varchar(1200),
     game_year integer,
     genre varchar(200),
     publisher varchar(1200),
     na_sales float,
     eu_sales float,
     jp_sales float,
     other_sales float
 );

View Data

Select all to display data.

USE console_game;
SELECT * FROM console_games;

… 1000 row(s) returned

Check Null Values

The above query yields all records in columns where the values are NULL.

0 row(s) returned.

Data Visualizations

#Best 10 most popular platforms in Japan

#Top publishers

Nintendo, Namco Bandai Games, Konami, Sony, Capcom

#Most popular genres

#Sales Trend

#Genre Trend