Article Per Year (5 Year)
p-Index From 2020 - 2025
4.84
P-Index
This Author published in this journals
All Journal Indonesian Journal of Electronics and Instrumentation Systems IJCCS (Indonesian Journal of Computing and Cybernetics Systems) Jurnal Buana Informatika Sinkron : Jurnal dan Penelitian Teknik Informatika JMM (Jurnal Masyarakat Mandiri) SINTECH (Science and Information Technology) Journal Jurnal Informatika Universitas Pamulang Jurnal Sisfokom (Sistem Informasi dan Komputer) Jurnal Nasional Pendidikan Teknik Informatika (JANAPATI) J-SAKTI (Jurnal Sains Komputer dan Informatika) JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika) Jurnal Mantik JPKMI (Jurnal Pengabdian Kepada Masyarakat Indonesia) BERNAS: Jurnal Pengabdian Kepada Masyarakat Jurnal Data Mining dan Sistem Informasi International Journal of Engineering, Science and Information Technology J-SAKTI (Jurnal Sains Komputer dan Informatika) Jurnal Multidisiplin Madani (MUDIMA) Jurnal WIDYA LAKSMI (Jurnal Pengabdian Kepada Masyarakat) Jurnal Krisnadana Jurnal Krisnadana Journal of Social Work and Empowerment Jurnal Media Informasi Teknologi Galaksi
Ida Bagus Gede Sarasvananda
Institut Bisnis Dan Teknologi Indonesia
Religion Agriculture, Biological Sciences & Forestry Humanities Astronomy Biochemistry, Genetics & Molecular Biology Chemical Engineering, Chemistry & Bioengineering Chemistry Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Dentistry Earth & Planetary Sciences Economics, Econometrics & Finance Education Electrical & Electronics Engineering Energy Engineering Environmental Science Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Library & Information Science Materials Science & Nanotechnology Mathematics Mechanical Engineering Neuroscience Nursing Physics Public Health Social Sciences Transportation Veterinary Other

Published : 30 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : Jurnal Media Informasi Teknologi

 1 
Enhancing Sales Reporting with Data Warehousing and Visualization: A Case Study at Graha Mas Sarasvananda, Ida Bagus Gede; Maryani, Putu Dian; Arnawan, I Nyoman
Jurnal Media Informasi Teknologi Vol. 2 No. 2 (2025): Oktober 2025
Publisher : Digital Innovation

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.69616/mit.v2i2.237

Abstract

This study aims to enhance the sales reporting process by implementing a data warehouse and interactive data visualization, with a case study at Graha Mas. The research adopts the Kimball Nine Step Methodology to guide the development of the data warehouse, supported by the Extract, Transform, Load (ETL) process using Pentaho Data Integration (PDI). Sales data sourced from Excel files undergoes batch processing to ensure data consistency and cleanliness before being stored in the warehouse. A star schema model was applied to structure the data warehouse, consisting of dimension tables for customers, products, and locations, and fact tables for sales categorized by customer, product, and city. The final data is visualized through Google Data Studio dashboards, enabling users to interactively explore sales trends by product, time period, and region. These visualizations assist business decision-makers in identifying high-performing products, monitoring regional sales distribution, and planning inventory more effectively. User acceptance testing (UAT) involving business users resulted in an acceptance score of 89%, indicating that the system meets user needs in terms of data clarity, accuracy, and usability. This research concludes that the proposed solution significantly improves the sales monitoring process at Graha Mas and can serve as a practical reference for similar businesses seeking to adopt cloud-based business intelligence solutions.
Co-Authors Alexander Gebo Andika, I Gede Anny Kartika Sari Choirul Anwar Cokorda Pramartha Dewi, Yesi Ratna Dewi, Yunita Dharsika, I Gede Eka Donaya Pasha Eka Dharsika, I Gde Erlina Putri, Ni Putu Mita I Dewa Putu Gede Wiyata Putra I Dewa Putu Gede Wiyata Putra I Gede Adnyana I Gede Iwan Sudipa I Gusti Made Ngurah Desnanjaya I Kadek Ari Arya Maheswara I Komang Arya Ganda Wiguna I Komang Arya Ganda Wiguna I Made Satria Bimantara I Nyoman Arnawan, I Nyoman I Nyoman Tri Anindia Putra I Putu Edi Setiawan I Putu Eka Giri Gunawan I Putu Hendika Permana I Wayan Supriana Ida Bagus Ary Indra Iswara Ida Bagus Ary Indra Iswara Made Suci Ariantini Maria Osmunda Eawea Monny Maryani, Putu Dian Ni Made Mila Rosa Desmayani, Ni Made Mila Rosa Putu Gede Surya Cipta Nugraha Putu Praba Santika Putu Wirayudi Aditama Putu Wirayudi Aditama Radhitya, Made Leo Rahayu G., Ni Luh Wiwik Sri Retantyo Wardoyo Sandika, I Kadek Budi Saputra, I Wayan Kelvin Widana Saraswati, Ni Wayan Sumartini Sawitri, Nyoman Sintya Selivan, Diana Styawati Styawati Styawati Styawati Styawati, Styawati Sunarya, I Wayan Suryadana, Kadek Thalib, Emmy Febriani Welda Wiguna, I Komang Arya Ganda Winda Yulita