IDeal

ER Data Diagram
Home Page; users can search and submit reviews from here
The form for users to share their story
Search result showing a word cloud of positive reviews
Reviews displayed after clicking a key word within the word cloud

Inspiration

This project is committed to creating a transparent tech industry. By listening and sharing stories of harassment and injustice in the tech industry, we hope to create a safe space for creating change. We've seen websites for community members to report salary, interview, and job information, but there currently is no central location for minorities to find information on working in a field or company as a person of their particular identity.

What it does

IDeal lets users submit their experiences at a company along with the groups they identify with (gender, socioeconomic class, sexual orientation, etc.). After submitting, IDeal runs sentiment analysis on the review to distinguish it as an overall positive or negative review. It will then generate word clouds based on the frequency of words for both positive and negative reviews for the company based on all the reviews written for it.

Users will be able to search for particular companies, jobs, or fields to view these word clouds and the overall sentiment felt by minorities who have worked there. Words in the word cloud are also clickable, taking the user to a list of reviews that contain that keyword. Users can filter reviews based on different identity groups as well.

How we built it

We designed and created a database with mysql to store review information and link it to companies and keywords. The database is connected to our front end through Flask, where we perform sentiment analysis on reviews and generate the word cloud in Python. The results are then displayed on the web platform, which was built using bootstrap.

Challenges we ran into

Learning a new design system Polymer (which ended up not working out), and coming up with a new idea.

Accomplishments that we're proud of

It was fun coming up with an idea that we're passionate about and designing a new product with a design system that we were unfamiliar with.

What we learned

It's important to build something that you care about, work to highlight your team's individual strengths, and have fun!

What's next for IDeal

We ran out of time before we could link our database with our front end, and didn't get to creating the templating for the reviews on the website. We're excited to launch a working prototype with everything we envisioned for IDeal!