Walk Through Dataset Analysis | Dataford Interview Questions

Walk me through your analysis of this dataset.

Use the provided policyholder, claim, and payment data. Produce a regional claims summary that includes payment totals, closure timing, and records requiring data-quality review.

Output

One row per region, including Unknown for claims without a usable region.
Return region, claim_count, total_incurred, total_paid, average_days_to_close, and review_claim_count.
Include all claims, sort by claim_count descending, then region ascending.

Schema

policyholders

Column	Type	Description
policyholder_idPK	INT	Unique policyholder identifier
policyholder_name	VARCHAR(100)	Policyholder name
region	VARCHAR(50)	Policyholder region

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
policyholder_id	INT	Related policyholder identifier
opened_date	DATE	Date the claim was opened
closed_date	DATE	Date the claim was closed
incurred_amount	DECIMAL(12,2)	Expected total claim cost
claim_status	VARCHAR(20)	Current claim status

claim_payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
claim_id	INT	Related claim identifier
payment_date	DATE	Date of payment
payment_amount	DECIMAL(12,2)	Payment amount
payment_method	VARCHAR(20)	Payment method

Your question is Walk Through Dataset Analysis. 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