Skip to content

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

  1. 01

    Utilized sentiment analysis and topic modeling on open-ended responses to extract key themes and identify market opportunities.

  2. 02

    Leveraged Python, pandas, and multi-index for complex data manipulations, creating multi-level pivot tables for cross-sectional analysis.

  3. 03

    Optimized code performance using vectorized operations and chunking techniques for efficient large dataset processing.

  4. 04

    Generated custom radar and multi-line charts with Plotly, embedded in HTML, enhancing data interpretability.

  5. 05

    Balanced company design specifications with data visualization best practices, ensuring accessibility and effective communication.

  6. 06

    Applied ANOVA and chi-square tests to identify statistically significant performance issues across groups and sections.

  7. 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