Helping startups level up their product strategy, marketing design, UI/UX and fund-raising
When doing user research - I love Airtable for organizing content. It allows you to do so across multiple dimensions and slice/dice your analysis how you want to. So you could in theory, mark each person/quote on a problem dimension, usability, existing tools, etc. and then see patterns and filter in lots of ways. So the organization (in whatever tool) largely comes down to what you are trying to uncover. I think unless you are doing a very coarse analysis, in airtable I would have each "row" be a response (or even a individual quote). Then there would be a column for the person, a column for the question (maybe a new columns as to what the question was trying to illicit - your intent), then successive columns for the multiple dimensions you would annotate on. This then becomes your master table. From there, you can slice and dice but you are always building on raw data that cuts nicely
I help content and UX teams learn to stay flexible and creative (not reactionary or defensive!) throughout challenging projects.
A nerdy question for my nerdy content and UX friends: Let's say you're conducting 6-10 stakeholder interviews, with the goal of identifying themes across the answers. What's your personal preferred way to organize the info? Questions as column headers in a spreadsheet, with one row per interviewee? Questions down the first column, and then one additional column per interviewee? Mural/Miro/another visual whiteboardy setup? Plain old text docs and then the synthesis happens elsewhere? ???!!!! Inquiring minds etc etc
