Project 2
SQL PROJECT ON ALUMNI OF COLLEGE
Once a student is passed out from a Institute or College, he/she is known as Alumni of the Institute. Alumni’s career growth plays important role in Institute’s ranking and other networking activities. In this project, career choices of alumni of two Universities will be analyzed with respect to their passing year as well as the course they completed.
Dataset: Six .csv file (Alumni record of College A and College B) Higher Studies, Self Employed and Service/Job record
- College_A_HS ~ Higher Studies Record of College A
- College_A_SE ~ Self Employed Record of College A
- College_A_SJ ~ Service/Job Record of College A
- College_B_HS ~ Higher Studies Record of College B
- College_B_SE ~ Higher Studies Record of College B
- College_B_SJ ~ Higher Studies Record of College B
Project Title: Career Analysis of Alumni from College A and College B
PROJECT OBJECTIVE
- Analyze the career choices of alumni from College A and College B based on their passing year and course of study.
- Identify trends and patterns in alumni career paths.
- Provide insights that can inform the ranking and networking efforts of the institutions.
DATA COLLECTION
- Collect six CSV files containing alumni records for College A and College B. These files should include data on alumni pursuing higher studies, self-employment, and service/job positions.
- Ensure that the data is clean and well-organized for analysis.
DATA ANALYSIS
- Data Cleaning and Preprocessing
- Data Exploration
- Career Path Analysis
- Temporal Analysis
- Course-Based AnalysiS
INSIGHTS AND RECOMMENDATIONS
- Summarize the key insights gained from the analysis.
- Provide recommendations to College A and College B based on the findings. For example, suggest areas where career services can be improved, or propose strategies for alumni engagement.
CONCLUDING REMARKS
- Highlight the significance of understanding alumni career choices for the institutions' rankings and networking activities.
- This project can provide valuable information for both colleges to improve their alumni engagement strategies, enhance their educational programs, and strengthen their alumni networks. Additionally, the insights gained from this analysis can contribute to their efforts to boost their rankings and reputation.