Day 3 of dashboard week, and today we were told to make a Tableau dashboard using data from UK police forces. We had to connect to a series of APIs in order to obtain the data, which we did using Alteryx.
I started by planning the Alteryx flow. I effectively concatenated a series of API GET calls, getting data from one call and using it to obtain more data from the next. I began with the Forces API, which returns the police forces available through the data.police.uk API. From this, I filtered down to the Metropolitan Police and the City of London Police, as I wanted my dashboard to focus on London. From there, I used the Neighbourhoods API to retrieve all neighbourhood IDs and names for those forces.
Next, we