Junior (2h) | Mid-level (1.5h) | Senior (1h)
The goal of this task is to find answers to a list of questions about the crimes committed in Chicago by working with the Chicago Crime Dataset.
The candidate is expected to use SQL to query data and Python to manipulate data frames, perform basic statistics, and provide visualizations.
The candidate gets access to a private GitHub repository with the task description and a Jupyter Notebook.
They submit their solution by creating a Pull Request on their repository.
To assess the results, use the predefined code review scorecard that has the review instructions along with the reference implementation.