Historical College Scorecard Big Data Analysis using In-Memory Processing

Kunal Pritwani, Atinder Singh, Dharmesh Soni, Mounika Vallabhaneni and Jongwook Woo

Volume 17 Issue 1

Global Journal of Computer Science and Technology

Data set is collected for colleges of United States. We would like to analyze different dimensions like SAT scores, ear- ning after graduation, net price and grant financial aids which is a great analyzation for the students. Big Data platform and BI tool such as Spark and tableau are adopted for data analy- zation and visualization. It is found that the top colleges for mean earnings are from medical field, mean earnings with respect to states, detailed comparison of average net price of California and New York, SAT scores for different colleges and also average undergraduates receiving Pell Grant in each colle- ges which will help students to select a college which meets their requirement.