Up first were the Judges’ Choice Awards for great and notable hacks that didn’t make the top three. Based on cheering from the crowd, we’d select among the top three projects to award the Best Hack in the Known Universe.
The Fighter: The first Judges’ Award, called the Fighter, went to Yuan Jiang, Ben Langsam, and Mary Ritchter for the Expedia Rate Scraper. Anyone who’s gone through the tedious process of copying data from tables on a web page will love this project. It uses Python to screen-scrape car rental rates from Expedia.com then converts it to a Tableau Data Extract (TDE) file. Connect to the TDE in Tableau Desktop and you’re on your way to quickly finding the best car rental rates.
The Slam Dunk: Jonathan Schmiel won the second award, the Slam Dunk, with his project that uses one of the sample data sources provided with Tableau along with the Tableau Web Data Connector. The resulting combo lets users instantly search and connect to key health statistics provided by the World Health Organization.
The Team Award: For their highly collaborative style and impressive whiteboarding skills, the IT Turtles received the Team award. Olga Prilepova, Clark Jen, and Donahue Sean developed an at-a-glance Help Desk dashboard that uses PUSH to inject new help desk data directly into a TDE, creating a smooth, real-time view of emerging Help Desk tasks and issues.
The Powerlifter: A great hackathon brings out epic efforts. For this, Tableau has a special Judges’ Award: The Powerlifter.
As Ben explained, “You know it’s a real hackathon when one of two things happens: Someone brings a soldering iron, or someone pulls out a display bigger than 24 inches. Ryan Kluck pulled out two such displays.”
Ryan and his hackathon partner Matthew Greenslet developed a web app that leverages an XML hack to give viz authors a one-size-fits-all workbook that uses calculated measures.