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
5 Silas Frøkner
post Feb 15 2017, 03:52 AM
Post #1
Surfing in paradise
********
Group: Entertainment Mod
Posts: 61,043
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,683
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
lotita
post Feb 15 2017, 10:09 AM
Post #3
feminist icon
******
Group: Global Mod
Posts: 16,161
Member No.: 21,777
Joined: 21-April 15
 


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


Looks fantastic Silas!
Go to the top of the page
 
+Quote Post
5 Silas Frøkner
post Feb 15 2017, 08:22 PM
Post #5
Surfing in paradise
********
Group: Entertainment Mod
Posts: 61,043
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
5 Silas Frøkner
post Sep 9 2017, 11:56 PM
Post #6
Surfing in paradise
********
Group: Entertainment Mod
Posts: 61,043
Member No.: 3,474
Joined: 24-May 07
 





HAI


Stage 1 will be live before the next contest.

Songs of Thread is dead. Long Live the Songs of Thread.
Go to the top of the page
 
+Quote Post
Liаm
post Sep 10 2017, 12:18 AM
Post #7
Honey I rose up from the dead I do it all the time
********
Group: Entertainment Mod
Posts: 51,563
Member No.: 10,139
Joined: 7-December 09
 


Fab, looks great <3
Go to the top of the page
 
+Quote Post
#CodyDecides
post Sep 10 2017, 12:22 AM
Post #8
technique on fleek cause I'm ballet trained
*******
Group: Moderator
Posts: 20,130
Member No.: 21,308
Joined: 24-October 14
   No Gallery Pics
 


YOOOOOOOOO. I'm really digging this format!
Go to the top of the page
 
+Quote Post
HarryEzra
post Sep 10 2017, 12:24 AM
Post #9
Sit Down. Be Humble.
******
Group: AF Leader
Posts: 16,452
Member No.: 20,835
Joined: 20-April 14
 


Looks fab but ew Numerals I can never work them out :/
Go to the top of the page
 
+Quote Post
UltraReputation
post Sep 10 2017, 12:27 AM
Post #10
I'll be the actress starring in your bad dreams
*******
Group: Entertainment Mod
Posts: 23,227
Member No.: 20,947
Joined: 26-May 14
 


That looks INCREDIBLE. <3
Go to the top of the page
 
+Quote Post
5 Silas Frøkner
post Sep 10 2017, 12:31 AM
Post #11
Surfing in paradise
********
Group: Entertainment Mod
Posts: 61,043
Member No.: 3,474
Joined: 24-May 07
 


Thanks everyone! Can't wait for everyone to see the first stage

QUOTE(HarryEzra @ Sep 10 2017, 01:24 AM) *
Looks fab but ew Numerals I can never work them out :/

Noted! Will look at replacing them for stage 2.
Go to the top of the page
 
+Quote Post
MoistSummerFruit
post Sep 10 2017, 01:37 AM
Post #12
Life is so much queefier than we allow ourselves to think x
******
Group: Members
Posts: 17,935
Member No.: 18,639
Joined: 18-April 13
   No Gallery Pics
 


Omfg!! wub.gif
Go to the top of the page
 
+Quote Post
#CodyDecides
post Sep 10 2017, 03:35 AM
Post #13
technique on fleek cause I'm ballet trained
*******
Group: Moderator
Posts: 20,130
Member No.: 21,308
Joined: 24-October 14
   No Gallery Pics
 


QUOTE(5 Silas Frøkner @ Sep 9 2017, 05:31 PM) *
Noted! Will look at replacing them for stage 2.
I think you can just give everyone a choice to view either the Roman numerals or the contest number, unless that's not available. Also maybe add something to distinguish the 12-point system contest stats from the 18-point system contest stats?

idk, just going off the template you showed.
Go to the top of the page
 
+Quote Post
Riser
post Sep 10 2017, 04:48 AM
Post #14
Only here for the cereal
******
Group: Moderator
Posts: 8,544
Member No.: 19,534
Joined: 14-July 13
 


Oh yes, I'm fond of Roman numerals but I think switching to regular numbers would make it a lot quicker to find whatever you're looking for, so hopefully that can be implemented!

Really looking forward to seeing everyone's entry history pages and whatever else is on this database.
Go to the top of the page
 
+Quote Post
danG
post Sep 10 2017, 06:25 AM
Post #15
Danvīci
*******
Group: Chart Mod
Posts: 42,548
Member No.: 11,746
Joined: 30-August 10
   No Gallery Pics
 


looks amazing!

I'd also welcome an extra column for regular numbers kink.gif
Go to the top of the page
 
+Quote Post
dandy*
post Sep 10 2017, 08:02 AM
Post #16
Mansonette
******
Group: Members
Posts: 18,281
Member No.: 54
Joined: 7-March 06
   No Gallery Pics
 


Amazing! Maybe you could take over the new Buzzjack improvements also?
Go to the top of the page
 
+Quote Post
Harve
post Sep 10 2017, 09:52 AM
Post #17
cultural marxist
******
Group: Members
Posts: 15,951
Member No.: 4,718
Joined: 3-November 07
   No Gallery Pics
 


Hyped for this tbh.
Go to the top of the page
 
+Quote Post
burbe
post Sep 10 2017, 12:22 PM
Post #18
Lusts for Life
******
Group: Entertainment Mod
Posts: 5,416
Member No.: 21,753
Joined: 12-April 15
   No Gallery Pics
 


It looks so good! *.*
Go to the top of the page
 
+Quote Post
5 Silas Frøkner
post Sep 10 2017, 12:33 PM
Post #19
Surfing in paradise
********
Group: Entertainment Mod
Posts: 61,043
Member No.: 3,474
Joined: 24-May 07
 


Thanks everyone! It's really helpful to see the reaction and everyone's comments. Especially once the first bit goes live in the next couple of days!

QUOTE(Cody Bersten @ Sep 10 2017, 04:35 AM) *
I think you can just give everyone a choice to view either the Roman numerals or the contest number, unless that's not available. Also maybe add something to distinguish the 12-point system contest stats from the 18-point system contest stats?

idk, just going off the template you showed.
I can't translate Roman numerals into Arabic numerals within the tool itself unfortunately.

A 12/18 point identifier is a good idea! Will add that in for the next release for sure.


QUOTE(danG @ Sep 10 2017, 07:25 AM) *
looks amazing!

I'd also welcome an extra column for regular numbers kink.gif

I'm really a fan of the Roman numerals so an additional column for the Arabic numbers would be a good idea. Will add this in to the next release too.

QUOTE(dandy* @ Sep 10 2017, 09:02 AM) *
Amazing! Maybe you could take over the new Buzzjack improvements also?


Probably still wouldn't come any sooner laugh.gif
Go to the top of the page
 
+Quote Post
SouthsideSpinner
post Sep 10 2017, 12:36 PM
Post #20
ayyy lmao
******
Group: Members
Posts: 19,853
Member No.: 21,005
Joined: 20-June 14
 


Slay mods cheer.gif
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: 25th September 2017 - 07:49 AM