Manage End-to-End Data Projects | Dataford Interview Questions

Tell me about how you handle complex data analysis projects from start to finish.

For this SQL exercise, demonstrate the process by producing validated daily event metrics from the provided event records and event-type lookup data. Include only completed, dated events from January 3 through January 5, 2025, with nonnegative values and recognized event types.

Output

One row per event date and event name, with event_date, event_name, completed_events, unique_users, total_value, and average_value.
Order by event_date ascending, then event_name ascending.

Schema

raw_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(30)	Machine-readable event type
event_time	TIMESTAMP	Timestamp when the event occurred
status	VARCHAR(20)	Processing status of the event
event_value	DECIMAL(10,2)	Numeric value attributed to the event

event_types

Column	Type	Description
event_typePK	VARCHAR(30)	Machine-readable event type
event_name	VARCHAR(50)	Readable event name

Your question is Manage End-to-End Data Projects. 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