Research Assistant
Department of Accountancy, UIUC
Mar 2024 - May 2024
Key Achievements
- Developed a course pathway recommendation tool using clustering on alumni data
- Deployed a Streamlit app to provide interactive recommendations
- Built Power BI dashboards to track student outcomes and course efficacy
- Provided data-driven insights for academic decision making
Problem Statement
- Students needed guidance on course selection to optimize career outcomes
- Department required insights into which course combinations led to better job placements
- Need for a scalable tool to automate course recommendations based on career goals
Technical Implementation
- Cleaned and preprocessed alumni data including course histories and career outcomes
- Applied clustering algorithms to identify successful course pathway patterns
- Developed recommendation engine using similarity metrics and career alignment
- Built interactive Streamlit web application for real-time recommendations
- Created comprehensive Power BI dashboards for department leadership
- Implemented automated data refresh pipelines for up-to-date insights
System Architecture
+----------------------+
| Data Integration |
+----------------------+
|
v
+---------------------------+
| Analysis & Insights |
| - Data cleaning & |
| preprocessing |
| - Anonymization |
| - Alumni Cohort analysis |
| - KNN & clustering model |
+---------------------------+
|
v
+----------------------+
| Delivery |
| - Streamlit frontend |
+----------------------+
Impact
- Enabled data-driven course selection for students
- Provided department with actionable insights on curriculum effectiveness
- Identified high-value course combinations for specific career paths
- Streamlined advising process with automated recommendations
Technologies Used
Python
Streamlit
Clustering
Power BI
SQL
Data Analysis
Data Visualization