Spreadsheets as Decision Support Tools – Case Study on Automatic Trend Lines

Proceedings of the 12th International Conference ECOTREND2015, pp.604-609

10 Pages Posted: 3 Dec 2015

See all articles by Daniel Homocianu

Daniel Homocianu

Alexandru Ioan Cuza University, Faculty of Economics and Business Administration, Department of Accounting, Business Information Systems and Statistics

Date Written: November 27, 2015

Abstract

Nowadays many applications working with data sets have export options to the spreadsheet format. Most of the reasons are related to the common user’s experience with such products and to the possibility to build up further on something that is more than a simple static and read only report.

Beyond generating alerts for exceptions or identifying clusters, association rules, decision trees, and many other patterns, the purpose of Business Intelligence is also to determine trends and make predictions about the future based on historical data. In this context, this paper shows some practical results after testing the automatic creation of time series charts and trend lines corresponding to the user’s preferences and not forgetting to suggest the most appropriate trend for the tested data.

Keywords: Spreadsheets, Business Intelligence (BI), Microsoft (MS) Office Excel trends

JEL Classification: C130, D810, D830

Suggested Citation

Homocianu, Daniel, Spreadsheets as Decision Support Tools – Case Study on Automatic Trend Lines (November 27, 2015). Proceedings of the 12th International Conference ECOTREND2015, pp.604-609. Available at SSRN: https://ssrn.com/abstract=2698102 or http://dx.doi.org/10.2139/ssrn.2698102

Daniel Homocianu (Contact Author)

Alexandru Ioan Cuza University, Faculty of Economics and Business Administration, Department of Accounting, Business Information Systems and Statistics ( email )

Romania

Register to save articles to
your library

Register

Paper statistics

Downloads
22
Abstract Views
255
PlumX Metrics