Building a Company Dashboard

Create a complete HR analytics dashboard for Acme Corp

[COMPANY_DB] · modules 1-3 · 15 steps

progress: 0/15 steps0%

# scenario

You just joined Acme Corp as a data analyst. Your manager, Sarah, needs a series of reports for the executive team. Over the next few modules, you'll build queries that power their company dashboard - from basic employee listings to sophisticated payroll analytics. Each lesson teaches you a concept, and then you apply it immediately to build the next piece of the dashboard.

# build

A dashboard showing employee directories, department summaries, salary analytics, and aggregated HR metrics.

# steps

step 01
Employee Directory - Basic View
# from getting-started/select-basics
open →
step 02[locked]
Engineering Team Roster
# from getting-started/where-filtering
step 03[locked]
Salary Leaderboard
# from getting-started/order-by
step 04[locked]
Top 5 Earners Widget
# from getting-started/limit-offset
step 05[locked]
Department Filter Dropdown
# from getting-started/distinct
step 06[locked]
High-Paid Engineers Alert
step 07[locked]
Mid-Tier Salary Report
step 08[locked]
Projects Missing Deadlines
step 09[locked]
Executive-Friendly Labels
step 10[locked]
Dashboard Summary Stats
step 11[locked]
Employee-Project Assignments
# from joining-tables/inner-join
step 12[locked]
Unassigned Employees Report
# from joining-tables/left-join
step 13[locked]
Department Headcount Chart
step 14[locked]
Overstaffed Departments Alert
step 15[locked]
Complete Dashboard: Payroll by Department
# from joining-tables/multiple-joins