Overview

An investigation into the global decline of video game sales using a Kaggle dataset. I cleaned the data in Excel and built an interactive Tableau dashboard featuring dynamic summary tiles, genre breakdowns, calculated fields, and data storytelling text boxes.

Tools Used: Excel · Tableau · Data Cleaning · Data Storytelling

Source: Kaggle (Global Video Game Sales dataset)

Original article: Read on Medium ↗

Live Dashboard: View on Tableau Public ↗

🌟 STAR Method Breakdown

Situation

This dataset tracks global sales of video games and their genres across multiple years. There had been a notable and sustained decline in global video game sales, but the underlying reasons were unclear and difficult to track.

Task

The video game sales data was downloaded from Kaggle. The dataset was incomplete; some years of sales data were missing. The goal was to track and visualise the sales performance of video games over time and uncover the drivers of decline.

Action

I built an interactive Tableau dashboard to track sales performance and show trends in games published and their genres. Key steps included:

• Data cleaning in Excel: formatted sales figures to currency and units, handled missing year data
• Calculated fields & parameters in Tableau for effective visualisations without chart overload
• Dynamic summary tiles to display headline KPIs at a glance
• Floating text boxes added for data storytelling, explaining each chart's insight directly on the dashboard
• Key recommendations embedded in the dashboard for stakeholders

Result