Claim Missing Document
Check
Articles

Found 2 Documents
Search

Bike Sales Analysis for Understanding Market Trends in Europe via Power BI Dashboard Indriana Kurnia Cahyati; Fitri Nur Waliyaden; Gloria Theodora Wahi Leo; Mery Adelia; Akhmad Bakhrun
Electronic Journal of Education, Social Economics and Technology Vol 6, No 2 (2025)
Publisher : SAINTIS Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33122/ejeset.v6i2.698

Abstract

In 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.
Pendampingan Administrasi Layanan Pasang Baru dan Perubahan Daya Berbasis Digital pada PT XYZ (Persero) Unit Layanan Pelanggan A Fitri Nur Waliyaden; Dewi Sekar Ayu; Tangguh Dwi Pramono; Ananda Mellyssa Qur’atul Ain; Imma Andiningtyas RS
JABI: Jurnal Abdimas Bhakti Indonesia Vol 7 No 1 (2026): Juni
Publisher : UNIVERSITAS BHAMADA SLAWI

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.36308/jabi.v7i1.950

Abstract

Pertumbuhan jumlah pelanggan listrik menuntut unit layanan pelanggan mengelola layanan pasang baru dan perubahan daya secara tertib dan mudah ditelusuri. Kegiatan pengabdian ini bertujuan mendukung administrasi layanan pelanggan berbasis digital pada PT XYZ (Persero) Unit Layanan Pelanggan A. Kegiatan difokuskan pada pendampingan administrasi, pengecekan dokumen, pemantauan permohonan, pengarsipan digital, dan identifikasi kebutuhan tindak lanjut layanan. Metode yang digunakan adalah deskriptif kualitatif melalui observasi langsung, pendampingan pekerjaan administrasi, dokumentasi proses, dan diskusi dengan petugas layanan. Luaran kegiatan berupa rancangan daftar periksa dokumen dan pesan standar tindak lanjut layanan digital. Daftar periksa mencakup identitas pelanggan, jenis layanan, dokumen lokasi dan instalasi, dokumen pendukung berdasarkan kategori pelanggan, status permohonan, dan catatan tindak lanjut. Pesan standar disusun untuk membantu penyampaian informasi yang konsisten kepada pelanggan terkait dokumen yang belum lengkap, permohonan yang menunggu validasi, dan kebutuhan tindak lanjut teknis. Kegiatan ini menunjukkan bahwa pendampingan administrasi dapat membantu memperjelas tahapan layanan dan menemukan perbaikan praktis dalam pengelolaan layanan digital. Rancangan luaran tersebut dapat menjadi masukan untuk meningkatkan ketelitian dokumen, keterlacakan permohonan, dan keseragaman komunikasi pelanggan.