Dashboard Week Day 1: UK Street Crimes

by Andy Kriebel

The point of Dashboard Week is to get them working very, very quickly through a brand new data set each day. Some days require data prep, some don’t. Some days have complex data, some don’t. It’s a total surprise each morning.

The rules for dashboard week are pretty simple:

  1. They must work independently, unless otherwise specified.
  2. If data prep is required, they can use Alteryx or Prep.
  3. They must create a sketch of their plan for their dashboard and show this during their presentation.
  4. The dashboard they create must be uploaded to Tableau Public or Power BI Gallery
  5. They must write a blog post detailing their work throughout the day.
  6. At 3pm, they will present their data prep, sketch, viz, and anything else they would like to present.

For day 1, the team will be analysis data about UK Street Crimes (Link to data)

They MUST use the API. Build an Alteryx App that allows the user to pick a date range and category and enter a postcode. The app must then render a Tableau KPI dashboard automatically.