Deal Flow
A medium Data Modeling mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
A housing marketplace records every view of a property listing and every lead a buyer submits on one, each with the buyer and the time. Each listing has a property type and sits in a neighborhood that rolls up to a city and a state, and the model has to yield the view-to-lead conversion rate broken down by location at any of those levels and by property type.
Summary
Sellers want buyers. Buyers want deals.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your data model on the schema canvas: tables, keys and relationships
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision