SQL, Python, Power BI, Puzzle | Dataford Interview Questions

How would you use SQL and Python to analyze data, and how would you present insights in Power BI?

Use the provided customer, loan, and payment data. Produce a monthly payment-performance dataset that can be validated with Python and loaded into Power BI.

Output

One row per customer region and payment month.
Return region, payment_month, payment_attempts, successful_payments, collected_amount, and collection_rate_pct.
Include every month with payment attempts, including months with no successful payments. Sort by region, then payment_month.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer name
region	VARCHAR(50)	Customer reporting region

loans

Column	Type	Description
loan_idPK	INT	Unique loan identifier
customer_id	INT	Customer associated with the loan
loan_type	VARCHAR(50)	Loan product category
disbursed_amount	DECIMAL(12,2)	Original amount disbursed

payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
loan_id	INT	Loan receiving the payment attempt
payment_date	DATE	Date of payment attempt
amount	DECIMAL(12,2)	Payment amount
status	VARCHAR(20)	Payment processing status

Your question is SQL, Python, Power BI, Puzzle. 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