I am quite desperate for a way to manage and analyse qualitative data.

My main job task at work is managing quantitative data. If it’s a number we can plug into a spreadsheet, I know how to collect it. There is plenty of room for improvement and, to be honest, I am cursing the fact that I didn’t pay more attention in my Access class in grad school. But generally speaking, I have a good handle on the types of quantitative data we collect, the flaws and the needed improvements to our processes and to our datasets, and the ways we can use that data to tell our story to whoever asks.

But we have access to all sorts of qualitative data as well. For example:

  • Reports from foreign service officers;
  • Cables from posts;
  • Reports submitted to an internal reporting system;
  • Posts in the community forum on our website;
  • Posts in our Facebook group;
  • Newsletters and other activity reports that are either sent to us directly or shared via our email lists.

All of this is spread out over a variety of disconnected locations. We have troves of information stashed in mattresses all over our house and seemingly no good way to tie it all together.

So that is my holy quest: to research and compile ideas for managing qualitative data and figure out how best to implement those ideas. I am told that it better not just result in a word cloud.