Venn diagram comparisons of sets- quick way to see overlap or lack there of

venn diagram

Venn diagram comparisons of sets

I often need to determine what items are in set A and Set B, in Set A and not in Set B and in B and not in Set A. Excel and other tools can do this but it takes time to open it up and configure the file. I wrote an AutoHotKey script which is very easy to get the Union, etc. and is very flexible.   The script can be downloaded below but I recommend first watching the video to understand exactly what is going on.



Venn Diagram / Compare sets Utility

Compare Sets Utility


Venn Diagram / AutoHotkey Compare Sets code

Preferred payment types by Industry- Guess I won’t write a check at McD’s

A national study of various industries in 2010 led to some interesting findings for our client in the finance industry.  The below chart displays the preferred payment types by industry by industry.  Given how “cashless” our society has become, it would be very interesting to see how much of a shift from Cash to Credit/Debit cards has occurred.  And does anybody actually write checks anymore?  I keep one in my wallet for “just in case” scenarios but I often go a year or so without using it.

Preferred payment types by Industry

Preferred payment types by Industry

Here’s a great book to get ideas on conveying data visually

Dallas attendance by zip code with drive-time zones- Man we wasted a lot of $

Our Dallas client was adamant that they “drew” from an enormous distance.  And, in truth, they did however when you add it all up and look at the annual attendance for the year, the vast majority of attendance came from a 30 minute drive time.

The below map shows the attendance by zip code overlayed with drive-time zones of 30 minutes, 60 minutes and 90 minutes.  The cost for purchasing mass-media, to reach the outer areas, was definitely not worth the return on investment!

Attendance by zip code

attendance by zip code

If you’re new to GIS analysis, I recommend the following book as good intro.

Here’s a great book to get ideas on conveying data visually