BuzzJack
Entertainment Discussion

Welcome Guest ( Log In | Register | Help )

Latest Site News
 
Reply to this topicStart new topic
> Preview of new Songs of and Stats threads, Say "f***ity bye" to Excel!
Track this topic - Email this topic - Print this topic - Download this topic - Subscribe to this forum
Silas
post Feb 15 2017, 03:52 AM
Post #1
Surfing in paradise
********
Group: Entertainment Mod
Posts: 57,701
Member No.: 3,474
Joined: 24-May 07
 


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.
Go to the top of the page
 
+Quote Post
Leonardo
post Feb 15 2017, 04:56 AM
Post #2
BuzzJack Platinum Member
******
Group: Members
Posts: 6,142
Member No.: 11,502
Joined: 18-July 10
 


Ooh, very impressive, looking forward to seeing your progress, Phil!
Go to the top of the page
 
+Quote Post
l♀tita
post Feb 15 2017, 10:09 AM
Post #3
feminist icon
******
Group: Moderator
Posts: 13,556
Member No.: 21,777
Joined: 21-April 15
 


Really excited about seeing this!! wub.gif
Go to the top of the page
 
+Quote Post
Jacob.
post Feb 15 2017, 02:26 PM
Post #4
Jacob Alan
*****
Group: Members
Posts: 2,106
Member No.: 21,664
Joined: 12-March 15
   No Gallery Pics
 


Looks fantastic Silas!
Go to the top of the page
 
+Quote Post
Silas
post Feb 15 2017, 08:22 PM
Post #5
Surfing in paradise
********
Group: Entertainment Mod
Posts: 57,701
Member No.: 3,474
Joined: 24-May 07
 


Thanks guys!

One of the things we can do with it is create mobile and tablet versions to optimise it for viewing there so people who mainly use BuzzJack on the iPhone can search the songs of thread really quickly and easily in a way that's been specifically designed for phones
Go to the top of the page
 
+Quote Post


Reply to this topicStart new topic

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


 

Lo-Fi Version Time is now: 1st May 2017 - 02:31 AM