Kusto Detective Agency
Solve detective cases by querying large datasets with KQL
Kusto Detective Agency is a detective game played with data. Each case arrives in your agency inbox with a story and a dataset, and you write Kusto Query Language (KQL) queries to find the culprit, the hidden number or the next lead. You then type the answer back in to close the case and unlock the next one. Cases are grouped into seasons.
Free · Login needed · Browser
About Kusto Detective Agency
It teaches KQL and the general skill of investigating large log-style datasets with filters, joins and aggregations. Early cases suit beginners and later ones get hard.
It runs in the browser against a free Azure Data Explorer cluster, which needs a Microsoft account. There is no cost.
Made this game? Claim it →
Tips and discussion
No tips yet. Solved it? Share how, and wrap answers in ||spoilers||.