Skip to content

Repository files navigation

Career Insights Dashboard

An interactive Tableau dashboard analyzing hiring trends, coursework impact, and employment outcomes for UIUC graduate students. Built for data warehousing and business intelligence analysis.

Background

This project builds a dimensional data warehouse from synthesized graduate hiring data and creates interactive dashboards to analyze:

  1. Geographic distribution of graduate employment.
  2. Correlation between GPA, coursework selections, and starting compensation.
  3. Factor analysis associated with employment outcomes.

Dataset

Synthesized dataset modeled after graduate career outcome records. Includes attributes for job roles, annual compensation, GPA, course electives, hiring locations, and employment status across graduating cohorts.

Key Findings

  • Higher GPA correlates with increased annual starting income across departments.
  • Technical and analytical coursework correlates with higher offer volume.
  • Employment distribution concentrates in major metropolitan areas (Chicago, Washington D.C., Los Angeles).
  • Unemployed outcomes show lower completion rates of technical electives.

Dashboard Visualizations

Student Hiring Data

Employers and Roles

Academic Hiring Correlation

Live Dashboards

Interactive dashboards on Tableau Public:

Repository Files

  • DWBI_Final_Project.twbx: Packaged Tableau workbook containing all visualization dashboards.
  • DWBI Project Report.pdf: Documentation covering data modeling, ETL, and analytical methodology.

Tech Stack

  • Tableau
  • Tableau Prep
  • SQL
  • Mockaroo

Collaborators

  • Atharva Sathaye
  • Sarthak Chandarana
  • Yash Sangle

License

MIT

Author

Atharva Sathaye

About

Career insights dashboard: star schema data warehouse with SQL ETL pipeline and Tableau visualization

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors