๐Ÿ“ˆBusiness Intelligence Path

The board deck is due Friday.
The numbers need to be right.

Query a company operations database, build executive-ready reports, master window functions, investigate data quality issues, and learn to think like a BI analyst who never ships a wrong number.

See All Missions

25 missions ยท runs entirely in your browser ยท no account needed

How It Works

1

Read the briefing

A Slack message from your manager

2

Explore the schema

5 tables in a star schema

3

Write your query

Full SQL editor with autocomplete

4

Get expert feedback

Graduated hints, not just pass/fail

Why This Path

Executive Stakeholders

Answer questions from the CFO, VP of Sales, Head of Product, CEO, and department leads โ€” each with different expectations.

Hidden Data Traps

Trailing spaces, ghost regions, inactive employees, and category casing issues that break dashboards.

BI-Specific Skills

Window functions, YoY comparisons, moving averages, cohort analysis, self-joins, correlated subqueries, and full data audits.

Portfolio-Ready Skills

Every mission maps to a real BI analyst task โ€” board decks, QBRs, data audits, and executive requests youโ€™ll see on the job.

The Missions

Each mission is a real request from someone at the company. Difficulty increases as you go.

Starter5 missions
Easy5 missions
Medium5 missions
Hard5 missions
Expert5 missions

The Database

A company operations star schema with 5 tables, 2,700+ rows, and 10 planted data quality issues. Trailing spaces that create phantom products, ghost regions that vanish from INNER JOINs, inactive employees inflating performance reports, and more.

dim_employees (50)dim_products (20)dim_regions (6)fact_sales (2,500)fact_targets (168)

โ—dimension tables ย โ— fact tables

The CEO is waiting for answers

The dashboard numbers are wrong and she wants to know why.

Looking for something different?

|