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:-

1. To study the impact of tuition fees on school rankings
2. To compare admitted students’ GMAT, GRE scores, and GPAs with respect to schools’ Employer Reputation
3. Compare the universities on the basis of actual rankings and students’ ratings
4. 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 :

1. ER diagram was created after brainstorming several insights and requirements. shorturl.at/bdlG5
2. Identify different sources to consolidate the data( usnews.com, economist.com, bloomberg.com, topuniversities.com)
3. Find ways to Extract the data in to the csv file , Transform the data and Load(DDL) the data into MS SQL Server.
4. Perform DML operations to answer business transactions
5. Visualize the insights using Tableau Dashboards for the presentation
6. Provide overall insights and suggestions particularly to Robert H. Smith school of Business - University of Maryland - College Park .

Inferences :

1. Class Size is negatively correlated with the Rankings , as the class size reduces, the rank of the B-School improves.
2. The higher number of networking events a B-School conducts , the higher the rank the school has.
3. Percentage of Faculty with PhD plays a pivotal role in the ranking of a B- School.
4. The more the geographical diversity a classroom has, the higher the rank the school has.
5. Students ratings of program content is very much in line with the school rankings
6. The availability of Facilities in a B-School is not a significant factor or not correlated with the rank of B- Schools
7. Employer Reputation Influences Ranking Significantly along with Average GRE, Average GMAT and Average GPA scores.
8. Higher the average Tuition fees of a B-school, higher the average Offered income to the students.
9. Universities having students with a larger average work experience have better rankings.
10. States- MA, Illinois, California have 2 top-10 universities each.
11. 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 :

1. Reduce the class size
2. Conduct more networking events
3. Employ more faculties who hold a PhD degree
4. Increase the geographical diversity score in the classroom
5. Improve their program curriculum
6. Increase the admission scores’ requirements
7. UMD should consider lowering down their tuition fee
8. Should give admits to students who have more number of months’ of work experience