Claim Missing Document
Check
Articles

Found 24 Documents
Search

Sales Data Visualization Using Power BI to Support Business Insight and Decision Making in FMCG Industry Az-Zahra, Kamila Nisa; Kautsar, Soraya; Wardhany, Zia; Bakhrun, Akhmad; Maheswari, Safina Salsabila Suci
Electronic Journal of Education, Social Economics and Technology Vol 6, No 1 (2025)
Publisher : SAINTIS Publishing

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

Abstract

The Fast Moving Consumer Goods (FMCG) industry operates in a highly dynamic and competitive market, where fast and accurate decision-making is essential. This study aims to develop an interactive dashboard that visualizes sales data to generate actionable business insights. By utilizing Power BI and secondary data from 2017 to 2020, the dashboard enables users to explore sales trends, market performance, product contributions, and profit margins interactively. The results show that total revenue reached 985 million with 2 million units sold. Additionally, Delhi NCR and Mumbai were identified as the most contributing regions in sales volume, while Distribution-labeled products accounted for nearly 50% of total revenue. These findings demonstrate that data visualization significantly accelerates performance analysis, identifies market opportunities, and enhances the precision of managerial decisions.
The Impact of Sense of Community and Civic Engagement on the Well-Being of Student Executive Board Members of Politeknik Negeri Bandung Maulana, Muhammad Yunus; Bakhrun, Akhmad
Jurnal Kewarganegaraan Vol. 21 No. 2 (2024): September 2024
Publisher : Department of Pancasila and Civic Education, Universitas Negeri Medan

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24114/jk.v21i2.62134

Abstract

AbstractHigher education institutions are expected to create environments that support positive growth, foster civic engagement, and enhance competencies. Hence, this study is examining the influence of sense of community and civic engagement as the antecedents of psychological aspect of student™s wellbeing. This research employs a quantitative approach using the SEM-PLS method. The questionnaire is completed by 53 respondents from a population of 222 of the Student Executive Board Members of Polban. The results show a significant difference in the influence of sense of community and civic engagement on students' wellbeing. This study presents a new evidence that a sense of community plays a crucial role in fostering civic engagement and student well-being, a connection that has not been previously explored in similar studies within the context of vocational higher education. However, civic engagement has minimal impact, direct or mediated. This study recommends that campuses prioritize community-building to enhance positive student development.---------------AbstrakPerguruan tinggi diharapkan menjadi lingkungan yang mendukung pertumbuhan positif, bangkitnya keterlibatan warga negara serta peningkatan kompetensi sebagai calon profesional. Maka dari itu, penelitian ini menguji pengaruh rasa kebersamaan dan keterlibatan sipil sebagai anteseden dari aspek psikologis kesejahteraan mahasiswa. Penelitian menggunakan pendekatan kuantitatif dengan metode SEM-PLS. Kuesioner penelitian diisi oleh 53 orang sampel dari populasi berjumlah 222 orang pengurus dan anggota BEM Polban kabinet Pilar Impresif. Hasil analisis menampikan adanya signifikansi yang berbeda antara rasa kebersamaan dan keterlibatan sipil terhadap kesejahteraan mahasiswa. Penelitian ini menunjukan bukti baru bahwa rasa memiliki berperan penting dalam mendorong keterlibatan sipil dan kesejahteraan mahasiswa yang belum pernah diungkap dalam kajian serupa pada konteks pendidikan di perguruan tinggi vokasi. Adapun, pengaruh keterlibatan sipil, baik secara langusng maupun sebagai mediator rasa memiliki terhadap kesejahteraan mahasiswa, hasilnya ternyata tidak signifikan. Hasil kajian ini menunjukan bahwa arah kebijakan perlu memprioritaskan internalisasi aspek rasa kebersamaan secara efektif terhadap perkembangan positif mahasiswa.  
Data Visualization to Analyze Consumer Behavior for Strategic Business Decision Making in the Retail Industry: Walmart Case Study Bakhrun, Akhmad; Maghfyra, Yasyfa; Putri, Rintan Nurhayati; Larassati, Dewi Ayu
CSRID (Computer Science Research and Its Development Journal) Vol. 17 No. 3 (2025): Oktober 2025
Publisher : LPPM Universitas Potensi Utama

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.22303/csrid-.17.3.2025.354-371

Abstract

This research focuses on data visualization to analyze consumer behavior in an effort to make strategic business decisions in the retail industry, taking the Walmart Case Study. The main objective of this study is to explore customer consumption patterns and generate data-based insights that can be utilized in formulating marketing strategies and managing retail operations. A quantitative approach is applied through systematic stages, including problem identification, literature study, data collection, Extract, Transform, Load (ETL) process, analysis, visualization, and data interpretation. The dataset used includes 50,000 Walmart customer transactions during the period January 2024 to February 2025. The use of interactive data visualization using Microsoft Power BI successfully transformed raw data into strategic insights. Key findings from the analysis indicated that the majority of transactions came from loyal customers at $6.46 million (50.58%), emphasizing the importance of customer retention strategies. In addition, customer purchasing activity was much more dominant on weekdays, with weekday purchases totaling $9.07 million compared to weekend purchases totaling $3.70 million. The data also shows that Generation X dominates the overall purchase value compared to other age groups, with purchases totaling $5.04 million. In addition, in-depth analysis of the most popular product categories, segmentation by gender, and payment method preferences provided comprehensive insights. These visualization results significantly support fast and evidence-based business decision-making. This research contributes to retail business practice through an applicable data visualization approach, and opens up opportunities for further development such as the integration of machine learning for predictive analysis and wider exploration of BI tools to improve the accuracy and scope of business analysis in the future.
VISUALIZING THE GROWTH OF ELECTRIC VEHICLES (2010–2024) USING POWER BI: A DATA-DRIVEN INSIGHT Sonjaya, Rizaldi Putra; Zulvikri, Mochammad; Fadhlurohman, Muhammad Thoriq; Bakhrun, Akhmad
Electronic Journal of Education, Social Economics and Technology Vol 6, No 1 (2025)
Publisher : SAINTIS Publishing

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

Abstract

This study investigates the surge in global electric vehicle (EV) adoption from 2010 to 2024 by utilizing Power BI as a data visualization tool. The research problem centers on the lack of integrated, real-time visual analysis that captures temporal trends, regional disparities, and powertrain diversity within EV markets—particularly in developing countries. Using a descriptive quantitative method, this study employed four main stages: data collection, processing, visualization, and interpretation. Data was sourced from the Kaggle platform and processed using Power BI’s star-schema model. The result is an interactive dashboard that allows users to explore EV data across drivetrain types, parameters (sales, stock, share), regions, and years. The findings highlight a sharp increase in EV sales between 2020 and 2023, with significant adoption in the USA, China, and Europe. Conversely, Southeast Asia, including Indonesia, remains limited by infrastructural and economic challenges. The study demonstrates that BEVs dominate market share, while FCEVs remain in the early adoption stage. By integrating visual elements such as slicers, KPIs, and trend graphs, Power BI enables deeper analysis and informed decision-making. The implications of this study are relevant for policymakers and industry leaders seeking real-time, actionable insights to guide EV adoption strategies in various regions. KEY WORDS: Data Visualization, Electric Vehicles, Power BI, Dashboard, Regional Adoption