STRTGY · Jul 2023
Automated Interview Analysis
Overview
Automated survey data analysis from SurveyMonkey, reducing a 1-2 month process to seconds of script runtime. Implemented data normalization and weighted sampling to mitigate demographic biases in survey responses.
Highlights
- 01
Utilized sentiment analysis and topic modeling on open-ended responses to extract key themes and identify market opportunities.
- 02
Leveraged Python, pandas, and multi-index for complex data manipulations, creating multi-level pivot tables for cross-sectional analysis.
- 03
Optimized code performance using vectorized operations and chunking techniques for efficient large dataset processing.
- 04
Generated custom radar and multi-line charts with Plotly, embedded in HTML, enhancing data interpretability.
- 05
Balanced company design specifications with data visualization best practices, ensuring accessibility and effective communication.
- 06
Applied ANOVA and chi-square tests to identify statistically significant performance issues across groups and sections.
- 07
Developed an interactive HTML dashboard for management, featuring dynamic data exploration and highlighting key insights.
Stack
- Automation
- Data Analysis
- Data Visualization
- SurveyMonkey
- Survey Analysis
- Python
- Pandas
- Multi-Index
- Plotly
- HTML
- Interactive Visualization
- Custom Visualizations
- Employee Feedback Analysis
- Performance Analysis
- Organizational Improvement
Working on something similar?
Tell me about the problem and the data behind it. I reply within 24–48 hours.
Discuss a project