Choosing a Data Modeling Technique | Dataford Interview Questions

Can you describe a scenario where you would choose a specific data modeling technique over another?

Using the supplied schema, write a query that produces an analytics-ready monthly revenue result. The query should include completed orders only and handle customers without a populated segment.

Output

One row per customer segment and calendar month
Columns: segment, revenue_month, completed_orders, revenue
Include only segments with completed revenue, order by segment ascending and revenue_month ascending

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
segment	VARCHAR(30)	Customer reporting segment

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
order_date	DATE	Date the order was placed
status	VARCHAR(20)	Current order status

order_items

Column	Type	Description
order_item_idPK	INT	Unique order item identifier
order_id	INT	Order containing the item
product_name	VARCHAR(80)	Name of the purchased product
quantity	INT	Units purchased
unit_price	NUMERIC(10,2)	Price per unit

Your question is Choosing a Data Modeling Technique. Start with the requirements and the three 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