Representation, Inclusion, and Opportunity Dashboard

Project Snapshot

Client: People3

Goal: Using R Shiny, build an interactive dashboard for People3 that helps their clients see how their employee makeup compares to the broader demographics of their geographic region

Impact: Illumine areas where outreach or improved diversification efforts could be beneficial

Turnaround: 3.5 weeks (Nov - Dec 2020)

Programming Language: R

Analytical Methods: Descriptive analytics

Tools: RStudio, Shiny, tidycensus, tidyverse, plotly

My roles: Collaborative project - met with the client to understand their business needs; retrieved data using tidycensus; cleaned and performed descriptive analyses on race and ethnicity data; visualized findings; designed dashboard layout and colors with company branding in mind; presented findings

Link to Git Repository

Description

• People3 is a benefit corporation that provides diversity and inclusion training, workshops, and inclusion-centered consulting

• The deliverable for this project is an app built with R Shiny that can be used to help companies see how their employee makeup compares to the broader demographics of their geographic region

• The app should allow the user to upload a data file containing counts by race/age/education/sex

• Using this file, the app should provide information as to the demographic makeup of the uploaded data compared to the makeup of a selected geographic region

MVP Key Features

• Census data available for 6 counties in Tennessee

• Comparisons by age group and generation

• Comparisons by race/ethnicity and primary languages spoken at home

• Comparisons by educational attainment

• Gender composition comparisons

• Data upload feature to allow for comparisons of client data and area Census data

Improvements for Future Iterations

• Visualize comparisons at different employee levels of the company

• Include disability and veteran status Census data

• Include Excel document upload template

• Finalize 'Download PDF Report' feature

• Include data from other sources (workforce, graduates, etc.)

Git Repository

For more details and to see my code, check out this project's repo