Power BI and SQL Under Pressure | Dataford Interview Questions

Explain how you would approach a medium to hard SQL and Power BI question when you have limited time.

Use the provided tables for the representative SQL portion. Explain how you would clarify requirements, produce a trustworthy result quickly, validate it, and shape it for Tiger Analytics Power BI reporting.

Output

Return one row per customer and calendar month represented in completed sales.
Include customer_id, customer_name, month_start, net_revenue, and revenue_rank.
Include unmatched sales customers, exclude non-completed sales, and order by month, rank, and customer ID.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
customer_id	INT	Customer associated with the sale
sale_date	DATE	Date of the sale
amount	NUMERIC(12,2)	Sale amount
status	VARCHAR(20)	Sale processing status

Your question is Power BI and SQL Under Pressure. 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