redshift_cover

Analytics in Redshift: The Migration Script

Inspired by posts from Bitly and Airbnb data teams on Redshift as a replacement for Hadoop we decided to give it a try. And we loved it. We loved it so much that we wrote a Postgres to Redshift migration script and open-sourced it. Why Redshift? We needed speed: from our partnership team doing reporting, product…

error

Errors drive us crazy

Errors driving you crazy? Errors drive us crazy too, especially the small ones. It has come to our attention recently that a larger than expected amount of donors using our website on desktop forget to select an expiration date! It’s quite odd considering that all online payments today require this information to be entered, and…

No School Left Behind

No School Left Behind: Get Your School on the Map

Through the incredible generosity of over 1.5 million citizen philanthropists, DonorsChoose.org has supported over a quarter billion dollars in classroom supplies for schools across the nation. But we have an even bigger goal in mind: to reach 100% of the nation’s highest poverty schools. We identify schools in which over 65% of students are eligible…

names_wordcloud_cover

What’s in a name?

Inspired by Reuben Fischer-Baum’s maps of popular baby boy and girl names, we decided to create our own animated map of popular donor names across the United States, depicting shifting trends in names since we launched. We find this name map interesting for two reasons. First, it shows the growth of DonorsChoose.org – we might…

malefemale

Male Teachers Get More Donations Than Female Teachers. Why?

Guest post: Greg Laughlin is CEO of Statwing, an easy-to-use data analysis tool. Male teachers fundraise on DonorsChoose more successfully than female teachers. The effect isn’t huge, but it’s there. We wanted to figure out why. Take a look at the differences: See these results in Statwing, along with statistical results. See these results in…

techiness

“Techiness” of Tech-Savvy US Cities

Drawn from multiple online sources, we’ve devised a list of the most tech-savvy cities in the US. Our data shows that, interestingly enough, there are 2 breeds of Tech-savvy cities: those that have a much lower emphasis on technology-related projects compared to the rest of the US and those that have a much higher emphasis…

holidaylights

Lessons Learned from our Holiday Campaign

Crafting a subject line can seem like a straightforward process, but for email marketers, the devil is in the details (and the testing). This week we look at 3 lessons learned during our holiday season. Lesson #1: Be Direct It is always tempting to opt for the cute or “punny” subject line. During the holiday…

generosity

Who’s More Generous: You or Your Friends?

Today, we at the Central Bureau of Data  decided to shine a light, end the controversy and to finally answer the question… What names make for the most generous donors across the US? In our day to day lives we have always wondered what were the most common names in my state? Or how many people…

giving_index_featured

Giving Index: 2013 in Review

Our partnership with Looker allows anybody to generate insights into America’s educational system, schools needs, and emerging trends in education. Request an invite to interactively explore our open datasets now. Today, in partnership with Looker and Highwire PR we announced a release of this public data exploration feature and here are a few stories and an…