Latest Site News

[Silas]

Hi All!

A part of my new job, not really new now that I've been here 11months, is data analytics. In particular I use this tool called Tableau. The best way to approach this type of tool is not to be data driven, but to come to it with a set of questions. Like "What did Ashton enter in the 8th decade" or "How many points have I given Espen" up to a wider "How many American artists have we seen in BJSC?'. Part of what I'd like to achieve in 2017 is to start to use these tools as an easier way of interacting with our vast amount of data. I imagine this happening in four stages over the next 10-12 months:

Stage 1 - The Songs
Songs of Thread to be converted to an interactive dashboard that you can search.

Stage 2 - Simple Stats
The beginning of the Statistics stage will aggregate statistics for the finalists

Stage 3 - Moderate Stats
Semi Final data will be dashboarded

Stage 4 - Difficult Stats
Complete level of detail. The ability to see who you voted for in what competition & a table of who you gave/received points to/from.


First three are achievable without too much hassle, just a significant time investment. However once the initial outlay has been done then we will start to see our resources threads updated a whole lot quicker - I will simply refresh the data source. I'm on holiday for the first three weeks of March, so the first Stage won't be live until some time in April.

The final stage is more complex purely because of the data that will drive it. It'll require a lot of trial and error to get the underlying data in a format that we can utilise effectively.

I've mocked up a quick dashboard using my TBO IX Final scoreboard to show you the kind of thing we can do with it. Press play below, and Tableau Public will open in a new window. You can't break it so click about and have a play!





So yeah this isn't really a feedback exercise because it's something I threw together in like 15 mins with a tiny shittly formatted dataset and isn't a reflection of the final product. Pretty much a proof of concept. When I'm ready to start posting stage 1 etc then there will be a chance to give some feedback on design and give me some of the questions you'd like to ask the data. Purpose of this thread is to make y'all aware of something that is progressing to the POC stage in the name of ~transparency~ and see what y'all think of the concept rather than the detail.

I'm currently on an intensive advanced training course for Tableau with work so this is no amateur hour affair, we will end up with a smart looking, very functional tool.