Rahul Reddy Chappidi Venkata

Data Scientist

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