Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Electronic Journal of Education, Social Economics and Technology
Gloria Theodora Wahi Leo
Politeknik Negeri Bandung
Religion Arts Humanities Computer Science & IT Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Environmental Science Health Professions Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Library & Information Science Mathematics Nursing Public Health Social Sciences Veterinary Other

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

Found 1 Documents
Search

 1 
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.
Co-Authors Bakhrun, Akhmad Fitri Nur Waliyaden Indriana Kurnia Cahyati Mery Adelia