Perancangan dan Pembuatan Data Warehouse dan Business Intelligence pada Market Research Motorcycle Honda MPM Motor

Erriv Septianfan Budi, Leo Willyanto Santoso, Lily Puspa Dewi

Abstract


Honda MPM (Mitra Pinasthika Mulia) Distributor have a market research system that only covers internal matters such as sales results, and Honda MPM Distributors also use government data in making decisions. However, in collecting and analyzing government data, Honda MPM Distributor company is done by typing government data on the Microsoft Excel program manually and table reporting that is not connected with sales data. This led to the slow pace of the market research process and wasted considerable time coupled with the large number of areas divided between villages and cities.

Therefore, the data warehouse as business intelligence is needed by Honda MPM Motor companies in accelerating company data management process and as a tool to help create reports that could simplify their analysis on market research.

Data collected in the data warehouse is correct and complete. The resulting report helps facilitate the provision of needed division head information for market research in a city / regency concerning economic GRDP (Gross Regional Domestic Product) crops, livestock, services, population development and motor population, and motorized sales details (buyer’s gender, motor type purchased, buyer's job) through the Power BI application. But, the application can continue to grow with increasing data obtained from the government. Based on the results of the questionnaire conducted 80% both 20% is very good for the convenience provided by this reporting application as an effort to help market analysis and 60% good 40% is very good for the overall reporting program.


Keywords


data warehouse; business intelligence; market research; Honda MPM Distributor

Full Text:

PDF

References


Brannon, N. 2010. Business Intelligence and E-Discovery. Intellectual Property & Technology Law Journal Vol.22.

Dedić, N., & Stainer, C. 2016. Measuring the Success of Changes to Existing Business Intelligence Solutions to Improve Bussiness Intelligence Reporting. Lecture Notes in Business Information Processing, 255-268.

Beall, A. 2019. Strategic Market Research: A Guide to Conducting Research that Drives Businesses Third Edition. Beall Research.

Santoso, L., & Yulia. 2014. Data Warehouse with Bid Data Technology for Higher Education. In Procedia Computer Science Vol 124 no 1.

PT Mitra Pinasthika Mulia. 2019. Profil Perusahaan. Diambil kembali 6 February, 2019, dari http://mpmhondajatim.com/profil.

Rainardi, V. 2008. Building a Data Warehouse. New York: Springer-Verlag New York Inc.

Retno, T., Ditha, K., & Rosa, D. 2017. Penerapan Business Intelligence Pada Sistem Informasi Penjualan PT.Winsa. Palembang: Jurusan Sistem Informasi Fakultas Ilmu Komputer.

Subiyanto, Y. 2006. Perancangan dan Pembuatan Data Warehouse dan OLAP tools pada perusahaan "X". Surabaya: Universitas Kristen Petra.

Thomas, S., & Wooledge, S. 2017. Modern Bussiness Intelligence : Leading the Way to Big Data Success. Arcadia Data.


Refbacks

  • There are currently no refbacks.


Jurnal telah terindeks oleh :