基于Tableau和Excel的学生多维大数据分析研究

A Multidimensional Big Data Analysis Based on Tableau and Excel

针对混合教学模式下产生的大量学生多维数据不能充分利用的问题,笔者提出了一种基于Tableau和Excel的学生多维大数据分析方法,旨在提高教师数据分析的能力,并将分析结果反馈到实际教学。首先,将这些多维数据收集存储在Excel中,并利用Excel对这些数据进行整理、清洗、转换,形成可分析的规范化数据;其次,利用Tableau和Excel实现数据的分析及可视化展示;最后教师利用分析结果对参与学习的学生进行全面了解,做出相应教学改革。

A multidimensional big data analysis based on Tableau and Excel is proposed for inefficient utilization of multidimensional data by a large number of students under the mixed-mode teaching,aiming to improve teachers’capability of data analysis and apply analysis results to practical teaching.First,store multidimensional data in Excel where these data are normalized and rendered analyzable through data reduction,cleaning and conversion.Then analyze and visualize the data by virtue of Tableau and Excel.Finally,a complete understanding of students who participate in learning is obtained from analysis results and corresponding teaching reforms should be made by teachers.