Skip to content
Back to challenges
Dimensional Modeling FoundationsOpen Scenarioadvanced30 min

Subscriber health model

Create a model that helps product and finance teams understand subscriber acquisition, churn, and plan behavior.

How this preview works
Preview this problem before signing in. Sign in to save progress and submit work.

Concept

dimensional-modeling-basics

The primary modeling idea this problem reinforces.

Requirements

3

Business needs the model must satisfy.

Scenario

A streaming company wants a durable analytics model for subscriber growth, churn, plan mix, and reactivation trends across countries and acquisition channels.

Why this matters

Open scenarios are where modeling judgment matters more than rote correctness. This prompt forces the student to choose grains, separate attributes from events, and accept that several reasonable schemas may exist with different trade-offs.

Requirements
  • Support retention and churn analysis over time.
  • Answer plan mix questions by geography and acquisition channel.
  • Accommodate subscribers who cancel and later reactivate.
Analytical goals
  • Track active subscribers, churned subscribers, and reactivations by month.
  • Analyze plan mix and retention by country.
  • Understand which acquisition channels create the highest-quality subscribers.
Read-only starter workspace
Inspect the authored starting ERD, then open the workspace to edit and run the checks. Saving your progress needs a free account.

Template

Subscriber health starter workspace

The model users start from in the full workspace.

Entities

1

Seeded tables visible in the public preview.

Dialect

postgresql

Generated SQL target for this starter model.

Mini Map

This preview is read-only. Open the workspace to edit and verify; saving needs a free account.

Open workspace

Try the question first.

The discussion has other people's approaches and solutions. Give it a real attempt before you read them.