The point of Dashboard Week is to get the team 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:
- They must work independently, unless otherwise specified.
- If data prep is required, they can use Alteryx or Tableau Prep Builder.
- They must create a sketch of their plan for their dashboard and show this during their presentation.
- The dashboard they create must be uploaded to Tableau Public or Power BI Gallery, unless otherwise stated.
- They must write a blog post detailing their work throughout the day.
- 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 analysing data about UK Street Crimes between March 2022 and March 2023 (link here)
Use the data in the link to build an Alteryx App that allows the user to pick a specific date range, category and area (using a map interface tool) or postcode to update a data source onto our tableau server (or tableau public using google sheets or Power BI workspace) to feed into a Tableau or Power BI KPI dashboard.
Make sure to reference the source before publishing: https://data.police.uk/data/
Good luck!