Perancangan Dashboard Business Intelligence untuk Analisis Data Penjualan Menggunakan Power BI
Kata Kunci:
Business Intelligence, Dashboard, Power BI, Analisis Penjualan, Pemodelan DataAbstrak
Data penjualan yang tersebar pada berbagai berkas dan sistem sering kali sulit dimanfaatkan untuk pengambilan keputusan yang cepat. Penelitian ini bertujuan merancang dashboard Business Intelligence untuk analisis data penjualan menggunakan Microsoft Power BI. Metode yang digunakan mengadaptasi Design Science Research Methodology dengan tahapan identifikasi kebutuhan, penyiapan data, transformasi menggunakan Power Query, pemodelan data skema bintang, perhitungan ukuran dengan DAX, dan perancangan visual berdasarkan prinsip desain dashboard. Perancangan didemonstrasikan pada dataset penjualan sintetis berisi 14.675 baris transaksi, 9.316 pesanan, 900 pelanggan, dan 30 produk selama periode 2023–2024. Hasil perancangan berupa model data dengan satu tabel fakta dan lima tabel dimensi, sepuluh measure DAX inti, serta dashboard tiga halaman yang menampilkan lima KPI utama, tren bulanan, dan rincian menurut kategori, wilayah, kanal, dan produk. Pada dataset tersebut, dashboard menampilkan pendapatan 2024 sebesar Rp4,61 miliar (naik 9,4% dibanding 2023) dengan margin laba 22,8%, serta memperlihatkan bahwa produk berpendapatan tertinggi hanya bermargin 10,7%, wawasan yang sulit terlihat pada laporan tabular. Evaluasi berbasis daftar periksa menunjukkan seluruh kebutuhan informasi dan kriteria desain terpenuhi. Kontribusi penelitian ini adalah kerangka perancangan yang dapat direplikasi dan diadaptasi pada data penjualan nyata; uji kegunaan dengan pengguna akhir menjadi pekerjaan lanjutan.
Unduhan
Referensi
[1] H. Chen, R. H. L. Chiang, and V. C. Storey, “Business intelligence and analytics: From big data to big impact,” MIS Q., vol. 36, no. 4, pp. 1165–1188, Dec. 2012, doi: 10.2307/41703503.
[2] H. J. Watson, “Tutorial: Business intelligence – Past, present, and future,” Commun. Assoc. Inf. Syst., vol. 25, Art. no. 39, 2009.
[3] S. Negash, “Business intelligence,” Commun. Assoc. Inf. Syst., vol. 13, Art. no. 15, pp. 177–195, 2004.
[4] S. Chaudhuri, U. Dayal, and V. Narasayya, “An overview of business intelligence technology,” Commun. ACM, vol. 54, no. 8, pp. 88–98, Aug. 2011, doi: 10.1145/1978542.1978562.
[5] T. H. Davenport, “Competing on analytics,” Harv. Bus. Rev., vol. 84, no. 1, pp. 98–107, Jan. 2006.
[6] T. H. Davenport and J. G. Harris, Competing on Analytics: The New Science of Winning. Boston, MA, USA: Harvard Business School Press, 2007.
[7] Ö. Işık, M. C. Jones, and A. Sidorova, “Business intelligence success: The roles of BI capabilities and decision environments,” Inf. Manag., vol. 50, no. 1, pp. 13–23, Jan. 2013, doi: 10.1016/j.im.2012.12.001.
[8] A. Popovič, R. Hackney, P. S. Coelho, and J. Jaklič, “Towards business intelligence systems success: Effects of maturity and culture on
analytical decision making,” Decis. Support Syst., vol. 54, no. 1, pp. 729–739, Dec. 2012, doi: 10.1016/j.dss.2012.08.017.
[9] S. Few, Information Dashboard Design: Displaying Data for At-a-Glance Monitoring, 2nd ed. Burlingame, CA, USA: Analytics Press, 2013.
[10] A. Sarikaya, M. Correll, L. Bartram, M. Tory, and D. Fisher, “What do we talk about when we talk about dashboards?,” IEEE Trans. Vis. Comput. Graphics, vol. 25, no. 1, pp. 682–692, Jan. 2019, doi: 10.1109/TVCG.2018.2864903.
[11] O. M. Yigitbasioglu and O. Velcu, “A review of dashboards in performance management: Implications for design and research,” Int. J. Account. Inf. Syst., vol. 13, no. 1, pp. 41–59, Mar. 2012, doi: 10.1016/j.accinf.2011.08.002.
[12] A. Ferrari and M. Russo, Introducing Microsoft Power BI. Redmond, WA, USA: Microsoft Press, 2016.
[13] Microsoft, “What is Power BI?,” Microsoft Learn. [Online]. Available: https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview (accessed Sep. 30, 2026).
[14] M. Saputra and Tony, “Rancang bangun dashboard penjualan pada PT. XYZ dengan Microsoft PowerBI,” J. Ilmu Komput. dan Sist. Inf., vol. 11, no. 2, Aug. 2023, doi: 10.24912/jiksi.v11i2.26028.
[15] B. J. Goh and D. Trisnawarman, “Perancangan prototipe business intelligence dashboard penjualan PT ABC,” J. Ilm. Univ. Batanghari Jambi, vol. 24, no. 1, Feb. 2024, doi: 10.33087/jiubj.v24i1.4704.
[16] D. Orlovskyi and A. Kopp, “A business intelligence dashboard design approach to improve data analytics and decision making,” in Proc. 7th Int. Conf. Inf. Technol. Interact. (IT&I 2020), Kyiv, Ukraine, Dec. 2020, CEUR Workshop Proc., vol. 2833, pp. 48–59.
[17] A. Kopp and D. Orlovskyi, “An approach to forming dashboards for business process indicators analysis using fuzzy and semantic
technologies,” in Proc. ICTERI 2018 PhD Symp., Kyiv, Ukraine, May 2018, CEUR Workshop Proc., vol. 2122, pp. 1–7.
[18] N. Ain, G. Vaia, W. H. DeLone, and M. Waheed, “Two decades of research on business intelligence system adoption, utilization and success – A systematic literature review,” Decis. Support Syst., vol. 125, Art. no. 113113, Oct. 2019, doi: 10.1016/j.dss.2019.113113.
[19] H. J. Watson and B. H. Wixom, “The current state of business intelligence,” Computer, vol. 40, no. 9, pp. 96–99, Sep. 2007, doi: 10.1109/MC.2007.331.
[20] S. Chaudhuri and U. Dayal, “An overview of data warehousing and OLAP technology,” ACM SIGMOD Rec., vol. 26, no. 1, pp. 65–74, Mar. 1997, doi: 10.1145/248603.248616.
[21] W. H. Inmon, Building the Data Warehouse, 4th ed. Indianapolis, IN, USA: Wiley, 2005.
[22] B. H. Wixom and H. J. Watson, “An empirical investigation of the factors affecting data warehousing success,” MIS Q., vol. 25, no. 1, pp. 17–41, Mar. 2001.
[23] W. Yeoh and A. Koronios, “Critical success factors for business intelligence systems,” J. Comput. Inf. Syst., vol. 50, no. 3, pp. 23–32, 2010.
[24] S. Rouhani, A. Ashrafi, A. Zare Ravasan, and S. Afshari, “The impact model of business intelligence on decision support and organizational benefits,” J. Enterp. Inf. Manag., vol. 29, no. 1, pp. 19–50, 2016.
[25] M. Z. Elbashir, P. A. Collier, and M. J. Davern, “Measuring the effects of business intelligence systems: The relationship between business
process and organizational performance,” Int. J. Account. Inf. Syst., vol. 9, no. 3, pp. 135–153, Sep. 2008.
[26] D. Larson and V. Chang, “A review and future direction of agile, business intelligence, analytics and data science,” Int. J. Inf. Manag., vol. 36, no. 5, pp. 700–710, Oct. 2016.
[27] G. Garani, A. Chernov, I. Savvas, and M. Butakova, “A data warehouse approach for business intelligence,” in Proc. IEEE 28th Int. Conf. Enabling Technol.: Infrastruct. Collaborative Enterprises (WETICE), 2019, pp. 70–75.
[28] W. W. Eckerson, Performance Dashboards: Measuring, Monitoring, and Managing Your Business, 2nd ed. Hoboken, NJ, USA: Wiley, 2010.
[29] W. S. Cleveland and R. McGill, “Graphical perception: Theory, experimentation, and application to the development of graphical methods,” J. Am. Stat. Assoc., vol. 79, no. 387, pp. 531–554, 1984, doi: 10.1080/01621459.1984.10478080.
[30] E. R. Tufte, The Visual Display of Quantitative Information, 2nd ed. Cheshire, CT, USA: Graphics Press, 2001.
[31] I. Vessey, “Cognitive fit: A theory-based analysis of the graphs versus tables literature,” Decis. Sci., vol. 22, no. 2, pp. 219–240, 1991, doi: 10.1111/j.1540-5915.1991.tb00344.x.
[32] B. Shneiderman, “The eyes have it: A task by data type taxonomy for information visualizations,” in Proc. IEEE Symp. Vis. Lang., Boulder, CO, USA, 1996, pp. 336–343, doi: 10.1109/VL.1996.545307.
[33] J. Heer and B. Shneiderman, “Interactive dynamics for visual analysis,” Commun. ACM, vol. 55, no. 4, pp. 45–54, Apr. 2012, doi: 10.1145/2133806.2133821.
[34] C. N. Knaflic, Storytelling with Data: A Data Visualization Guide for Business Professionals. Hoboken, NJ, USA: Wiley, 2015.
[35] T. Munzner, Visualization Analysis and Design. Boca Raton, FL, USA: CRC Press, 2014.
[36] D. Parmenter, Key Performance Indicators: Developing, Implementing, and Using Winning KPIs, 3rd ed. Hoboken, NJ, USA: Wiley, 2015.
[37] R. Kimball and M. Ross, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd ed. Indianapolis, IN, USA: Wiley, 2013.
[38] R. Kimball, M. Ross, W. Thornthwaite, J. Mundy, and B. Becker, The Data Warehouse Lifecycle Toolkit, 2nd ed. Indianapolis, IN, USA: Wiley, 2008.
[39] Microsoft, “Understand star schema and the importance for Power BI,” Microsoft Learn. [Online]. Available:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema (accessed Sep. 30, 2026).
[40] A. Ferrari and M. Russo, Analyzing Data with Power BI and Power Pivot for Excel. Redmond, WA, USA: Microsoft Press, 2017.
[41] M. Russo and A. Ferrari, The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2nd ed. Redmond, WA, USA: Microsoft Press, 2019.
[42] B. Larson, Data Analysis with Microsoft Power BI. New York, NY, USA: McGraw-Hill Education, 2020.
[43] K. Peffers, T. Tuunanen, M. A. Rothenberger, and S. Chatterjee, “A design science research methodology for information systems research,” J. Manag. Inf. Syst., vol. 24, no. 3, pp. 45–77, 2007, doi: 10.2753/MIS0742-1222240302.
[44] A. R. Hevner, S. T. March, J. Park, and S. Ram, “Design science in information systems research,” MIS Q., vol. 28, no. 1, pp. 75–105, Mar. 2004, doi: 10.2307/25148625.
[45] R. Wirth and J. Hipp, “CRISP-DM: Towards a standard process model for data mining,” in Proc. 4th Int. Conf. Practical Appl. Knowl. Discovery Data Mining, Manchester, U.K., 2000, pp. 29–39.
[46] J. Nielsen and R. Molich, “Heuristic evaluation of user interfaces,” in Proc. SIGCHI Conf. Hum. Factors Comput. Syst. (CHI ’90), Seattle, WA, USA, 1990, pp. 249–256, doi: 10.1145/97243.97281.
[47] J. Brooke, “SUS: A ‘quick and dirty’ usability scale,” in Usability Evaluation in Industry, P. W. Jordan, B. Thomas, B. A. Weerdmeester, and I. L. McClelland, Eds. London, U.K.: Taylor & Francis, 1996, pp. 189–194.
[48] A. Bangor, P. T. Kortum, and J. T. Miller, “An empirical evaluation of the System Usability Scale,” Int. J. Hum.–Comput. Interact., vol. 24, no. 6, pp. 574–594, 2008, doi: 10.1080/10447310802205776.
[49] F. D. Davis, “Perceived usefulness, perceived ease of use, and user acceptance of information technology,” MIS Q., vol. 13, no. 3, pp. 319–340, Sep. 1989, doi: 10.2307/249008.
[50] W. H. DeLone and E. R. McLean, “The DeLone and McLean model of information systems success: A ten-year update,” J. Manag. Inf. Syst., vol. 19, no. 4, pp. 9–30, 2003, doi: 10.1080/07421222.2003.11045748.
Diterbitkan
Terbitan
Bagian
Lisensi
Hak Cipta (c) 2026 Abduhu Rafik, Romeo Djefzy Romadhoni (Penulis)
Artikel ini berlisensi Creative Commons Attribution 4.0 International License.
