Tuesday's dashboard week objective was to analyse UK Street Crime data between September 2023 and September 2024. Part of this process was to build an Alteryx app that allowed users to access data for specific dates for specific areas. This app would then upload the data to our tableau server and be used to create a KPI visualisation for crime.
The flow filters out the selected postcode with its shapefile, and then performs a spatial match onto the points representing the crime locations. You do have the functionality of either selecting a postcode on the map, or writing out the postcode you are interested in.
Finally this is then output onto our tableau server which was then used to make a KPI Viz. One issue I found was locating shape files for UK postcodes, I did find shape files for the truncated post codes. For example the data school's full post code is EC4M 9BR. So with the shape files I found, the post code identified would be EC4M 9.
This was my first time uploading to Tableau server from Alteryx, and there are some setting which help ease the process.
Changing my DCM settings to these, allowed Alteryx to connect to our tableau server. I then used a personal access token, obtained from the account settings section with tableau server, to authorize connecting through the tableau output tool in Alteryx.
Finally I used the output data to create the KPI Dashboard (Currently filtered to the area around The Data School).
