Implementation of Sales Executive Dashboard for A Multistore Company in Yogyakarta
Abstract
Information Technology is a part of strategic part for enterprise strategic planning. Information Technology can help the enterprise to determine its strategic planning. Through data from the past, the
company can learn something and help to decide some strategic issue. A Multistore Company in Yogyakarta has more than five stores. The problem raises to generate real-time sales reporting. Sales manager and owner do not have access to real-time sales condition. To ease management analyzing and reporting sales condition, dimension model of the sales data needs to be built. This dimension model will help to make executive report from some dimensions mentioned in data warehouse. Sales data will pass through some processes: Extract, Transform, and Load (ETL) in order to prepare the data warehouse. This process is preprocessing data before dimensional model is built. In this research multi-dimensional modelling by taking data from 3 stores ranging from 1 February 2014 to 31 January 2015. By implementing sales executive dashboard, it helps to monitor and analyze sales condition. Dashboard shows graphic which ease user, especially sales manager and owner to learn current and updated sales condition based on dimensions: time, outlet / store, and product. Report gives detail information and multidimensional
helps to analyze data from different perspective.
Index Terms—Dashboard, Multi Dimentional Model, ETL, Executive Reporting
REFERENCES
[1] W. Eckerson, Performance Dashboard: Measuring,Monitoring, and Managing Your Business, New Jersey: JohnWiley & Sons, 2011.
[2] O. Romero and A. Abello, "A Survey of MultidimensionalModelling Methodologies," International Journal of Data Warehousing and Mining, vol. 5, no. 2, pp. 1-23, 2009.
[3] R. Kimball and J. Caserta, The Data Warehouse ETL Toolkit:Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, Indianapolis: Wiley Publishing, Inc., 2004.
[4] G. Dhillon and J. Backhouse, "Information System Security Management in the New Millenium," Communications of the ACM, vol. 43, no. 7, pp. 125-128, 2000.
[5] C. Ballard, D. M. Farrell, A. Gupta, C. Mazuela and S. Vohnik, Dimensional Modelling: In a Business Intelligence Environment, IBM Redbooks, 2006.
[6] E. Fernández-Medina, J. Trujillo and M. Piattini, "Modeldriven multidimensional modeling of secure data
warehouses," European Journal of Information Systems, vol. 16, no. 4, pp. 374-389, 2007.
[7] E. Johnson and J. Jones, Building ETL Processes for Business Intelligence Solutions Built on Microsoft SQL Server, CA ERwin, 2007.
[8] J. Mylopoulos, L. Liu and M. T. Owen, "Database Design," inEnsyclopedia of Database System, United States, Springer,2009, pp. 708 - 710.
[9] K. R. Gadda and S. Dey, "Business Intelligence for PublicSector Banks in India: A Case study. Design, Development,and Deployment," Journal of Finance, Accounting and Management, vol. 5, no. 2, pp. 37-58, 2014.
[10] D. J. Power, "DSS Resources," 6 June 2007. [Online]. Available: http://dssresources.com/. [Accessed 29 May 2017].
[11] D. Hedgebeth, "Data-driven decision making for the enterprise: an overview of business intelligence applications," The Journal of Information and Knowledge Management System, vol. 37, no. 4, pp. 414-420, 2007.
[12] S. Williams and N. Williams, The Profit Impact of Business Intelligence, San Fransisco: Elsevier, 2007.
[13] Imelda, "Business Intelligence," in Majalah Ilmiah Unikom, Bandung, UNIKOM, 2013, pp. 111-112.
Downloads
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike International License (CC-BY-SA 4.0) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
Copyright without Restrictions
The journal allows the author(s) to hold the copyright without restrictions and will retain publishing rights without restrictions.
The submitted papers are assumed to contain no proprietary material unprotected by patent or patent application; responsibility for technical content and for protection of proprietary material rests solely with the author(s) and their organizations and is not the responsibility of the IJNMT or its Editorial Staff. The main (first/corresponding) author is responsible for ensuring that the article has been seen and approved by all the other authors. It is the responsibility of the author to obtain all necessary copyright release permissions for the use of any copyrighted materials in the manuscript prior to the submission.
