employee-review-sentiment-dashboard

This project aims to analyze the reviews for 6 company included Microsoft, Apple, Amazon, Facebook, Netflix and Google that are published on Glassdoor. The scraped data is downloaded from Kaggle: https://www.kaggle.com/petersunga/google-amazon-facebook-employee-reviews/version/2

Overview

Visualization #1

Shows ratio between positive/neutral/negative sentiments of all 6 companies to give a general idea.

Static:

On Hover:

On Click:

Visualization #2

Shows the ratings of one company.

Static:

On Hover:

Hover on graph #1 (To quickly compare between companies):

Visualization #3

Shows the pros and cons with different color hued for one company.

Visualization #4

Shows the adjectives mentioned for self-defined aspects(time,benefit,salary,etc..).

Visualization #5

Shows the sentiment across the map of U.S. for one company.

Filters

Including changing the company for the one company visualizations, the date of reviews, and type of employee(former/current).

Note that the .ipynb file is the Python file that preprocess the data from kaggle “employee_reviews.csv” to “employee_reviews_processed.csv” as the sentiment in this project is classified using Python and not Javascript.