Casework

3 cases · 6 levels

Real analyst cases solved twice, in SQL and in pandas, on the same Harbor & Pine data. Each case opens when both tracks reach it.

Each case is a full piece of analysis a manager would actually ask for, answered with the same numbers in both languages.

Case 1 · 2 levels

Holiday season review

Opens when you finish:

  1. Boss Holiday season review in SQL
  2. Boss Holiday season review in pandas

Case 2 · 2 levels

Marketing cost per conversion

Opens when you finish:

  1. Boss Cost per conversion in SQL
  2. Boss Cost per conversion in pandas

Case 3 · 2 levels

Customer retention

Opens when you finish:

  1. Boss Customer retention in SQL
  2. Boss Customer retention in pandas

Megan Collins · Head of Sales

"Before the January kickoff I need the holiday story for 2025: how the season compared with the autumn months, which categories grew versus the 2024 holidays, and whether December beat November in each channel."

Light the next lantern