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

Introduction

Setup

mysql> CREATE DATABASE console_game;
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
);
USE console_game;
SELECT * FROM console_games;

Data Visualizations

Nintendo, Namco Bandai Games, Konami, Sony, Capcom

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store