Aplikasi Business Intelligence Dashboard sebagai Alat Monitoring dan Bahan Pengambilan Keputusan Sales and Account Receivable

Abstract

Information and data are the important assets for a company. To process data into useful information and getting to be knowledge in the decision making process at management level, there are so many companies which have difficulties, including PT XYZ which was engaging in the production of agricultural materials. PT XYZ had the difficulties in monitoring process and decision-making process related to its main business, sales and account receivable. Business Intelligence dashboard could be the best solution to overcome these problems. This research discusses related design, construction and implementation of business intelligence solutions dashboard starting from the architecture business intelligence, data warehouse in form of a data mart, ETL (extraction, transformation, and loading) process are useful for generating the quality of data, and visualization in the form of dashboard that would represent key business process with XYZ company. The method used in the development of business intelligence dashboard refers to the six-step method of executive information system that is of the justification, planning, business analysis, design, construction, deployment that would generate digital dashboard for level management. The result is a website application consisting of three digital dashboards that become visualization tools to display the information and knowledge needed in the monitoring process and become material to produce decisions related to sales and receivables. The BI solutions that are developed are in line with expectations and can meet the business needs of PT XYZ.

Marketing Dashboard as an Early Warning on PR. Gagak Hitam

“…Easy-to-understand data will make it easier for company management to evaluate and make decisions related to the marketing division and company development. To create interactive and easy-to-understand data, you can use software such as Microsoft Power Business Intelligence (BI) with a Dashboard concept that contains sales data that includes brand sales, per type of sales, turnover, finished goods stock, return movements, and bad stock movements (Putra & Sari, 2016a).…”

“…Several studies that use dashboards to evaluate the marketing division include research on PT. XYZ to measure the effectiveness and efficiency of management in strategic decisionmaking using a digital dashboard from BI (Putra & Sari, 2016b). Research using dashboards for sales reports can also be carried out in SMEs (Dewi et al, 2021).…”

Analisis Penerimaan Dashboard Monitoring Pendataan Sensus Penduduk 2020 Provinsi Nusa Tenggara Barat Menggunakan Technology Acceptance Model

“…Dashboard adalah alat visualisasi dalam business intelligence sebagai aplikasi yang berhubungan langsung dengan pengguna akhir [4]. Dasbor kinerja atau performance p-ISSN: 2406-7768 e-ISSN: 2581-2181 dashboard merupakan suatu sistem penyampaian informasi secara berlapis mulai dari jenis informasi itu sendiri, peringatan dan wawasan atau pandangan sebagaimana yang diinginkan oleh pengguna sehingga pengguna dapat melakukan pengukuran, pemantauan dan pengelolaan kinerja dengan efektif [5].…”