Writing
2020–2026 data tools, canvases, SQL
- The First Time Business Intelligence Felt Intelligent
- The Shape of a Question: Teaching SQL to Understand Intent
- Sometimes the art is the journey - Data Rabbit to Flowmaps
- Flowmaps - Mapping Clojure core.async Flows Through Time & Space
- The Color & Shape of Data: Living Maps, Direct Manipulation, the Code Canvas
- Quick "Hackathon" Release - Tableau Flow Maps
- Pivoting into new flows - life, location, Rabbit
- Editing the editor - user-space "extending" of the UX
- Screenception & Hoverzilla. Can a deeply flexible layout builder still be sane and understandable?
- Tools. Chisels. Bar Graphs. Zuckerbergs. Rabbits. Ceilings.
2023 Rabbit Remix dev log
2009–2013 the old blog
Tableau, Metallica setlist analytics, Bigfoot data and other early work. Kept as written.
- Connecting Tableau to ElasticSearch (READ: How to query ElasticSearch with Hive SQL and Hadoop)
- Enterprise IT: Why does "having a job" and good software have to be mutually exclusive?
- RiffBank - Parsing arbitrary Text-based Guitar Tab into an Indexable and Queryable "RiffCode for ElasticSearch
- RiffBank - Indexing "Guitar Tab Data" as a pseudo-language with ElasticSearch
- Facts, Stories, Conveyance: Postmortem "Data Viz Advice" from a famous American street photographer
- Going Yard: Using MLB data and Tableau 8 to "re-imagine" Homeruns in PetCo Park - "The Business Case"
- Mapping San Diego Padres Hits & PetCo Park Changes | Tableau 8 page
- The Anatomy of a Tableau 8 Dashboard (or a "floating tile grid autopsy")
- Quick & Dirty Address Geocoding and Formatting with Google Maps API
- Build Tableau Data Extracts out of CSV Files? More Python TDE API madness!
- SQL Server Query to Tableau Data Extract LIKE A BOSS - Some more TDE API fun with Python & Tableau 8
- Building Tableau Data Extract files with Python in Tableau 8 - Sample Usage
- Face Harvesting: Download your Facebook data for External Reporting and Visualization
- Facebook Data Harvester page
- Turning Guitar Tabs into structured Data. Silicon crunching Metal.
- "Enter TableauMan": Creating Useful Data Visualizations with old school Guitar Tab and Metallica page
- Python Snippet: Sending HTML email with an attachment via Google Apps SMTP (or Gmail)
- Cars, Computers and Software: Quick Tableau of data from my VW's "On Board Diagnostic" (OBDII) port
- How to Harvest Facebook updates with Python, MySQL or SQL Server
- Get Some! Query MLB Gameday Data with OData and Tableau Public
- Real-world "Business Storytelling" page
- Viz Updates - Metallica & Bigfoot refreshed! Plus, "The Data Box"...
- Building and Loading Sexy Operational Dashboards with DucksBoard.com
- Stanley Cup Social - "Real-time Reactions to In-Game Event(s)" page
- Tableau + PhpGrid = an (almost) instant gratification data entry tool
- More DATA PORN - @garyvee Twitter Stats page
- Insight into an Artist's Spotify Payout Details.. page
- A "Visual, Analytic Storefront"? Vay-ner-chuk WineLibrary Style! page
- Bigfoot & Aliens, together at last! page
- Visualizing Bigfoot of the United States
- Finding Bigfoot (Data) - Visualize the Squatch page
- Visual Analytics | Data Porn page
- Harvesting Twitter Search Results for Analysis using Python & SQL Server
- Some Tableau Public Embed Code Hacking for more "Creative Blog Usage"
- Metallica Shows In page
- Historical Setlist Analysis page
- Member Timeline page
- Band Time Spent Playing page
- Shows in YOUR Country page
- Tours and Tour Legs page
- Unplayed Songs page
- Song Trending page
- Shows by Tour / Year page
- Shows by Country page
- Shows in US by State page
- Last Show Played page
- Visual Setlist Analysis page
- Song Frequency page
- Tour Dashboard page
- Rare Shit: Scoring Songs on a Setlist by Historical Context (Frequency, Rank, Ntile)
- MetallicAnalysis page
- Some Metallica Setlist Analysis using Tableau Public Visualization Software and some Python Hacking
- MoneyBall (for Real): Business Intelligence, Data Mining, SQL Server, and Major League Baseball - Part 1
- Cross Post: SQL Server, Business Intelligence, Data Mining, & Major League Baseball (I)
- Poking the Pot Roast of life, Hard
- Cut-N-Paste Corner: PHP function - Dynamically Round up to nearest 10, 100, 1000 or whatever (Graphing Axis Sex Toy)
- Developers, IT Nerds, Useless Tech People - stop wielding "knowledge" like it was Geek Bravado weaponry
- Mortgage Software Hack: Importing Contacts automatically into Encompass WITHOUT the SDK (just with SQL)
- Running Python script(s) as a Windows Service - Keep your Python Mojo Engines Running while you Sleep!
- Business Intelligence, Tools, Dirty Caveman Sex, Open-Source - Part 1
- Fuck, sales, leads, & sign-ups. You know what has the BEST conversion rate ever?
- What Sookie Stackhouse can teach you about being a better blogger
- Consulting page
- Get Clicky Android Widget = Awesomely Convenient
- Using XLWT and Python to export an Oracle dataset to Excel (Python Simple ETL Part 2)
- Cut-N-Paste Corner: Microsoft SQL Server 2000, 2005, 2008 Simple Loop Template
- You can pet my Goat. Just wash your hands first, please.
- Using a simple Python script for End-to-End Data Transformation and ETL (Part 1)
- I don't mind ugly people, but I do mind people who make ugly faces...
- The State of Flow, Hidden Passions, and Drudgery
- Bike Path + Reflective Sunglasses = Mean Walkers
- The UFC needs a Michael Jordan, not a Michael Vick