Teaching an Introductory Data Analytics Course Using Microsoft Access® and Excel®
Teaching an Introductory Data Analytics Course Using Microsoft Access® and Excel®
复制标题
使用 Microsoft Access® 和 Excel® 教授入门数据分析课程
DOI：
--
复制
发表时间：
2020
期刊：
影响因子：
--
通讯作者：
Abdulrahman Shamsan
中科院分区：
文献类型：
--
作者：
Faisal Aqlan;Joshua C. Nwokeji;Abdulrahman Shamsan
数据分析最近被许多研究人员和专业人士采用，他们在学术和工业领域使用数据。随着对数据分析师需求的增加，公司和教育机构的数据分析培训计划也在同步增长。在本文中，我们介绍了数据分析的概念，并提出了使用Microsoft Access和Excel的实际例子。四种类型的数据分析（即，描述性、诊断性、预测性和规定性）进行了讨论，并提供了实际例子。对于描述性分析，我们讨论的数据属性和模型，并在Microsoft Access中的数据库设计和实现的例子。诊断分析的示例涉及Microsoft Excel中的人体工程学评估应用程序，以确定工作环境中人体工程学风险的来源。预测分析示例包括在Microsoft Excel中实现回归和聚类模型。最后，规定性的分析例子涉及优化除雪过程中，在当地城市开发一个优化模型，并在Excel中实现。这些示例将帮助学生理解数据分析，并能够在Microsoft Access和Excel中实现不同的数据分析模型。
Data analytics has been recently adopted by many researchers and professionals working with data in both academic and industry. With the increase in demand for data analysts, there has been a parallel growth in data analytics training programs within companies and educational institutions. In this paper, we introduce the concepts of data analytics and present practical examples using Microsoft Access and Excel. The four types of data analytics (i.e., descriptive, diagnostic, predictive, and prescriptive) are discussed and practical examples are provided. For descriptive analytics, we discuss the data properties and models and present examples of database design and implementation in Microsoft Access. The example for diagnostic analytics involves an ergonomic assessment application in Microsoft Excel to identify the sources of ergonomic risks in work environments. Predictive analytics examples include regression and clustering models implementation in Microsoft Excel. Finally, the prescriptive analytics example involves optimizing the snow removal process in a local city by developing an optimization model and its implementation in Excel. These examples will help students understand data analytics and be able to implement the different data analytics models in Microsoft Access and Excel.