This workflow helps HR teams, data analysts, and compliance officers uncover potential workplace discrimination patterns using real employee reviews from Glassdoor. By leveraging ScrapingBee to gather review data, OpenAI models to extract and analyze demographic-based ratings, and QuickChart to visualize disparities, this template provides insights into whether certain employee groups experience different workplace outcomes.
It automates the end-to-end process: from scraping review data, parsing demographics, calculating variance and statistical significance, to generating clear visualizations for easy reporting.
Features
- 🔎 Data Collection – Automatically scrapes Glassdoor company reviews using ScrapingBee.
- 🏷 Demographic Analysis – Extracts review data segmented by race, gender, orientation, disability, caregiver status, and veteran status.
- 📊 Statistical Insights – Computes z-scores, effect sizes, variance, and p-scores to identify significant disparities between groups.
- 🎨 Visual Reporting – Generates bar charts and scatterplots with QuickChart for clear presentation of findings.
- ⚙ AI-Powered Extraction – Uses OpenAI language models to interpret review summaries and demographic modules.
- 🔧 Customizable – Easily swap in your company of interest and credentials to run the analysis.
