Tuesday, April 5, 2016

Krannert Walmart Data Dive at Purdue April 2-3, 2016

›
Since I am currently a graduate student, I was eligible to represent my school, and attend the Krannert Walmart Data Dive at Purdue this pas...
Tuesday, February 23, 2016

Using Data Marts to Move From Reactivity to Proactivity

›
I'd like to share a few methods that have enabled me to move from being almost entirely reactive in my work (simply fulfilling requests)...
Wednesday, July 15, 2015

Quantifying Alumni Engagement

›
A great way to quantify Alumni engagement to a  institution of higher ed, would be to assemble a list of all those perceived as the most hi...
Tuesday, October 14, 2014

SQL to display duplicate rows within a table

›
Because you don't want duplicate rows. This works for me in Oracle. YMMV. Just change "table_name" to the table you wish to ...
Wednesday, April 2, 2014

Flagging Executives with SQL

›
Here's a bit of Oracle SQL code that will flag executives in your data, for use as a potentially very important independent variable in ...
Wednesday, October 23, 2013

Useful Datasets for Prospect Research

›
FREE DATASETS FEC Data http://www.fec.gov/finance/disclosure/ftp_download.shtml SIC Codes http://www.naics.com/referencefiles.h...
Saturday, December 10, 2011

Using Free Zip Code Data for Quick and Simple Analysis

›
As a one‐person researcher working at a smaller college, I became very interested in discovering cost‐effective ways in which I could quickl...