Home Archive by category "Analytics" (Page 5)

Category: Analytics

Various statistical analysis performed over the years with tools such as SPSS, SYSTAT, SAS, Excel, Python,R, etc. While the more interesting /complicated multivariate techniques are incredibly insightful, often simple cross-tabs, and a good design, can be used to find an answer to the problem at hand.

Automate Excel graphs with AutoHotKey and SPSS; Automating pretty charts!

Automate Excel graphsA white stress ball with the green AutoHotkey logo being held in a hand, with a laptop keyboard blurred in the backgroundAfter 20 years of doing multivariate statistics, doing analytics is very quick and easy for me.  Putting together the report which clients will think is “pretty” and convey the results is what really takes the time!  I have a ton of macros in SPSS which greatly simplify the front-end however I’ve always preferred Excel graphs to SPSS (because they don’t look like they were drawn with crayons).

Automate Excel graphs

In the below video I demonstrate how you how you can use AutoHotKey to easily automate Excel graphs that you’ll be proud to put your name on!

Two women smiling and looking at a computer screen together in a bright office, one pointing at the monitor.

Using a strong Naming Convention & RegEx are keys to automating metrics!

naming conventions

Naming Convention and Regular Expression (RegEx)

Having a strong naming convention can make reporting on your metrics a breeze when you use a regular expression to break out-decrypt the naming scheme. This video shows how easy it is for us to extract: Region, Language, Campaign Type, etc. from our campaign names by using a regular expression. It also points out that there is no need to be stuck with poor acronyms for your reporting.Group of coworkers seated around a table in a bright office, talking together with a green reusable water bottle in front of them

In my above example I use AutoHotKey with Excel.  If you add the function, Excel can do RegEx itself however (for some crazy reason) it isn’t built into it.

Great use of GIS data to decide your next business location

GIS Data

Years ago I helped a company that worked in the financial industry review where their current locations are and where FDIC Banks were located.  The GIS data was available for free from the FDIC.  If you spend some time you can merged the files together and look at it longitudinally.   The below map was particularly helpful in deciding where a new branch/office should be located.  I also imported the locations of competitors however I cannot share this data as it is too revealing.

I used Microsoft’s MapPoint to create the below map.  It is no longer with us however this would be easy to repeat with Google Maps.

GIS data

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