Uncovering Actionable Sales Insights
This is an early research project I led at Microsoft on a small team to compile sources and turn them into actionable insights for a digital product.
Skills Used:
-
Data Organization
-
Thematic Analysis
-
Exploratory Data Analysis
-
Affinity Mapping
-
Presentation
Some information has been removed or modified for confidentiality.
Context & Research Goals
The feedback that had been collected had come from a variety of sources and come through many methods including 1:1 interviews, workshops, and surveys. My task was to add rigor and reduce bias to the feedback synthesis.
![ThematicVisualization.PNG](https://static.wixstatic.com/media/52c427_4418e719c3f74c81bc0d31f36819c141~mv2.png/v1/crop/x_0,y_20,w_1154,h_510/fill/w_534,h_236,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/ThematicVisualization_PNG.png)
Methods
Given the disparate feedback sources, my collaborators and I decided to perform a thematic analysis with exploratory data analysis to easily see theme frequency and affinity mapping to generate potential insights.
![ThematicVisualization.PNG](https://static.wixstatic.com/media/52c427_4418e719c3f74c81bc0d31f36819c141~mv2.png/v1/crop/x_0,y_20,w_1154,h_510/fill/w_534,h_236,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/ThematicVisualization_PNG.png)
Crucial Insights
Through the analyses and iterative ideation I ranked insights. I presented our top 8 insights to leadership, identifying potential ways to put them into action.
![ThematicVisualization.PNG](https://static.wixstatic.com/media/52c427_4418e719c3f74c81bc0d31f36819c141~mv2.png/v1/crop/x_0,y_20,w_1154,h_510/fill/w_534,h_236,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/ThematicVisualization_PNG.png)
Impact
The research led to the adoption of 10 "quick wins" or relatively low effort actions to take based off of our insights. I collaborated with designers to implement the changes and led to an increase in usage.
![ThematicVisualization.PNG](https://static.wixstatic.com/media/52c427_4418e719c3f74c81bc0d31f36819c141~mv2.png/v1/crop/x_0,y_20,w_1154,h_510/fill/w_534,h_236,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/ThematicVisualization_PNG.png)
Key Learnings
This project required me to hit the ground running with only a few days to understand a complex product. If I were to do it again, I would have used that time to brainstorm with collaborators and get up to speed in a more collaborative way.
![ThematicVisualization.PNG](https://static.wixstatic.com/media/52c427_4418e719c3f74c81bc0d31f36819c141~mv2.png/v1/crop/x_0,y_20,w_1154,h_510/fill/w_534,h_236,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/ThematicVisualization_PNG.png)
I used Excel to standardize feedback and make it easy to search or filter.
I used R to allow for easy data visualization and exploratory data analysis across industries.
During the insight presentation, next steps were presented on how we could quickly take action on the insights.
![Screen Shot 2023-12-21 at 11.45.40 AM.png](https://static.wixstatic.com/media/52c427_cf52b6126ef84ce487abc62d94824e74~mv2.png/v1/crop/x_0,y_64,w_2948,h_1510/fill/w_554,h_284,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Screen%20Shot%202023-12-21%20at%2011_45_40%20AM.png)
![Screen Shot 2022-09-04 at 2.43_edited.jp](https://static.wixstatic.com/media/52c427_0a6d71acd70644f5b59b1263319b0877~mv2.jpg/v1/crop/x_0,y_108,w_2257,h_997/fill/w_534,h_236,al_c,q_80,usm_0.66_1.00_0.01,enc_auto/Screen%20Shot%202022-09-04%20at%202_43_edited_jp.jpg)
![Screen Shot 2022-09-04 at 2.45.57 PM.png](https://static.wixstatic.com/media/52c427_de88f11936da4cfda9df2d1d4ffd89b8~mv2.png/v1/crop/x_0,y_115,w_2268,h_1105/fill/w_534,h_260,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Screen%20Shot%202022-09-04%20at%202_45_57%20PM.png)
![Ideation.PNG](https://static.wixstatic.com/media/52c427_a4b8d1a5e3ab4d82a77a1cabe676a1e6~mv2.png/v1/crop/x_0,y_204,w_1421,h_628/fill/w_534,h_236,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Ideation_PNG.png)
Through Affinity Mapping I was able to take the large number of themes identified and condense them down to something actionable.
We used FigJam in our working sessions to develop ideas and organize our understanding.
For additional findings and learnings please contact me at jackmizell12@gmail.com