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