Helping Hungry Families with Business Intelligence

Recently I've had the opportunity to be a part of the advisory board for the Dallas Fort Worth Community Food Bank . My initial work was simply giving some advice on how they could increase their social media presence and accept bitcoin and dogecoin for donations; however, when they mentioned they needed a better way to track their customers, I realized I could use the same set of tools I use to help businesses to help families.

ESRI Tapestry Segmentation

Tapestry Segmentation allows for quick assessment of regional demographics, behaviors, and attitudes. For more info, see ESRI's website on Tapestry Segmentation, you can even get a sweet poster!

GoogleVis - Create Interactive Maps Online with Data in R

Creating interactive maps is typically either difficult (e.g. openheatmap) or expensive (e.g. ESRI). However, I came across an interesting R package not to long ago that allows for flexible online visualization of geographic data, googleViz. Below is a simple example using the included R datasets. It displays graduation rates by states, mousing over a state provides its name and given graduation rate. After the map is quick tutorial on how to do it.

HTML 5 Geolocation Testing

Tornado and Flood Map

A quick trial of ESRI's embedded mapping technology:

Excel Interactive Tables

Impressive (relatively) new feature from Microsoft. Here are Interactive HTML Tables by Excel. This feature has now been deprecated, sorry. Please see my more recent article on Embedding Excel in a website to see how you do it now

When "Good Enough" Really Is Good Enough - Managing Perfectionism in an Imperfect World

Originally Published December 2012 on How many times has this happened? You’re working on a report. You polished the visuals, showing the insights in elegant detail. You reworked some tables to be more concise, and it’s almost perfect! It’s also a week late.

Geographic Representation of Unemployment vs. Labor

I put together this visual using public data from the BLS. It demonstrate that during 2008(running up to and during the peak of the great recession) unemployment rates and labor force were highly positively correlated. However, during times before and after, the relationship tends to be negative.