This project delivers an interactive two-page Power BI dashboard built on 16,291 cleaned video game sales records spanning 1980 to 2020. It is the visualization layer of a full end-to-end data analytics project, transforming SQL-analyzed data into clear, actionable visual insights.
Raw sales numbers across 576 publishers, 31 platforms, and 12 genres are impossible to interpret in tabular form. This dashboard converts those numbers into a visual story any business stakeholder can read in under 60 seconds.
- Source: Kaggle — Video Game Sales by Gregory Smith
- Link: https://www.kaggle.com/datasets/gregorut/videogamesales
- Cleaned Records: 16,291
- Columns: 11
- Time Range: 1980 — 2020
- Note: All sales figures are in millions of units sold
| Tool | Purpose |
|---|---|
| Power BI Desktop | Dashboard design and interactive visualization |
| Python (pandas) | Data cleaning before import |
| SQL Server | Data storage and pre-analysis |
| GitHub | Version control and portfolio documentation |
Answers the high-level business questions at a glance.
Visuals:
- 4 KPI Cards — Total Games, Total Global Sales, Best Seller, Top Publisher
- Horizontal Bar Chart — Top 10 best-selling games of all time
- Donut Chart — Total global sales by genre
- Line Chart — Global sales trend by year (1980–2020)
Navigation button — links to Page 2
Answers the deep-dive business questions with full interactivity.
Visuals:
- Clustered Column Chart — Regional sales comparison (NA, EU, JP, Other)
- Table — Top 10 publishers by total global sales, game count, and average sales per game
Slicers (synced across both pages):
- Genre
- Platform
- Year range
Navigation button — links back to Page 1
-
Nintendo owns the top 10. Every single best-selling game of all time is a Nintendo title. Wii Sports leads at 82.74M.
-
Action dominates by volume but not efficiency. Action has the most games (3,251) but the genre donut shows sales are distributed relatively evenly across categories.
-
North America drives the industry. NA sales (4,327M) exceed Europe and Japan combined (3,690M). Any publisher choosing one market should choose North America.
-
Quality beats quantity. Nintendo generates 1,784M from 696 games (2.56M avg). Electronic Arts generates 1,093M from 1,339 games (0.82M avg). Fewer, better games win.
-
The industry peaked in 2008 at 679M then declined steadily. This reflects the untracked shift to digital sales post-2010, not an actual industry decline.
Total Sales Label = FORMAT(SUM(vgsales_cleaned[Global_Sales]), "#,##0") & "M"
Used to display Total Global Sales as "8,820M" on the KPI card with a proper M suffix and comma formatting.
- Dataset covers physical sales only — digital sales not included
- Data ends at 2020 — recent titles like Elden Ring are absent
- Some regional values show as 0 for older obscure titles
- Power BI's Top N filter and Sync Slicers features
- DAX FORMAT function for custom number display
- Dashboard layout principles — information hierarchy matters more than visual quantity
- The difference between Sum and Average aggregation in tables and why Power BI's weighted average in the Total row is correct
- Add drill-through pages per publisher
- Connect directly to SQL Server via live connection
- Add platform market share visual
- Incorporate post-2020 data
EDA and SQL analysis repository: https://github.com/THE-BALOG/CodeAlpha_EDA
Balogun David (TheRareEngineer) Mechanical Engineering Student | Data Science & AI/ML Enthusiast