Spot Workplace Discrimination Patterns with AI
Spot Workplace Discrimination Patterns with AI analyzes employee reviews from Glassdoor to identify disparities in workplace experiences among different demographic groups. By leveraging AI and data visualization, it calculates key metrics such as average ratings, z-scores, and effect sizes, highlighting significant gaps in employee satisfaction. This workflow empowers organizations to address inequities and foster a more inclusive workplace environment.
View Large Image
Workflow Overview
Spot Workplace Discrimination Patterns with AI analyzes employee reviews from Glassdoor to identify disparities in workplace experiences among different demographic groups. By leveraging AI and data visualization, it calculates key metrics such as average ratings, z-scores, and effect sizes, highlighting significant gaps in employee satisfaction. This workflow empowers organizations to address inequities and foster a more inclusive workplace environment.
This workflow is designed for:
- HR Professionals: To analyze workplace discrimination patterns based on employee demographics.
- Data Analysts: To extract and interpret data from Glassdoor reviews to identify biases.
- Diversity and Inclusion Officers: To monitor workplace equity and assess the effectiveness of diversity initiatives.
- Company Executives: To gain insights into employee experiences and make informed decisions to improve workplace culture.
This workflow addresses the issue of workplace discrimination by analyzing employee reviews from Glassdoor. It identifies disparities in ratings across various demographic groups, providing insights into potential biases and areas for improvement. By quantifying employee experiences, organizations can take actionable steps to foster a more inclusive environment.
- Manual Trigger: The workflow is initiated by clicking 'Test workflow'.
- Set Company Name: It sets the target company name (e.g., Twilio) for data extraction.
- Define Demographic Keys: Establishes a dictionary of demographic identifiers (e.g., Asian, Hispanic, Female).
- ScrapingBee Search: Utilizes ScrapingBee to fetch relevant data from Glassdoor based on the company name.
- Extract Company URL: Extracts the URL path of the company page from the search results.
- Fetch Company Page: Retrieves the company page content from Glassdoor.
- Extract Reviews URL: Captures the URL for the reviews section of the company page.
- Fetch Reviews Content: Gathers reviews data from the extracted URL.
- Extract Overall Review Summary: Pulls the overall review summary for analysis.
- Extract Demographics Module: Captures demographic information from the reviews.
- Calculate Ratings: Analyzes ratings and their distributions using AI models to extract average ratings and review counts by demographic.
- Calculate Variance and Standard Deviation: Computes variance and standard deviation based on review distributions to understand rating spread.
- Calculate Z-Scores and Effect Sizes: Determines z-scores for demographic groups to assess how their ratings compare to the overall average.
- Calculate P-Scores: Evaluates the statistical significance of differences between groups.
- Format Data for Visualization: Prepares the dataset for visualization in scatterplots and bar charts.
- Generate Charts: Uses QuickChart to create visual representations of the data, highlighting disparities and trends.