Preview of new Songs of and Stats threads, Say "f***ity bye" to Excel! |
Track this thread - Email this thread - Print this thread - Download this thread - Subscribe to this forum |
15th February 2017, 03:52 AM
Post
#1
|
|
Queen of Soon
Joined: 24 May 2007
Posts: 74,084 User: 3,474 |
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. |
|
|
15th February 2017, 04:56 AM
Post
#2
|
|
BuzzJack Platinum Member
Joined: 18 July 2010
Posts: 8,212 User: 11,502 |
Ooh, very impressive, looking forward to seeing your progress, Phil!
|
|
|
15th February 2017, 10:09 AM
Post
#3
|
|
feminist icon
Pronouns: she/her
Joined: 21 April 2015 Posts: 25,354 User: 21,777 |
Really excited about seeing this!!
|
|
|
15th February 2017, 02:26 PM
Post
#4
|
|
Jacob Alan~
Joined: 12 March 2015
Posts: 4,983 User: 21,664 |
Looks fantastic Silas!
|
|
|
15th February 2017, 08:22 PM
Post
#5
|
|
Queen of Soon
Joined: 24 May 2007
Posts: 74,084 User: 3,474 |
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 |
|
|
9th September 2017, 11:56 PM
Post
#6
|
|
Queen of Soon
Joined: 24 May 2007
Posts: 74,084 User: 3,474 |
HAI Stage 1 will be live before the next contest. Songs of Thread is dead. Long Live the Songs of Thread. |
|
|
10th September 2017, 12:18 AM
Post
#7
|
|
Brown cow, stunning!
Joined: 7 December 2009
Posts: 67,176 User: 10,139 |
Fab, looks great <3
|
|
|
10th September 2017, 12:22 AM
Post
#8
|
|
new hair, new tee, new Levii’s Jeans
Joined: 24 October 2014
Posts: 39,311 User: 21,308 |
YOOOOOOOOO. I'm really digging this format!
|
|
|
10th September 2017, 12:24 AM
Post
#9
|
|
The Lady Said Go Home!
Pronouns: He/Him
Joined: 20 April 2014 Posts: 22,030 User: 20,835 |
Looks fab but ew Numerals I can never work them out :/
|
|
|
10th September 2017, 12:27 AM
Post
#10
|
|
It's a cruel summer.
Joined: 26 May 2014
Posts: 35,256 User: 20,947 |
That looks INCREDIBLE. <3
|
|
|
10th September 2017, 12:31 AM
Post
#11
|
|
Queen of Soon
Joined: 24 May 2007
Posts: 74,084 User: 3,474 |
|
|
|
10th September 2017, 01:37 AM
Post
#12
|
|
Buffy/Charmed
Joined: 18 April 2013
Posts: 44,089 User: 18,639 |
Omfg!!
|
|
|
10th September 2017, 03:35 AM
Post
#13
|
|
new hair, new tee, new Levii’s Jeans
Joined: 24 October 2014
Posts: 39,311 User: 21,308 |
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. |
|
|
10th September 2017, 04:48 AM
Post
#14
|
|
The horrors persist, but so do I
Joined: 14 July 2013
Posts: 21,953 User: 19,534 |
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. |
|
|
10th September 2017, 06:25 AM
Post
#15
|
|
🔥🚀🔥
Joined: 30 August 2010
Posts: 74,572 User: 11,746 |
looks amazing!
I'd also welcome an extra column for regular numbers |
|
|
10th September 2017, 08:02 AM
Post
#16
|
|
Mansonette
Joined: 7 March 2006
Posts: 35,308 User: 54 |
Amazing! Maybe you could take over the new Buzzjack improvements also?
|
|
|
10th September 2017, 09:52 AM
Post
#17
|
|
Cœur poids plume
Joined: 3 November 2007
Posts: 18,129 User: 4,718 |
Hyped for this tbh.
|
|
|
10th September 2017, 12:22 PM
Post
#18
|
|
I Drink Wine
Joined: 12 April 2015
Posts: 10,485 User: 21,753 |
It looks so good! *.*
|
|
|
10th September 2017, 12:33 PM
Post
#19
|
|
Queen of Soon
Joined: 24 May 2007
Posts: 74,084 User: 3,474 |
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!
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? I can't translate Roman numerals into Arabic numerals within the tool itself unfortunately. idk, just going off the template you showed. A 12/18 point identifier is a good idea! Will add that in for the next release for sure. looks amazing! I'd also welcome an extra column for regular numbers 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. Amazing! Maybe you could take over the new Buzzjack improvements also? Probably still wouldn't come any sooner |
|
|
10th September 2017, 12:36 PM
Post
#20
|
|
Former iconic poster with no consistent posting style
Pronouns: Don't take em seriously tbh
Joined: 20 June 2014 Posts: 20,582 User: 21,005 |
Slay mods
|
|
|
Time is now: 25th April 2024, 05:48 PM |
Copyright © 2006 - 2024 BuzzJack.com
About | Contact | Advertise | Privacy Policy | Terms of Service