Projects/Wayfriend / Journey
Your first 90 days as a data engineer
You've joined Wayfriend, a fictional meetup app, as its second data engineer. Turn raw app events into a measure the product team trusts, then use it to answer real questions.
Next: from invites to meetups.
This is 90 days of a fictional role, not a 90-day deadline. Work at your own pace. Your checked tables and chapter progress carry forward.
- Days 1 to 30Project
From invites to meetups
Wayfriend wants to know whether friends who plan to meet actually spend time together. Clean the raw events, model meetups, measure success and plan the next day of work.
Databricks → dbt → SQL → Dagster → Readout
Your first request: the product lead wants to know whether accepted invites turn into time together.
- Days 31 to 50Case study
The reminder question
Denver tested reminder notifications before planned meetups. Decide whether Wayfriend should send them in every city.
Databricks → SQL → Recommendation
Your meetup model is live. The growth lead wants to send reminders everywhere and asks what the pilot showed.
- Days 51 to 70Project
Keep the pipeline honest
Add freshness checks and alerts so a late load never reaches the dashboard.
Dagster → dbt
A late load put yesterday’s numbers in front of the leadership team.
Coming soon - Days 71 to 90Case study
Which city next?
Compare three candidate cities and recommend where Wayfriend launches next.
SQL → Databricks
Your quarter ends with a launch decision.
Coming soon
Your finish summary
Finish the chapters to make a summary of your work, the tools you practiced, and the decisions you supported.
Sharing is your choice. The summary describes practice at a fictional company.