Choose your character

It shows in the top bar and on your profile. Change it any time.

Projects/Wayfriend / Case study

The reminder question

Denver tested reminder notifications before planned meetups. Decide whether Wayfriend should send them in every city.

Case studyWayfriend · fictional company45 min3 stagesDatabricks → SQL → Recommendation

You write the recommendationIt goes to the growth lead. Say what the evidence shows and what still needs checking.

The situation

Wayfriend's growth lead, Theo Blum, ran a two-week pilot: Denver sent a reminder before most planned meetups, and the other cities sent a few. He wants to turn reminders on everywhere next week and asks you for a recommendation.

You have the reminder log and the meetup model your team built. Some reminders went out after the planned start, and one went out far too early, so not every reminder could have helped. Most reminded invites are in Denver, so a plain reminded-versus-not comparison would mostly compare Denver with everywhere else.

  • Data: the two-week reminder pilot and the Wayfriend meetup model.
  • You deliver a written recommendation to the growth lead.
  • The recommendation is reviewed against a four-point rubric; there is no single right answer.

The evidence

Databricks

1. Separate on-time reminders

Keep the reminders that went out in the hour before the planned start.

Reads:
reminders · clean_invites
Produces:
on_time_reminders
Time:
15 minutes
Open DatabricksOne Course in Databricks or All Access
SQL

2. Compare like with like

Compare meetup rates with and without an on-time reminder, inside each city.

Reads:
fct_meetups · users · on_time_reminders
Produces:
reminder_compare
Time:
15 minutes
Open SQLOne Course in SQL or All Access

3. Your recommendation

Use the reference evidence or your checked tables. Make the call, support it with a comparison, and say what would change your mind. Allow 15 minutes.

Case study access

Free

$0

Read all briefs and paths. Tool stages and written work are locked.

Keep browsing

One Course

$17.99/month · USD

Practice the stages in your chosen tool. Reference tables let you start at that stage.

Choose a course

All Access

$24.99/month · USD

Every stage in every format, plus optional spoken readouts using plates.

Your Work Gym account

Save your progress and pick up on another device. Your browser's progress comes with you.

We'll email you a link. It works once and expires in 15 minutes.

You can keep practicing without an account.