Chicago Crime Analysis - Level 1

Authored by Fredrik Lidefelt, Data Analyst at Klarna

Profile
data
Applicable experience & durations
junior (2h) · mid-level (1.5h) · senior (1h)
Evaluated skills
sqlpythonjupyter
About

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 are expected to use BigQuery to complete the SQL part and a Jupyter Notebook hosted on Google Colab to complete the Python part of the task.

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.

Included
  • Detailed code review scorecard
  • Project boilerplate (Jupyter Notebook/Google Colab)