Is it me or a toxic teammate?

Yesterday wasn't a good day. I work on a small "team". We don't really interact as a team ought to. We end up working in silos because that is the path of least resistance. We lack any cross training, change control process, and basic communication. One developer deployed code into production without informing anyone. It... Continue Reading →

Tableau join with calculated field

I recently ran into a problem with a join: I had two tables with "customer class" IDs in them, but I needed the description - which was only available for the customer subclass. In a rush, I joined the tables on customer class and filtered the subclass descriptions to one description per customer class. I... Continue Reading →

Tableau Quick Tip: Show ALL Labels

I was trying to play with the hex map concept. But I noticed my state abbreviations were only showing up on a handful of my marks. I discovered that you can simply click on Label in the Marks card and select "Allow labels to overlap other marks": And boom! All labels are now on display.

Fill in the Blank

I've climbed Rainier a couple of times and there were a few crevasses we had to cross. Some were just a mere jump, others were wider and had to be crossed with a ladder.  Got me thinking about crevasses in data and how you might want to fill in those crevasses with the last known... Continue Reading →

SQL Server: Splitting Strings

Today I was asked how to extract the directional component from a street address. For example, the following 3 street addresses should have a directional value of 'East': E Street East Road Big River Blvd E My first approach was to do the old fashioned case statement. Select street_address , case when address like 'E%'... Continue Reading →

Visualizing Bikes and Beer in Bend

Our family leaves Seattle for Bend, Oregon every year to dry out, mountain bike, and enjoy the local breweries. What would our last vacation look like as a visualization? I wondered. I cobbled together some of our rides and brewery locations in Tableau Public to see how play felt in the tool I use at... Continue Reading →

Powered by WordPress.com.

Up ↑