Data Modeling for Business | Dataford Interview Questions

Describe a time when you used data modeling to solve a business problem.

For this SQL exercise, demonstrate the modeling approach with the provided product dimension and event fact data. Return a concise monthly metric view that can support business analysis.

Output

One row per TikTok product for January 2025, including products without qualifying events
Columns: business_unit_name, reporting_month, completed_events, total_value, and performance_band
Include only completed events dated in January 2025; treat missing qualifying activity as zero
Order by total_value descending, then business_unit_name ascending

Schema

business_units

Column	Type	Description
business_unit_idPK	INT	Unique identifier for a TikTok product or business unit
business_unit_name	VARCHAR(100)	Name of the TikTok product or business unit

business_events

Column	Type	Description
event_idPK	INT	Unique event identifier
business_unit_id	INT	Product associated with the event
event_date	DATE	Date on which the event occurred
event_status	VARCHAR(30)	Processing status of the event
event_value	DECIMAL(12,2)	Business value associated with the event

Your question is Data Modeling for Business. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem