The dashboard shows a revenue drop. Is it a business change or a reporting issue?
Candidate review
Discuss a pilot ↗Illustrative scores · independent of your workspace edits
-- Keep the latest record for each order.WITH ranked AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY order_idORDER BY updated_at DESC) AS versionFROM orders)SELECT month, SUM(net_revenue) AS revenueFROM rankedWHERE version = 1 AND status = 'paid'GROUP BY month;
Code execution is disabled in this preview.
You can browse and edit the example files. Changes stay in this tab until you reset or leave.Data & analytics · Example candidate
Explain a change in reported revenue
Task outcome
Corrected the revenue count; all 3 reconciliation checks passed.
Delivered Query + decision memo
Score breakdown
Expand to see whyData investigation4.0/5
Finds repeated order records before interpreting the revenue trend.
Metric correctness4.0/5
Reconciles the latest paid records. Refund and currency rules remain open.
Analytical judgment5.0/5
Separates a reporting error from a decline whose cause is not established.
Decision readiness3.0/5
States the limitation clearly, but does not specify the next causal investigation.
How to read these scores
1 = major gaps · 3 = partially meets · 5 = fully meets. This example weights all four criteria equally.
These scores and excerpts are illustrative, not a live evaluation or a hiring recommendation. In the product, evaluations score submitted work against the configured criteria; missing evidence is identified separately.
Full findings and sources
Checks data quality before interpretation
Supported in this example
Reconciles the metric definition
Supported in this example
Distinguishes observation from cause
Follow-up needed
Optional follow-up
What would you check before attributing the remaining change to customer behavior?