Excel:自动化账本还是分析型IDE?
Excel: Automated Ledger or Analytics IDE?
AI总结:
本文探讨Excel从账本自动化工具演变为分析型IDE的历程,并强调需扩展现有风险框架以应对其作为开发环境带来的新风险。
摘要:
自四十多年前VisiCalc问世以来,电子表格经历了渐进式的转变,从简单的账本自动化工具演变为当前状态的Excel,后者可被描述为用于分析的综合开发环境(IDE)。Excel从账本自动化工具缓慢演进为分析型IDE,这一过程解释了为何许多人未曾注意到Excel包含功能完备的数据库、OLAP引擎、多种统计编程语言、多个第三方软件库、动态图表以及实时数据连接器。访问这些多样工具的简便性在于一个低代码框架,该框架由Excel这一实际上充当IDE的工具控制。一旦我们承认Excel从桌面应用向分析型IDE的转变,建立全面风险框架以管理这一独特开发环境的重要性便变得清晰。在本文中,我们将阐述如何扩展当前针对电子表格的风险框架,以管理将Excel用作分析型IDE所带来的日益增长的风险。
英文摘要:
Since the inception of VisiCalc over four decades ago, spreadsheets have undergone a gradual transformation, evolving from simple ledger automation tools to the current state of Excel, which can be described as an Integrated Development Environment (IDE) for analytics. The slow evolution of Excel from an automation tool for ledgers to an IDE for analytics explains why many people have not noticed that Excel includes a fully functional database, an OLAP Engine, multiple statistical programming languages, multiple third-party software libraries, dynamic charts, and real time data connectors. The simplicity of accessing these multiple tools is a low-code framework controlled from the Excel tool that is effectively an IDE. Once we acknowledge Excel's shift from a desk top application to an IDE for analytics, the importance of establishing a comprehensive risk framework for managing this distinctive development environment becomes clear. In this paper we will explain how the current risk framework for spreadsheets needs to be expanded to manage the growing risks of using Excel as an IDE for analytics.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。