Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
02-10-2020 21:04 PM - last edited 02-20-2020 18:04 PM
During the 2017 season of Major League Baseball, the Houston Astros were caught cheating. The team was using technology (use of tech is illegal) to relay signals from the opposing team to their hitters, improving their offensive numbers in the process. The means of the signal-relaying was banging a baseball bat against a trashcan, heavily alluded to in the report.
One dedicated Astros fan was able to record a bunch of the at-bats, then published his findings to a spreadsheet database (a .csv @ signstealingscandal.com). As a PowerBI user and Baseball fan, I decided to visualize the data to see the impact of the cheating in 2017.
For those of you who are into the Baseball measures, I'm only including data from the analysis and my calculated measures follow suit with all standard calculations. Enjoy
eyJrIjoiYWM4ZjM5N2EtMmRlYS00MzZmLWI5MWMtZTNjMTVjZDMxMmJjIiwidCI6IjA1NzY5NmZiLTQ3MDctNGMxYi1iNjFhLTg0NWQ1YzU1MDFhNiIsImMiOjF9
Matt - This is sweet. I thought about doing something similar, but mine would not have been this cool! I like the youtube url links to the home runs in particular, very nice touch.
I didn't read up on the methodology that the dataset compiler at signstealingscandal.com used...was it just brute force or did he leverage some sort of AI vision recognition software?
Great stuff.
Rob
Rob,
Thanks for the compliments! The home run bit was all because watching home runs is fun, even more fun when you hear the obvious bangs just before the ball is launched!
From what I read he used some software to recognize the trashcan bangs. Would be a long few weeks to brute-force it!
Matt