Visualizing Water Consumption from the Colorado River Basin


Growing up on the East Coast, I never thought much about water. And why would anyone? With abundant rivers, lakes, and reservoirs, water is cheap and easy to access.

Since moving out West, it’s been interesting to see a world in which the baseline is almost fully opposite: water is increasingly rare, expensive, and difficult to acquire.

While this winter’s parade of rain and snow storms should provide a brief respite from the drought conditions plaguing the region, I have no doubt that the overarching trend of aridification in the West will resume and potentially even intensify over the coming decades.

Read More

What do NFL Players Really Think About Their Teams? Visualizing NFLPA Team Report Cards for the 2022-2023 Season


Last week, the NFL Players Association (NFLPA) dropped a bombshell set of data: reviews by thirteen hundred active NFL players, of their own teams. Players graded their teams from A+ to F- on the following dimensions of player experience:

  • Treatment of Families
  • Nutrition
  • Weight Room
  • Strength Staff
  • Training Room
  • Training Staff
  • Locker Room
  • Travel

The NFLPA’s website is interactive and offers some entertaining anecdotes - such as the fact that the Arizona Cardinals charge their players for meals at the team facility!

Read More

Building a Flight Arrivals App for My Tidbyt Smart Display


This Christmas, I received a Tidbyt smart display as a gift. The Tidbyt, for those who were not successfully targeted with Instagram adds like me, is a 64x32 pixel display, housed inside a sleek walnut case, with a suite of simple apps immediately available for use. If you’re looking for an attractive small display to passively flash information like weather, word clocks, surf forecasts, etc. - I can’t recommend it enough.

Read More

Visualizing Electric Vehicle (EV) Charging Curves


Last year, I wrote a post quantifying the cost of home EV charging across the US. Given the low prices of home electricity, it’s no surprise that EV owners choose to slowly top up their batteries each night at home, and avoid more expensive public chargers.

However, it’s a safe bet that nearly all EV owners will eventually find themselves in need of a public fast-charger! And when that happens, they’ll almost certainly be looking to charge their vehicles as quickly as possible, and get back on the road.

Read More

Visualizing a Year of Pihole Requests (2022)


Years ago, I set up a Pi-hole at my house to serve as a network-level adblocker for all my devices. It’s been a terrific setup - the Pi-hole is quietly super effective at removing advertisements from different services, to the point where it can be surprising to load a website away from home and see how many ads are layered on the page!

A few days ago, I got curious to see if I could get any quantitative metrics on the performance of the Pi-hole, to augment my qualitative judgement.

Read More

Iteratively Generating Data Visualization Code with ChatGPT


On November 30th, OpenAI released ChatGPT into the world for public use - changing, with the press of a button, the lives of high school students forever 😂

While the OpenAI blog post explains the mechanics of the model better than I ever could, the important thing for readers here to understand is that ChatGPT essentially functions as a more knowledgeable Google - one you can make written requests to and receive back fully fleshed-out answers, which can then be follow-up on conversationally. To that point - Google has allegedly held internal meetings describing ChatGPT to be a “code red” for their search business, with executives concerned that the interactivity and simplicity of ChatGPT could replace many of the queries (and therefore, ad impressions) currently run on Google Search.

Read More

Wait - Tell Me Again How Much the Warriors' Star Studded Roster Is Going to Cost?


Earlier this week, I kicked off a two-part post by describing how the NBA’s multiplier-based luxury tax functions and has been designed to strongly disincentivize teams from spending significantly over the luxury tax threshold. Following up on that post, I wanted to share the example that brought this all to mind - the 2022-2023 Golden State Warriors!

Player Salaries

The Warriors are set to spend $190 million on their 2022-2023 roster, a figure that exceeds the $150 million luxury tax threshold by a whopping $40 million. Data from Sportrac helps us visualize how those funds are allocated across the roster…

Read More

Visualizing the Design of the NBA's Luxury Tax System


Basketball is back! After a long off-season, it was fun to see the league back in action last night, with a great game between the Celtics and Sixers followed by the Warrior’s ring ceremony and easy win against the Lakers.

Seeing the Warriors’ roster all together (bruises and all), with the recently extended Jordan Poole and Andrew Wiggins reminded me what a talented (and expensive) group they’ve put together this season, and got my mind churning on something…

Read More

Analyzing Dealer Markups of Popular New Cars


Over the past year and a half, new cars have become dramatically more expensive. While changes in product mix, constraints in part supplies, and overall increases in quality have played into that, dealer markups have also become a prominent factor - especially with highly-demanded models.

New Car Price Index

Economic Background

With exciting cars like the Ford Bronco and new Corvette having hit the market, dealers have found themselves in an interesting position - sole vendors of an in-demand good, with limited supply. It doesn’t take an Econ major to see the outcome here -> dealers have been able to apply “market adjustment” fees on top of MSRP (crucially - which enough people will still pay!) to maximize their earnings per sale, much to the chagrin of their OEMs.

Read More

Which MLB Teams Travel the Most?


I recently took a trip to Europe - an amazing time - but with the long flight to and from the West Coast, found my body really paying the price in terms of jetlag.

One of the nights after my return to California, as I lay awake at 5 am, body still mostly on Spain time, I realized that professional sports teams are doing a small-scale version of this every few days: flying from Oakland to Houston to Seattle and back, then hitting the road again.

Read More