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 →

ICON’t tell what it is…

This morning, I was perusing an article on NPR about humanitarian icons. The short of it is - UNOCHA (United Nation's Humanitarian Agency) has created 295 icons to help convey useful information. 295? Wow! That does seem excessive. Why not create a new icon language and stack a few icons together to communicate? Oh wait,... 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 →

HOT Key off the Press Tip: Copy Path

Want a quick way to copy your file's path and paste into that email to send to your fellow coworkers? In Windows Explorer, hold the SHIFT key while you RIGHT-CLICK on your file name and select Copy as path. Then paste into your document and voila! You have your entire path in quotes. So simple!... Continue Reading →

Is it Your Turn to Speak?

The first time I had to do a really big presentation at work, I was ready -- I knew my material, I had a strong message, and it was my chance to show off my skills to my co-presenter, our group’s Vice President. But halfway through the presentation I looked down and was mortified to... Continue Reading →

Powered by WordPress.com.

Up ↑