Abstract
With the increasing number of students in colleges and universities, a large amount of educational big data has been accumulated in daily teaching work. How to make full use of educational big data to serve education and teaching has theoretical and practical significance. In order to mine the hidden value of educational big data and improve teaching quality, this paper processes and analyzes educational big data based on Hive data warehouse technology. First, the educational big data is collected from the Oracle database to the data warehouse through the Sqoop tool, and the analysis results are obtained through data cleaning, data transformation, data statistics and other steps. Hive and Spark are used in data analysis and statistics. The analysis results are stored to the MySQL and Redis, and finally the analysis results are visualized through the front-end and back-end separation technology.