02 — Dashboards & BI

Interactive Business Intelligence Dashboard

Six charts on a music store's real sales data — revenue by country, monthly trends, top artists, genre breakdown, media type split, and how each sales rep performed. Use the filters to slice by year or genre and watch everything update.

Chinook · 11 tables · 18K+ rows SQL · Chart.js · In-browser

Loading Chinook database and rendering charts…

At a glance

—

Total Revenue

—

Tracks Sold

—

Top Market

—

Top Artist

—

Total Invoices

—

Customers

Filter

Genre

Charts & Visualisations

Revenue by Country

Top 12

SELECT c.Country, ROUND(SUM(i.Total), 2) AS Revenue, COUNT(*) AS Invoices FROM Invoice i JOIN Customer c ON i.CustomerId = c.CustomerId -- Year filter applied dynamically GROUP BY c.Country ORDER BY Revenue DESC LIMIT 12

Monthly Revenue Trend

Time Series

SELECT strftime('%Y-%m', InvoiceDate) AS Month, ROUND(SUM(Total), 2) AS Revenue FROM Invoice -- Year filter applied dynamically GROUP BY Month ORDER BY Month

Top 10 Artists by Revenue

Ranking

SELECT ar.Name, ROUND(SUM(ii.UnitPrice * ii.Quantity), 2) AS Revenue FROM InvoiceLine ii JOIN Track t ON ii.TrackId = t.TrackId JOIN Album al ON t.AlbumId = al.AlbumId JOIN Artist ar ON al.ArtistId = ar.ArtistId JOIN Invoice i ON ii.InvoiceId = i.InvoiceId -- Year filter applied dynamically GROUP BY ar.ArtistId ORDER BY Revenue DESC LIMIT 10

Genre Popularity

Distribution

SELECT g.Name, SUM(ii.Quantity) AS TracksSold, ROUND(SUM(ii.UnitPrice * ii.Quantity), 2) AS Revenue FROM InvoiceLine ii JOIN Track t ON ii.TrackId = t.TrackId JOIN Genre g ON t.GenreId = g.GenreId JOIN Invoice i ON ii.InvoiceId = i.InvoiceId GROUP BY g.GenreId ORDER BY TracksSold DESC LIMIT 8

Sales Representative Performance

KPI Cards

SELECT e.FirstName || ' ' || e.LastName AS Name, ROUND(SUM(i.Total), 2) AS Revenue, COUNT(DISTINCT i.CustomerId) AS Customers, COUNT(*) AS Invoices FROM Invoice i JOIN Customer c ON i.CustomerId = c.CustomerId JOIN Employee e ON c.SupportRepId = e.EmployeeId GROUP BY e.EmployeeId ORDER BY Revenue DESC

Revenue by Media Type & Top Albums

Segmentation

SELECT mt.Name AS MediaType, ROUND(SUM(ii.UnitPrice * ii.Quantity), 2) AS Revenue, SUM(ii.Quantity) AS Tracks FROM InvoiceLine ii JOIN Track t ON ii.TrackId = t.TrackId JOIN MediaType mt ON t.MediaTypeId = mt.MediaTypeId JOIN Invoice i ON ii.InvoiceId = i.InvoiceId GROUP BY mt.MediaTypeId ORDER BY Revenue DESC

Techniques used

What each concept means, in plain English.

SQL Aggregation GROUP BY · SUM · COUNT

Grouping rows and calculating totals — for example, adding up all invoice amounts per country to find which market generates the most revenue.
JOIN Linking multiple tables together

The database stores customers, invoices, tracks, and artists in separate tables. JOINs connect them — so a single query can answer "which artist made the most money" by tracing the path from sale to track to album to artist.
Dynamic Filtering Filter-driven SQL queries

Every chart re-runs its query when you change the year or genre filter. The SQL adapts on the fly — no pre-built views, no cached results. What you see always reflects the exact filter combination you chose.
Chart.js JavaScript charting library

A library that turns data arrays into bar charts, line graphs, and doughnut charts in the browser. Each chart here is drawn from live query results, not static images.