Modeling The Data: A Guide to Affinity Diagrams
This is a part of my class Assignment at UW Madison.
Introduction
Affinity diagrams offer a structured approach to organizing and comprehending complex information, making them one of the most effective tools in problem-solving.
In this guide, we will delve into the process of utilizing affinity diagrams to gain valuable insights from data. We will be considering an example to begin with.
Defining the Problem: “Declining Pollination”

Addressing a complex issue such as “declining pollination” requires a thoughtful and well-defined approach. While it may seem straightforward, without sufficient user research, the task becomes challenging.
To tackle this, we perform data collection, stakeholder analysis, and create empathy maps based on user interviews.
Cleaning Up the Data: Transcribing and Beyond
Our data, gathered through interviews, may initially be vague. To extract meaningful insights, the first step is to transcribe the interviews, utilizing AI tools after converting one of them with Python. Once transcribed, consider employing tools like Voyant for text visualization, which performs lemmatization and offers a clearer understanding of the data.
Tools and Techniques
If your audio has excessive background noise and a significant amount of disturbance, I recommend removing the noise before feeding it into transcription tools. This is because such interference might lead to inaccuracies in the transcription. (Mac users can use iMovie)
I used AI tools and Google API to transcribe the audio files
Code for Transcribing
Visualization Tools
Before constructing the affinity diagram, explore additional visualization tools. Voyant, for instance, is a powerful tool that goes beyond mere visualization, providing insights into the data you’ll be handling. Just upload all your text files and configure to visualize (more the frequency--bigger they appear on circus).


Cleaning them
Remove Stop words in the transcribed files. Stop words are frequently used words in a language (such as “and,” “the,” “is,” etc.) that are generally considered to be of little value in text analysis because they don’t carry much meaning on their own.
Modeling the Data
With the data organized and cleaned, it’s time to bring the team together. Based on the research and data gathered, express individual thoughts on post-it notes or using collaborative tools like FigJam.
- Document facts, drawings, ideas, and observations,
- then group them into clusters and set the overarching theme(labels).

Drawing Insights
The affinity mapping process allows for the prioritization of user pain points. By analyzing the clusters, we gain a deeper understanding of what the user exactly requires, enabling us to draw meaningful insights.
You might want to jot down user needs and build the problem definition from it.
Conclusion
In conclusion, affinity mapping stands out as an exceptional tool for interpreting complex data. By following this structured approach, we not only organize information effectively but also gain valuable insights that are crucial for informed decision-making. The process, from defining the problem to drawing insights, ensures a comprehensive understanding of the data at hand. Incorporate affinity diagrams into your data modeling toolkit to unlock a powerful method for tackling complex issues.