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 26 other followers


Get every new post delivered to your Inbox.

Join 26 other followers