Design of the Business Intelligence Dashboard for Sales Decision Making
DOI:
https://doi.org/10.61841/mce2nm07Keywords:
Design, Business Intelligence, Dashboard, Decision Making, Star SchemeAbstract
Business intelligence is a system that can help an executive or a decision-maker to analyze a fact that can become a value from a profit or sales from a different dimension. Business intelligence provides a data visualization, usually in the form of graphics or charts, that can help the decision-maker make a decision. It can also help to do trend analysis and help make an indicator when the business is off track. It can help the decision-making process, like item positioning and customer segmentation. The creation of a business intelligence dashboard can help PT. Inisiatif Mitra Mandiri to do the extensive analysis in order to make a decision, such as sales performance monitoring, item positioning and monitoring, and customer segmentation dashboard. Sales performance monitoring means that they can monitor the sales performance of a company, helping the executive to realize when their sales performance is off track and needs to be fixed. It gives a trend analysis about the sales and can help the executive detect the losses. While item monitoring can be used to monitor the items in each site that are in high demand and can be used to plan for placing and stocking the items on that site. For instance, executives can manage to make plans for item stocking on each site by looking to the previous years on which items are in high demand. For customer segmentation, it can be used to determine a profitable customer that needs to be retained, and it needs customer data from various dimensions that can help them to do the customer segmentation.
Downloads
References
[1] Al Farsi, B. A., & Saini, D. K. (2015). Business Intelligence Design Model (BIDM) for University. International Journal of Computer Applications, 111, 43-49.
[2] Ballard, C., Farrell, D. M., Gupta, A., Mazuela, C., & Vohnik, S. (2006). Dimensional Modeling: In a Business Intelligence Environment. IBM Redbooks.
[3] Budiawan, A., Saudi, M.H.M., & Sutisna, D., The Effects of Planning and Coordination Toward Work Effectiveness at the Faculty of Business and Management in Widyatama University, Bandung, International Journal of Engineering and Technology 7(4):348-351, December 2018.
[4] Burton, B., Geishecker, L., Hostmann, B., Friedman, T., & Newman, D. 2006. Organizational structure: business intelligence and information management. Gartner Research.
[5] Connolly, T. & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (Sixth ed.). New York, United States: Pearson & Addison Wesley.
[6] Inmon, W. (2005). Building the Data Warehouse (Fourth ed.). Canada: Wiley.
[7] Isik, Ö., Jones, M. C., Sidrova, A. (2013). Business intelligence success: The roles of BI capabilities and decision environments. Information & Management.
[8] Kapoor, B. & Mihaylo, C. (2010). The Journal of Human Resource and Adult Learning. Business Intelligence and Its Use for Human Resource Management, 6, 21-30.
[9] Kimball, R. & Ross, M. (2010). The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence. Indiana: Wiley Publishing.
[10] Laudon, K. C. & Laudon, J. P. (2010). Management Information Systems: Managing the Digital Firm, 11th Edition. New Jersey: Prentice Hall.
[11] Miah, S. J. (2014). A Demand-Driven Cloud-Based Business Intelligence for Healthcare Decision Making. Handbook of Research on Demand-Driven Web Services: Theory, Technologies, and Applications.
[12] OBrien, J., & Marakas, G. M. (2009). Introduction to Information Systems. New York: McGraw Hill.
[13] Pardillo, J. & Mazon, J.-N. (2011). Using Ontologies For The Design Data Warehouse,. International Journal of Database Management Systems (IJDMS), 3, 73-87.
[14] Person, R. (2009). Balances scorecards and operational dashboards with Microsoft Excel. Indiana: Wiley Publishing, Inc.
[15] Robbins, S. P. & Coulter, M. (2012). Management, Global Edition (11 ed.). New Jersey, USA: Pearson Education Limited.
[16] Scheps, S. (2018). Business intelligence for dummies. New Jersey: Wiley.
[17] Turban, E. (2011). Business Intelligence: A Managerial Approach (2 ed.). New Jersey: Pearson.
[18] Turban, E., & Rainer Jr., R. K. (2009). Introduction to Information Systems Enabling and Transforming Business. New Jersey: John Wiley & Sons.
[19] Vercellis, C. (2009). Business Intelligence: Data Mining and Optimization for Decision Making. United Kingdom: John Wiley and Sons Ltd.
[20] Williams, S. & Williams, N. (2006). The profit impact of business intelligence. Morgan Kaufmann.
[21] Blessy Trencia Lincy, S.S., Nagarajan, S.K. mR-mRMR feature selection approach with an incremental classifier model in big data (2018) International Journal of Pharmaceutical Research, 10 (4), pp. 365-379. https://www.scopus.com/inward/record.uri?eid=2-s2.0-85057152825&partnerID=40&md5=4c8eb9005339ebcf176f82957f1aaea4
[22] Shah Hirva, Patel Jenisha (2016), Bicolle: A Lipid Nanostructure for Transdermal Delivery. Journal of Critical Reviews, 3 (2), 17-22.
[23] Anton Syroeshkin, Olga Levitskaya, Elena Uspenskaya, Tatiana Pleteneva, Daria Romaykina, and Daria Ermakova. "Deuterium-Depleted Water as an Adjuvant in Treatment of Cancer." Systematic Reviews in Pharmacy 10.1 (2019), 112-117. Print. doi:10.5530/srp.2019.1.19
Downloads
Published
Issue
Section
License
Copyright (c) 2020 AUTHOR
This work is licensed under a Creative Commons Attribution 4.0 International License.
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
