Main Article Content

Utari Apriani
Dedi Trisnawarman
Zyad Rusdi


Data warehouse is part of BI that can facilitate managers in analyzing data. From these data can be made as an input design dashboard. The purpose of this thesis is to design a data warehouse and dashboard design. The process used for the data warehouse is data mart, OLAP, OLTP, dimension table and fact table. The method used in making the dashboard is Requirements Prototype which has 7 stages consisting of needs analysis, making prototypes, adjusting prototypes with user desires, creating new systems, testing systems, adjusting user desires and using the system. The results of this system are expected to be visually clearly visible to the management of PT Petra Sejahtera Abadi and facilitate the analysis of sales and purchase developments and support company management in making decisions.

Article Details



Few, S. 2006. Information Dashboard Design: Displaying Data for At-a-Glance Monitoring Second Edition. Analytics Press.

Jacques, W. 2011. Key Performance Indicators (KPI): Defination and Action.

Mcleod, R., Schell, G., 2004. Management Information Systems, 9th Edition.

Mulyani, S. 2017. Metode Analisis dan Perancangan Sistem. Bandung. Abdi Sistematika.

Trisnawarman, D., & Rusdi, Z. 2018. Rekayasa Perangkat Lunak Sistem Monitoring Dan Evaluasi Program Pembangunan Desa. Jakarta. Computatio: Journal of Computer Science and Information Systems.

Rusdi, Z., & Trisnawarman, D. 2018. Desain Dashboard Untuk Pendukung Sistem Cerdas Analisis Kesesuaian Kebutuhan Dan Ketersediaan SumberDaya Pembangunan Desa Mandiri. Jakarta. Computatio: Journal of Computer Science and Information Systems.

Parmeter, D. 2017. Key Performance Indicator(KPI) : Developing, Implementing, and Using Winning 2 KPI Edition. New York, John Wiley & Sons Inc.

Satzinger, J., Jackson, R., & Burd, S. 2011. System Analysis and Design in a Changing World 6th Edition. Course Techno.

Novell, 2004. “Secure Enterprise Dashboard a Key Bussiness Agility”. White Paper.