BUDT703 0506 01 Proposal
Submitted By: TerpRank
Course, Section, & Team: BUDT703_0506_01
TerpRank Ranks • Mission Statement:-
Identify the best pair of student and B-School, the one they desire and deserve. (select a b-school for graduate level with given criteria like GRE, GMAT , GPA, location , etc) Provide B-schools insights into specific areas they must revamp to lift their rankings.
• Mission Objectives:-
- To study the impact of tuition fees on school rankings
- To compare admitted students’ GMAT, GRE scores, and GPAs with respect to schools’ Employer Reputation
- Compare the universities on the basis of actual rankings and students’ ratings
- Identify the difference in the number of applicants when the application fee is greater or lesser than $200.
• Business Processes/Transactions: -
--1 What are the number of applicants for the respective B-School when the application fee is greater than $200?
--2 What are the number of applicants for the respective B-School when the application fee is less than $200?
--3 What are the rankings of the B-Schools with application fee greater than $200?
--4 Which ones are the top-5 B schools in 2021, according to the students ratings of program content?
--5 What are the Top-5 B-Schools as per the rankings in 2021?
--6 Which ones are the top-5 B schools in 2021, according to the employement rate at graduation ?
--7 Which ones are the top-5 B schools in 2021, according to the student ratings of faculty?
--8 Give the comparison of Rank vs Faculty Student Ratio for 2021
--9 Give the comparison of Ranking Vs Average GRE for 2021
--10 Give the comparison of Rank vs Average GMAT for 2021
--11 Give the comparison of Rank vs Average GPA for 2021
--12 Give the comparison of Rank vs Faculty Student Ratio for 2021
--13 Give the comparison of Rank Vs Learning
--14 Give the comparison of Rank for Employment After 3 months for 2021
--15 Give the comparison of Rank vs Work Experience for 2021
--16 Give the comparison of Tuition Fee vs Income for 2021
--17 Give the comparison of Location vs 30 Top Ranked Schools
--18 Give the comparison of Rank vs Acceptance Ratio
--19 Give the comparison of Rank vs Employer Reputation
--20 Give the comparison of Rank vs Class Size
--21 Give the comparison of Rank vs Networking
--22 Give the comparison of Rank vs PhD Faculty
--23 Rank vs Avg International Student Ratio
--24 Rank vs Student Rating of Programme
--25 Rank vs Student Rating of Facilities
--26 Rank vs Average Work Experience
Major Steps involved :
- ER diagram was created after brainstorming several insights and requirements. shorturl.at/bdlG5
- Identify different sources to consolidate the data( usnews.com, economist.com, bloomberg.com, topuniversities.com)
- Find ways to Extract the data in to the csv file , Transform the data and Load(DDL) the data into MS SQL Server.
- Perform DML operations to answer business transactions
- Visualize the insights using Tableau Dashboards for the presentation
- Provide overall insights and suggestions particularly to Robert H. Smith school of Business - University of Maryland - College Park .
Inferences :
- Class Size is negatively correlated with the Rankings , as the class size reduces, the rank of the B-School improves.
- The higher number of networking events a B-School conducts , the higher the rank the school has.
- Percentage of Faculty with PhD plays a pivotal role in the ranking of a B- School.
- The more the geographical diversity a classroom has, the higher the rank the school has.
- Students ratings of program content is very much in line with the school rankings
- The availability of Facilities in a B-School is not a significant factor or not correlated with the rank of B- Schools
- Employer Reputation Influences Ranking Significantly along with Average GRE, Average GMAT and Average GPA scores.
- Higher the average Tuition fees of a B-school, higher the average Offered income to the students.
- Universities having students with a larger average work experience have better rankings.
- States- MA, Illinois, California have 2 top-10 universities each.
- The top 10 schools have an application fee greater than $200 and yet see a 3 times higher number of applicants.
Suggestions to the Robert H.Smith School :
- Reduce the class size
- Conduct more networking events
- Employ more faculties who hold a PhD degree
- Increase the geographical diversity score in the classroom
- Improve their program curriculum
- Increase the admission scores’ requirements
- UMD should consider lowering down their tuition fee
- Should give admits to students who have more number of months’ of work experience