Using external data in a BI solution to optimise waste management

ABSTRACT BI solutions are constantly being developed to support decision-making at various organisational levels. These solutions facilitate the compilation, aggregation and summarisation of large volumes of data. Consequently, the business value created by these systems is increasing as they sustain more and more advanced analytics, ranging from descriptive analytics, to predictive analytics, to prescriptive analytics. However, most organisations work primarily with internal data. Despite many references in the literature to the value hidden in external data, details on how such data can be used are scarce. In this paper, we present the results of an extensive action case study at a public waste management company. The results illustrate how external data from several external data sources, integrated into an up-and-running BI solution, are used jointly to allow for descriptive and predictive analytics, as well as prescriptive analytics. In addition, details of these analytical values are given and related to organisational benefits.

[1]  Gloria E. Phillips-Wren,et al.  An analytical journey towards big data , 2015, J. Decis. Syst..

[2]  Kristin Braa,et al.  Balancing interpretation and intervention in information systems research: the action case approach , 1997 .

[3]  Andy Koronios,et al.  The Implications of Big Data Analytics on Business Intelligence: A Qualitative Study in China , 2016 .

[4]  Robert Wrembel,et al.  Modeling a Multiversion Data Warehouse: A Formal Approach , 2003, ICEIS.

[5]  Jeffrey A. Hoffer,et al.  Flying High with Real-Time Business Intelligence , 2008 .

[6]  Paulraj Ponniah,et al.  Data warehousing fundamentals for IT professionals , 2010 .

[7]  Ku Halim Ku Hamid,et al.  Implementation of decision support system for scheduled waste management in Malaysia , 2011 .

[8]  Martin W. P. Savelsbergh,et al.  The General Pickup and Delivery Problem , 1995, Transp. Sci..

[9]  Frada Burstein,et al.  Business Intelligence (BI) system evolution: a case in a healthcare institution , 2016, J. Decis. Syst..

[10]  Barbara Wixom,et al.  The BI-Based Organization , 2010, Int. J. Bus. Intell. Res..

[11]  Abhishek Sharma,et al.  Expediting analytical databases with columnar approach , 2017, Decis. Support Syst..

[12]  Peter A. O'Donnell,et al.  Organisational transformation through Business Intelligence: theory, the vendor perspective and a research agenda , 2012, J. Decis. Syst..

[13]  Paulraj Ponniah Data Warehousing Fundamentals for it Professionals: Ponniah/Data Warehousing 2e , 2010 .

[14]  Ngoc Anh Nguyen Thi,et al.  Towards a decision support system for municipal waste collection by integrating geographical information system map, smart devices and agent-based model , 2016, SoICT.

[15]  Jeanne G. Harris,et al.  Competing on Analytics: The New Science of Winning , 2007 .

[16]  Clyde W. Holsapple,et al.  Handbook on Decision Support Systems 2 , 2008 .

[17]  Graeme G. Shanks,et al.  Achieving benefits with business analytics systems: an evolutionary process perspective , 2012, J. Decis. Syst..

[18]  Anna Syberfeldt,et al.  A Decision Support System for Sustainable Waste Collection , 2017, Int. J. Decis. Support Syst. Technol..

[19]  Leon A. Kappelman,et al.  Key Issues of IT Organizations and Their Leadership: The 2013 SIM IT Trends Study , 2013, MIS Q. Executive.

[20]  Huaixin Chen,et al.  From data to knowledge to action: A taxi business intelligence system , 2012, 2012 15th International Conference on Information Fusion.

[21]  Ana Paula Cabral Seixas Costa,et al.  The Full Knowledge of Big Data in the Integration of Inter-Organizational Information: An Approach Focused on Decision Making , 2017, Int. J. Decis. Support Syst. Technol..

[22]  Graham Pervan,et al.  A critical analysis of decision support systems research revisited: the rise of design science , 2014, J. Inf. Technol..

[23]  Mikael Berndtsson,et al.  Analyzing business intelligence maturity , 2015, J. Decis. Syst..

[24]  Luca Vogt Data Warehouse From Architecture To Implementation , 2016 .

[25]  Hui Xiong,et al.  A taxi business intelligence system , 2011, KDD.

[26]  Trevor Wood-Harper,et al.  A critical perspective on action research as a method for information systems research , 1996, J. Inf. Technol..

[27]  Peter A. O'Donnell,et al.  The critical issues facing business intelligence practitioners , 2012, J. Decis. Syst..