Mega Thread Port Forum 'General AFL Talk' Thread Part 11

[RussellEbertHandball]

Cool coincidence, but how the **** do people know these things or have the drive to find out?

They have a database of AFL stats, probably downloaded from AFL Tables, probably use Microsoft Access, and do query searches.

If you watch Swamp's twitter account, the stats guy who works for broadcasters footy and cricket, people send him messages asking questions about players born a certain day, surnames, goals kicked on federal election dates etc type questions. He just has to type in 20-40 seconds worth of stuff into his query and press a button and he gets an answer.

 

[Chrizzt]

They have a database of AFL stats, probably downloaded from AFL Tables, probably use Microsoft Access, and do query searches.

If you watch Swamp's twitter account, the stats guy who works for broadcasters footy and cricket, people send him messages asking questions about players born a certain day, surnames, goals kicked on federal election dates etc type questions. He just has to type in 20-40 seconds worth of stuff into his query and press a button and he gets an answer.

Access? Whatyearisit.jpg

 

[RussellEbertHandball]

Access? Whatyearisit.jpg

What are Microsoft selling in these days? Their database basic software, like excel or word, has had bugger all improvements over 20 years.

 

[Grave Danger]

Maybe the SMA can find some more cash for them...

 

[chiwigi]

Maybe the SMA can find some more cash for them...

Good lord!

They genuinely believe players will be going just for the money. How high must they rate that ******* comp.

 

[Grave Danger]

Good lord!

They genuinely believe players will be going just for the money. How high must they rate that ******* comp.

What part of South Australia National Feeder League doesn't old Wrinkles get?

 

[Doctor Feel]

They have a database of AFL stats, probably downloaded from AFL Tables, probably use Microsoft Access, and do query searches.

If you watch Swamp's twitter account, the stats guy who works for broadcasters footy and cricket, people send him messages asking questions about players born a certain day, surnames, goals kicked on federal election dates etc type questions. He just has to type in 20-40 seconds worth of stuff into his query and press a button and he gets an answer.

They use web crawlers and scrapers that pull the data from various publicly available sources. They may also have champion data access. There is no database, they collect the data themselves in .csv format and use it in R-studio, Power BI, Tableau and the like.

 

[Jojay]

Maybe the SMA can find some more cash for them...

Good Lord!... The Player Retention Scheme 2.0...

Where the likes of Rudi Mandemaker and Gary McIntoch were payed mega dollars (in relative terms) to not join the then VFL (bankrolled in large part by the revenue generating power of the PAFC!!)

 

[LukeSA]

Maybe the SMA can find some more cash for them...

Hmm... a chance to play footy at a national level or stick around in a nothing feeder comp for the monies?

 

[It Just Is]

The AFL are offing minimum $70k. Beating that would send half the SANFL clubs even more broke.

 

[Chrizzt]

What are Microsoft selling in these days? Their database basic software, like excel or word, has had bugger all improvements over 20 years.

As Doctor Feel alluded to above, PowerBI is a big one for them now. In that regard Excel has been continually improved, the addition of PowerQuery/Get and Transform has been huge.

 

[Doctor Feel]

Excel is great at what it does. It's a good tool for simple analysis and it's cheap - particularly for corporates with microsoft licensing agreements. PowerBI often comes free as part company licensing agreement as they're trying to flog it off to build a customer base - then get people hooked on Azure and Sharepoint etc. as a result to rake in more cash.

 

[JUSTWORK]

Good lord!

They genuinely believe players will be going just for the money. How high must they rate that ******* comp.

And even if they were, good luck out bidding AFL clubs. Not happening.

 

[RossFC]

I reckon the SANFL should have a mid-season draft and poach AFL listed players by offering $400 a game + few drinks at the bar. That’ll show ‘em.

 

[Holden Hillbilly]

I reckon the SANFL should have a mid-season draft and poach AFL listed players by offering $400 a game + few drinks at the bar. That’ll show ‘em.

$200 + $200 in a brown paper bag and all the hot chips they can eat.

 

[RussellEbertHandball]

They use web crawlers and scrapers that pull the data from various publicly available sources. They may also have champion data access. There is no database, they collect the data themselves in .csv format and use it in R-studio, Power BI, Tableau and the like.

Who is they?

 

[Ford Fairlane]

Robbie Young debuting for St Kilda against Collingwood this weekend.

 

[Doctor Feel]

Who is they?

Most of the amateur stats guys on Twitter.

Internally the clubs have data warehouses and data feeds from champion data, catapult etc.

 

[chiwigi]

The AFL are offing minimum $70k. Beating that would send half the SA AFL clubs even more broke.

Fixed that for you.

 

[RussellEbertHandball]

Most of the amateur stats guys on Twitter.

Internally the clubs have data warehouses and data feeds from champion data, catapult etc.

The amateur stats guys seem to fall into 2 categories. Those who do detailed simulations and crunch a shot load of performance stats. They want an analytics type job at a club.

Then there are guys who just do simple queries to produce basic historical information with quirky outcomes. These guys aren't into the analytics they are just info junkies. Those sort of guys have been doing this for 10-15 years plus like Ron the Bear on Bigfooty and a couple of my mates who got bored with it after a few years. A simple software database does the job adequately for these types.

 

[Portmagpies36]

Would rather Robbie on the list over AJ...

Said that 2 years ago and was told by everyone on here that Robbie Young will never play AFL !
His disposal compared to AJ is elite.

 

[Portmagpies36]

Yes I always wondered if we might pick him up, but alas no. Good luck to him.

No we drafted players who can't kick have no physical presence and are as slow as treacle instead.

 

[Portmagpies36]

What part of South Australia National Feeder League doesn't old Wrinkles get?

Just final confirmation that he is suffering from dementia.

 

[Magus]

Robbie Young debuting for St Kilda against Collingwood this weekend.

Not an easy debut but hopefully he gets his hands on it a bit.

 

[OneGreatClub]

This is one week I hope Charlie Cameron targets a few. So many to choose from.