Software development · Our own product

We built a learning platform for data analysts.

We designed and built AnalystQuest, a free, game-like course where you practise SQL, Python, Excel and Power BI on one fictional store’s data, right in the browser.

  • 7 tracks
  • 550 levels
  • English + Spanish
  • Built in 5 days
The challenge

No single place to practise the whole job.

AnalystQuest started as a practice tool for one person training to become a data analyst. She needed somewhere to practise every tool her course covered, on data that looks like the job.

Courses teach by video. Practice sites cover SQL only. Nobody let you practise SQL, Python, Excel and Power BI on one realistic business dataset, the way an analyst moves between them in a normal week.

What we built

A game built on real analyst work.

An AnalystQuest SQL level mid-solve: a ticket from Lauren Hayes, a LEFT JOIN query in the editor, the result table, and Mote's checker saying the order_id column is extra
A SQL level mid-solve. The query ran, and the checker points out one extra column.
Real tickets

Requests from colleagues

Every level is a request from someone at Harbor & Pine, a fictional US home-goods store with customers, orders and returns, messy rows included.

Real code

Run and checked in the browser

You write real SQL, Python, Excel formulas or DAX. It runs on the spot, and the checker says in plain words what is still off.

A reason to return

A game you come back to

Each track is a map of lanterns. Solve a level and it lights. Mote the moth cheers you on, stars reward clean runs, and a finished track earns a certificate.

Design

A dusk world, and lessons that explain why.

The learning sits inside a world: a coast at dusk, lanterns to light, and Mote, a moth with a lantern, as your guide. Each chapter opens with a concept lesson that explains why something works before you use it, with diagrams that step through what the engine does.

The SQL track map: chapter 1 SELECT basics as a path of lanterns ending at a lighthouse, Mote next to a ticket from Jessica Turner, and chapter 2 below
The SQL track map. One path of lanterns per chapter.
A concept lesson diagram, step 4 of 6: Charles in the customers table matched to his one order, adding one row to the result
A concept lesson stepping through a JOIN.
Engineering

Real engines, and no servers.

In the browser

Real engines on your machine

SQL runs in DuckDB and Python runs with pandas, both inside the browser. We wrote our own Excel and Power BI (DAX) engines. No server runs anyone’s code.

Hosting

A static site with sign-in

The site is plain static pages. Google sign-in keeps your progress across devices, and every certificate has a public page that verifies it.

Quality

Every answer is tested

Each level’s answer is tested automatically before release. A checker compares every Spanish page with the English one, so both teach the same thing.

Results

Live in English and Spanish.

AnalystQuest is live and free at analystquest.com, with the full Spanish version at /es/. Finish a track and you get a certificate like this one, with a link anyone can open to check it.

The AnalystQuest certificate of completion for the SQL track, marked sample, with the learner's name, stars and XP, a lantern seal and a verify QR code
The SQL track certificate, shown as the public sample.

Have a product of your own in mind? We design and build it end to end.

More case studies: AudioGo · Fight Fit