Upon Inspection

Doing stuff with data

Giving by class year

If we define “participation” as giving a gift (of any size), then one thing we can do is measure and track the “participation rate” of a given class year over … Continue reading

April 28, 2016 · Leave a comment

Predicting income based on job titles

Some background: As I’ve discussed in previous posts, we use people’s home address, along with block-group and census  tract level demographics from the American Community Survey, in order to generate income … Continue reading

November 17, 2015 · Leave a comment

Revisiting geography as a major gift indicator

From time to time on the Prospect-DMM list-serve, and on insightful blogs like CoolData, there is some debate about whether there is much value in geographically aggregated data when it … Continue reading

February 20, 2015 · Leave a comment

Introducing: rcrunchbase

In case you were intrigued by the last couple of posts about mining CrunchBase, I wanted to make you aware that the development has progressed quite a bit and you can … Continue reading

December 15, 2014 · Leave a comment

The cost of premature aggregation

Here is a common situation: a client calls, asking to know the average giving for the year for any prospect in her unit’s portfolio. As an analyst, I want to … Continue reading

June 29, 2014 · Leave a comment

Mining CrunchBase, part II

In part one, we created some basic functions that handle the nuts and bolts of interacting with the CrunchBase API — authorization, sending GET requests, parsing the response data, and … Continue reading

June 13, 2014 · 15 Comments

Mining CrunchBase, part I

My colleague asked me this week if we could quickly discover Cal alums listed in CrunchBase. I spent some time clicking around on the site, and reading the documentation for … Continue reading

June 6, 2014 · 12 Comments

Some teamwork, a map

My colleague, a prospect researcher, had queried our database to pull a list of several thousand suitable technology related alumni in response to a request from one of her clients. … Continue reading

April 10, 2014 · Leave a comment

How do you do documentation?

This post includes a PDF that I couldn’t embed but that I would love for you to take a look at: Capacity Model Among the many things about my job that … Continue reading

March 18, 2014 · Leave a comment

Correct link for the SF map

In my previous post I gave an incorrect link for the interactive San Francisco map. The post has since been fixed, the correct link is: http://tarakshah.org/demos/sfmap.html

July 31, 2013 · Leave a comment

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 28 other subscribers