Finding Bigfoot (Data) – Visualize the Squatch

Look out! Bigfoot are EVERYWHERE! I didn't even realize! ;)

Another little Data Hacking / Automated Python Scraping / Tableau experiment. I "gathered" all the report / sighting data off of the BFRO site last night - imported it all into SQL Server 2012 (Express) - cleaned and scrubbed it up with a bunch of stored procedures in SQL (well, cleaned up as much as I could and keep my sanity), and booya - visualized beautifully by Tableau (yet again). Props to the BFRO peeps for having all this data available, I just wish it was presented a bit differently. (hint, hint)

So, I present - the fanciest Bigfoot presentation ever. HEAVILY "clickable", too.

Data Updated 6/14/2012: Added almost 40 "new" Sightings. Newly submitted sightings will appear as green instead of red
     Click on any year, location, season, or detail field and the detail info list will change.
     Hover over the + sign on the right for even more squatchy sighting tooltip details.

Nowhere near as cool as my Metallica visualizations, but hey, I'm wicked biased on that one.

As I said above, the original source of the data can be found here - so all credit goes to them, I just mixed it all together in a sexy looking way.

Dig this? Check out some of my other "out of the box" data visualizations / dashboards

Metallica Tour Visualizations

Lots of them. Lots. Even if you aren't a fan - it makes an interesting BI Dashboard POC.

Metallica Member Timeline

Simple interactive timeline (in gantt chart form) of the different Metallica members and their time with the band.

WineLibrary / TV / GaryVee Reviews

Fun viz of WineLibrary.com's inventory mashed with WineLibraryTV's entire internet catalog.

  • http://ryrobes.com/ Ryan Robitaille

    Bigfoot fan or not, I love this.

  • Estendres

    but..the most import in the finding, is to have a picture

  • Doug Nelson

    I’m impressed!

  • http://www.facebook.com/daryl.hemeon Daryl Hemeon

    I hope Bobo gets a look at this, will truly help the cause.

    • http://ryrobes.com/ Ryan Robitaille

      Oddly enough, Daryl – I tweeted this to a couple of the FindingBigfoot guys a few weeks ago (bobo, moneymaker, etc) just to see what they said. What did I get? Nothing. Hah. Go figure (and its built off “THEIR” data too, hah)

  • GUESTak

    It would be interesting to see the migratory patterns of BIGFOOT from season to season or year to year. Can this viz do that?

  • http://www.facebook.com/profile.php?id=604955110 Jason Smith

    That is a seriously good piece of work

    • http://ryrobes.com/ Ryan Robitaille

      Thanks Jason! I thought it was a fun use of “analytics”. :)