In her latest column, Beth shares ten steps to enhance your nonprofit’s data collection and analysis capacity.
In November, I facilitated a mini-innovation lab on measuring impact for grantees of the Google Nonprofit program at the Impact Hub. The hot button issue was capacity, skills, and lack of resources. It was articulated as: “We don’t have the skills to analyze, slice and dice, and make sense of our data, so it is hard to do it well.” I hear this too often from nonprofits.
“If I was running a nonprofit today, I would put together an advisory group of data nerds to help with my data and measurement needs.”
The people with skills are out there. In fact, some participants in the group mentioned using MBA students from local universities to assist with data collection. Participants were looking for a variety of skills – from something as simple as creating pivot charts on excel, importing data from multiple sources into one spreadsheet for analysis or what DJ Patel calls ‘Data Jujitsu,” doing a statistic analysis, setting up a conversion analysis in Google Analytics, and other technical skills. I was surprised that many of the participants hadn’t heard of or taken advantage of the many useful and free resources out there for getting a pro bono volunteer to do some of the technical skills. This post is a round up of how to find volunteers and others to assist with the nitty-gritty data skills.
- Look Within Your Walls: The first place to look is down the hall or ask at your next board meeting. There may be someone in another department who is a data nerd with expert excel or data analysis skills. Ask around. Or maybe you have a board member who works in the business world and is or has connections to people who work in finance, market research, or analytics.
- Recruit Through LinkedIn: On LinkedIn profiles, members can “signal” their interest in skilled volunteering for a nonprofit. To find someone, just used the advanced search function. LinkedIn also encourages nonprofit to post job descriptions for skilled volunteers and especially working with one of their partners: Catchafire, NPower’s Community Corps, Taproot Foundation and VolunteerMatch. I’ve said this many times, but if I was running a nonprofit today, I would sign up for this service and put together an advisory group of data nerds to help with my data and measurement needs.
- Get Free Help with Your Google Analytics: The Analysis Exchange has a goal to “dramatically increase the number of people on Earth doing web analytics the right way.” They provide free web analytics consulting to non-profits and NGOs around the world by matching analytics professionals, students, and charities. The team works on a practical project that takes less than four weeks to complete. They are teaching digital measurement best practices by connecting great causes with experienced mentors and motivated students.
- Find a Data Scientist with a Heart: Data Scientists are in high demand and have an unusual skill set, including: data jujitsu skills (combine data from different places, clean it, analyze it, and make sense of it). The organization, DataKind, has a program that matches Data Scientists with nonprofits to help them better use their data. So, if you have a pile of data in spreadsheets that hasn’t been analyzed, go find your organization a data scientist.
- Get Training : Data for Good is an association for people who work in nonprofit and data and offers the “Do Good Data University“ where you find excellent webinars on a variety topics. NTEN is offering regular webinars on the topic of how nonprofits can effectively use data. Idealware offers a number of data related webinar courses and a free nonprofit data workbook. Leap of Reason offers toolkits for boards, nonprofits, and foundations on “do it yourself” outcomes based measurement. Google offers the free MOOC called “Google Analytics Academy.” Or if you are a self-learner and just need to learn a few techniques for creating charts in excel, here’s some terrific video tutorials.
- Read Sector Blogs That Cover Data: If you want to stay current on data in the nonprofit and philanthropic sector, the best place to go is Lucy Bernholz’s blog, philanthropy.blogspot.com. Start with this this post about Data as a buzzword, subscribe to Lucy’s blog, and read “Navigating the New Social Economy.” NTEN is also publishing blog posts, articles, and reports and a good place to start is their September NTEN Journal issue on data. The Guide Star blog also covers big data for the nonprofit sector. You can easily follow nonprofit data nerds on Twitter by subscribing to the list I’ve put together.
- Hire A Consultant: NTEN’s annual nonprofit technology conference and other events, you will find an ecosystem of consultants who do measurement, data analysis, and other skills required to make sense of your data. If you are looking for an evaluation specialist, check out the American Evaluators Association directory. Or ask around for consultants that your colleagues have used. (And my co-author, KD Paine, has been doing measurement consulting for nonprofits and businesses for over 25 years).
- Become Someone’s Homework: If you have a college or university in your town, why not become someone’s homework? Both my books, “Networked Nonprofit,” and ”Measuring the Networked Nonprofit” has been added to the syllabus of many college courses – from nonprofit management survey courses, philanthropy, communications, measurement, and more. I speak to college students regularly, many times through skype like this group of students in Indiana this past month that shared stories about their internships, which often included measurement and spreadsheets. Some courses, like this one for nonprofits and communications taught by my colleague Shonali Burke, often include a student project working with a nonprofit.
- Attend a Data for Good or Impact Measurement Panel, Networking Event or Conference: For example, the Independent Sector had a packed house for the Data 360 Panel and put together this set of resources. If you go to a session at a nonprofit conference, you will probably not only find data nerds presenting, but the room might just be packed with them.
10. Expand Your Nonprofit Measurement and Data Bookshelf: Here are three recent publications for nonprofits and impact measurement.
– Impact and Excellent: Data-Driven Strategies for Nonprofits by Sheri Chaney Jones
– Presenting Data Effectively: Communicating About Impact by Stephanie Evergreen
– Leap of Reason Books by Mario Morino (Free download)
So, if you are not using data or measurement because your organization does not have someone with the skills, there are ways around this challenge! Has your organization solved the big challenge of lack of skills, resources, or staff to do impact measurement? How and what is your experience?
Many thanks to Beth Kanter for such a thorough set of ideas to tackle the problem of data capacity within nonprofits. With ten tangible actions, let us know which work for you.