(Politeknik Negeri Bandung, Indonesia)
(2) Fitri Nur Waliyaden
(Politeknik Negeri Bandung, Indonesia)(3) Gloria Theodora Wahi Leo
(Politeknik Negeri Bandung, Indonesia)(4) Mery Adelia
(Politeknik Negeri Bandung, Indonesia)(5) * Akhmad Bakhrun
(Politeknik Negeri Bandung, Indonesia)*Corresponding author
AbstractIn the Industry 4.0 era, transforming raw transactional data into strategic insights is vital for maintaining competitiveness. This study leverages Microsoft Power BI to analyze 113,037 bicycle sales records from 2011 to 2016 across Europe using descriptive quantitative methods and interactive dashboards. The analysis reveals that accessories account for the majority of unit sales (77.94%) due to their affordability and repurchase frequency, while high-end bicycles such as Road-150 Red, 62 and Mountain-200 Black, 38 contribute the highest revenue per unit. The adult age group (35–64 years) emerges as the most profitable segment, generating USD 45 million in revenue and USD 18 million in profit. A strong positive correlation (r = 0.87) between age and product price underscores the purchasing power of older consumers. Geographically, the United States dominates with 34.68% of customers and USD 15.9 million in revenue, followed by Australia and Canada. Meanwhile, Europe shows promising potential for future growth. The gender distribution is nearly balanced, with both male and female customers favoring accessories—highlighting opportunities for inclusive and gender-neutral marketing. Power BI’s visualization tools—bar charts, scatter plots, map views, and forecasting—enable dynamic trend analysis and strategic planning. This study contributes academically by enriching the literature on visual analytics in retail and practically by offering a replicable framework for data-driven decision-making in the bicycle market and other consumer goods industries.
KeywordsPower BI; Sales Analysis; Bicycle Market; Business Intelligence; Consumer Behavior, Data Visualization
|
DOIhttps://doi.org/10.33122/ejeset.v6i2.698 |
Article metricsAbstract views : 0 | PDF views : 0 |
Cite |
Full Text Download
|
References
Albanjari, I. (2021, Juni). Manajemen Penjualan Dan Personal Selling. Scribd. Manajemen Penjualan Dan Personal Selling
Azka, R., Nurhayati, Rasyidin, M., Saputra, A. M., & Ariga, H. P. S. (2024). The Reaction of Poverty to Consumption and Inflation in Indonesia. Electronic Journal of Education, Social Economics and Technology, Vol.5, No.2, 291-297. https://doi.org/10.33122/ejeset.v5i2.241
Bike Sales in Europe Countries. (n.d.). Kaggle. Retrieved April 25, 2025, from https://www.kaggle.com/datasets/sadiqshah/bike-sales-in-europe
Daruvuri, R., Ravikumar, R., Mannem, P., & Aeniga, S. R. (2024, Desember). Augmenting Business Intelligence: How AI and Data Engineering Elevate Power BI Analytics. International Journal of Innovative Research in Computer and Communication Engineering (IJIRCCE), 12. DOI: 10.15680/IJIRCCE.2024.1212002
Dora, M., Khairul, R., & Sari, W. M. (2022, Desember). Analisa Transaksi Penjualan Dalam peningkatan Promosi Penjualan Berbasis Sistem Informasi. Jurnal Ekombis Review – Jurnal Ilmiah Ekonomi dan Bisnis, 11(1), 357-368. https://doi.org/10.37676/ekombis.v111
Geralvine, E., Tanuwijaya, H., & Supriyanto, A. (2025). Mediating Role of Attitude Toward Green Brands in Green Purchase Intention. Electronic Journal of Education, Social Economics and Technology, Vol.6, No.1, 60-65. https://doi.org/10.33122/ejeset.v6i1.263
Irawan, B. H., Ariyanto, N. P., Novianti, N. A., Widiastuti, H., Restu, F., & Arifin, N. L. (2022, Desember). Penggunaan Power BI Untuk Pengolahan Data Non-Conformance Material. Jurnal Teknologi dan Riset Terapan, 4.
Iswardhana, M. R. (2024). The Development of Indonesia's Fintech and Comparation with India in Terms of Complex Interdependence Theory and Digital Economy. Electronic Journal of Education, Social Economics and Technology, 5(1), 54-62. https://doi.org/10.33122/ejeset.v5i1.332
Jabar, A. A., Wijaya, R. F., & Wahyuni, S. (2025, April). VISUALISASI DATA KECERDASAN BISNIS UNTUK MENDUKUNG ANALISIS KINERJA BISNIS PADA PT BMPT. Jurnal Teknologi Informasi, Vol. 6. DOI: 10.46576/djtechno
Khatri, A., & Gupta, N. (2022). Impact of Data Visualization on Management Decisions. London Journal of Research in Management and Business, 22.
Lisna, M. E. N., & Voutama, A. (2024, Mei). Analisis Dan Visualisasi Data Penjualan Pada NYC Property Menggunakan EDA. Jurnal Elektronik Ilmu Komputer Udayana, 12 (4), 879-886.
Morande, S., & Tiwari, V. (2023). Mapping Digital Ecosystem for Competitive Advantage Using Technological Advancements. Electronic Journal of Education, Social Economics and Technology, 4(2). https://doi.org/10.33122/ejeset.v4i2.18
Nafiisa, B. L., Putri, Y. N. W., & Ayunin, Q. (2022). Dashboard Visualisasi Data UMK Sebagai Alat Pengambilan Keputusan Menggunakan Microsoft Power BI. Jurnal Akuntansi dan Manajemen, 17. https://doi.org/10.30630/jam.v17i2.199
Nassè, T. B. (2021). THE CONCEPT OF CONSUMER BEHAVIOR: DEFINITIONS IN A CONTEMPORARY MARKETING PERSPECTIVE. International Journal of Management & Entrepreneurship Research, 3, 304-305. DOI: 10.51594/ijmer.v3i8.253
Ningsih, S. B. H., Komala, I. R., Nurhayati, L., & Suhayati, M. (2025). Visualisasi Data Kependudukan Menggunakan Power Business Intelligence (Studi Kasus Kelurahan Sukamiskin Kecamatan Arcamanik Kota Bandung). Jurnal Penelitian Sistem Informasi, 3.
Nisa, s. h. K., & Rusdianto, R. Y. (2024, Desember). Pemanfaatan Visualisasi Data dalam Meningkatkan Pengambilan Keputusan Bisnis. JURNAL INFORMASI SAINS DAN TEKNOLOGI, 7. https://doi.org/10.55606/isaintek.v7i2.290
Organ, N. (2024). Data Visualization for People of All Ages (1st Edition ed.). CRC Press. DOI: 10.1201/9781003309376
Putra, H., Qatrunnada, R., Rahmadoni, J., & Khairati, F. (2025). Enhancing Organizational Control Through Business Intelligence: Monitoring and Automated Alerts. Electronic Journal of Education, Social Economics and Technology, 6(1). https://doi.org/10.33122/ejeset.v6i1.222
Rahmawati, D. l., & Rino, R. (2025). Aida Consumer Advertising Model On Costumer Loyalty. Electronic Journal of Education, Social Economics and Technology, 6. https://doi.org/10.33122/ejeset.v6i1.495
Raihan, A. (2023). Nexus Between Economic Growth, Natural Resources Rents, Trade Globalization, FInancial Development, and Carbon Emission, Towards Environmental Sustainability in Uruguay. Electronic Journal of Education, Social Economics and Technology, 4(2), 56. https://doi.org/10.33122/ejeset.v4i2.102
Ramadhani, Y., Khairin, D. M., & Maharani, S. (2024, Juni). Implementasi Business Intelligence Dalam Analisa Penjualan Mobil Mitsubishi Menggunakan Visualisasi Data. Adopsi Teknologi dan Sistem Informasi (ATASI), 3. https://doi.org/10.30872/atasi.v3i1.435
Rini, V. O., Lukiana, N., & Sulistyan, R. B. (2021, September). Analisis Volume Penjualan Ditinjau dari Pemilihan Bahan Baku dan Persaingan Harga Pada UD. Sumber Hidup, Lumajang. Jobman: Journal of Organization and Business Management, 4(1), 111-115.
Rohmah, I. I., Rofiq, A., & Ihwan, M. B. (2025). Data Driven Educational Planning Strategy: Examining Challenges and Opportunities in the Digital Era. Electronic Journal of Education, Social Economics and Technology, 6(1). https://doi.org/10.33122/ejeset.v6i1.438
Sharda, R., Delen, D., & Turban, E. (2020). Analytics, data science, & artificial intelligence: Systems for decision support (11th ed.). Pearson, (11th Global Edition).
Shoaib, G., & Nandi, S. (2022, Juli). Power Bi Dashboard for Data Analysis. International Research Journal of Engineering and Technology (IRJET), 09.
Sholekha, E., Irawan, B., & Bahtiar, A. (2024, Juni). ANALISIS PENJUALAN PRODUK SNACK DAN MINUMAN MENGGUNAKAN METODE K-MEANS PADA DATASET TRANSAKSI PENJUALAN. JATI (Jurnal Mahasiswa Teknik Informatika), 8 (3).
Sifa, R. Y. (2024, Maret). Visualisasi Data Pengunjung dan Peminjaman Buku di Perpustakaan Daerah Menggunakan Power BI. Jurnal Sistem Informasi (TEKNOFILE), 2.
Solomon, M. R. (2020). Consumer behavior: Buying, having, and being (13th ed., Global Edition). Pearson Education Limited.
Sudirjo, F., Wahyuningsih, D., Wijayanto, G., & Wahyono, D. (2024). TEORI PERILAKU KONSUMEN DAN STRATEGI PEMASARAN (1st ed.). PT MAFY MEDIA LITERASI INDONESIA. http://repository.um.ac.id/id/eprint/5535
Tirupati, K. K., Joshi, A., Singh, S. P., Chhapola, A., Jain, S., & Gupta, A. (2023). Leveraging Power BI for enhanced data visualization and business intelligence. Universal Research Reports, 10(2), 676–699.https://doi.org/10.36676/urr.v10.i2.1375
What is Power BI? - Power BI | Microsoft Learn. (2024, March 22). Learn Microsoft. Retrieved May 6, 2025, from https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview
Yumni, S. Z., & Widowati. (2021, Februari). Implementasi Microsoft Power BI Dalam Memantau Kehadiran dan Transportasi Pegawai. Jurnal Sains dan Edukasi Sains, 4. https://doi.org/10.24246/juses.v4i1p1-8
Refbacks
- There are currently no refbacks.
Copyright (c) 2026 Indriana Kurnia Cahyati, Fitri Nur Waliyaden, Gloria Theodora Wahi Leo, Akhmad Bakhrun, Mery Adelia
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Electronic Journal of Education, Social Economics and Technology (eJESET)
ISSN 2723-6250 (Online)
Published by the SAINTIS Publishing
Homepage: http://ejeset.saintispub.com
Editor E-mail : ; editor.ejeset@gmail.com
Editorial Office Address:
