Technology & AI · Data Analytics & BI

DataDetective: SQL Query Crime Scenes

Solve 6 business mysteries of increasing SQL complexity against a fictional e-commerce database. Practice translating business questions into query strategies using JOINs, aggregation, window functions, CTEs, and anomaly detection.

6 rounds MBA & Masters English, Español
All simulations Get started
Preview

Who it is for

An intermediate simulation for participants who already know the core concepts of the subject, designed for master's and MBA programmes.

How a session runs

  1. The instructor creates a session from the Eureka dashboard and invites the participants.
  2. Participants play 6 rounds. In each one they submit their decisions and the simulation calculates the results.
  3. The simulation can be run in English, Español.
  4. The instructor follows each participant's progress and results from the dashboard, and uses the class results for the debrief.

Decisions participants make

The decisions participants make during the simulation:

  • Analysis Strategy
  • Primary Dimension
  • SQL Technique

What participants track

What participants follow on screen as the rounds go by:

  • Your Investigation Plan
  • Case Log

Subjects covered

Designed for courses in Data Analytics & BI.

  • PyAnalytics: Code-Driven Insight Lab

    Interactive simulation where students make analytical method choices across 5 phases of a business analytics pipeline — data cleaning, EDA, customer…

    Executive · 5 rounds

  • Data Analytics for Business

    Junior data analyst at Brightline Supply Co. has 118 minutes to define a churn KPI, write defensible SQL, clean dirty data, and deliver a one-page…

    MBA & Masters · 4 rounds

  • NetGraph: Network Analysis Explorer

    Interactive exercise where students analyze business networks using graph theory — computing centrality metrics, detecting communities, testing…

    MBA & Masters · 6 rounds

  • The A/B Test Lab

    Run a real A/B test on a landing-page redesign for a small e-commerce brand.

    MBA & Masters · 4 rounds

See all Technology & AI simulations →

Ready to use DataDetective: SQL Query Crime Scenes with your students?

Contact us and we'll set you up with a free trial session.

Contact us