Video Game Sales Data Analysis

Technologies used: SQL Server (T-SQL), Excel, Power BI
Dashboard File: Video_Game_Sales.pbix
Dataset: VideoGameSales-DB.xls
T-SQL Queries: Video_Game_Sales_Queries.sql
Github: video-game-sales

The video game industry is a billion-dollar industry. Both the PC gaming market and the mobile gaming market generate billions in revenue each year and they will very likely continue on this trend with the increasingly frequent improvements in the technology behind the development of video games.

In this project, I analyse a dataset (source: Kaggle Datasets) about video game sales. After writing several T-SQL queries to examine the data and answer, I created a dashboard ( see above) in Microsoft Power BI to visualize and summarize some of its important aspects.

Some queries...

See the full list of queries here.

For each year, find the top-selling video game globally and the platform.

Input:

WITH max_by_year AS (
	SELECT [Year], MAX(vg2.[Global_Sales]) AS [Max_Sales]
	FROM VideoGameSales..vgsales vg2
	GROUP BY [Year]
)
SELECT vg1.[Year], 
	   vg1.[Name] AS [Top-Selling Video Game], 
	   vg1.[Platform], 
	   vg1.[Global_Sales] AS [Copies sold in millions]
FROM VideoGameSales..vgsales vg1 INNER JOIN
	 max_by_year mby ON 
	 mby.[Year] = vg1.[Year] AND
	 mby.[Max_Sales] = vg1.[Global_Sales]
ORDER BY vg1.[Year]

Find the 10 platforms with the most sales worldwide for each year in the 21st century.

Input:

WITH sales_plat_yr AS (
	SELECT [Year], [Platform],
		   ROUND(SUM([Global_Sales]), 2) AS [Total_Sales]
	FROM VideoGameSales..vgsales
	WHERE [Year] >= 2000
	GROUP BY [Year], [Platform]
),
max_by_year AS (
	SELECT [Year], MAX([Total_Sales]) AS [Total_Sales]
	FROM sales_plat_yr
	GROUP BY [Year]
)
SELECT spy.[Year], spy.[Platform] AS [Top-Selling Platform],
	   spy.[Total_Sales] AS [Copies Sold in millions]
FROM sales_plat_yr spy INNER JOIN
	 max_by_year mby ON
	 mby.[Year] = spy.[Year] AND
	 mby.[Total_Sales] = spy.[Total_Sales]
ORDER BY 1

Find the number of copies sold every recorded year for each genre.

Input:

DECLARE @answer NVARCHAR(MAX), @sql NVARCHAR(MAX);
SET @answer = (
    SELECT STRING_AGG('['+t1.[Genre]+']', ',')
    FROM (
        SELECT DISTINCT CONVERT(NVARCHAR(MAX), [Genre]) AS [Genre]
        FROM VideoGameSales..vgsales
    ) t1
);

SET @sql = 'SELECT *
    FROM (
        SELECT [Genre],
                CONVERT(DECIMAL(9, 1), [Global_Sales]) AS [Global_Sales],
                [Year]
        FROM VideoGameSales..vgsales
    ) base
    PIVOT (
        SUM([Global_Sales])
        FOR Genre IN (
            ' + @answer + '
        )
    ) [pivot_t]
    WHERE [Year] IS NOT NULL
    ORDER BY [Year]';

EXEC(@sql);

Citations

Gregory Smith. 2018. Video Game Sales, Version 2. [Online Resource]

I generally reply to email inquiries within 3-5 business days. The best time to reach me by phone is between 11am and 5pm during weekdays. Feel free to leave a message on my voicemail if I'm temporarily unreachable via phone call.

• olivieryannick5@gmail.com
• +1 (587) 987-2552
• Edmonton, AB, Canada