Strategic Customer Shopping Behaviour Analysis and Sales Optimization using Business Intelligence

Read full text Summarise with VIRAT
Authors: Bhuvaneswar G, Jagadhesan B
Cited by: 0

Summary

No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.

Summarise with VIRAT Free to try with your Science Catalogs account.

Abstract

This study focuses on analyzing customer shopping behaviour and optimizing sales strategies using Business Intelligence (BI) techniques. The project is based on a dataset containing 3,900 customer transactions across multiple product categories. The analysis integrates Python for data preprocessing, SQL for structured querying, and Power BI for interactive data visualization. Key variables examined include customer demographics, purchase behaviour, subscription status, discount usage, and product categories. The findings reveal that clothing generates the highest revenue and sales volume, while accessories also contribute significantly to overall performance. Subscription adoption remains relatively low (27%), yet subscribers demonstrate consistent spending patterns. Discounts play a critical role in influencing purchase decisions, particularly for products such as hats and sneakers. Additionally, demographic analysis shows that young adults and middle-aged customers are the primary contributors to revenue. The study highlights the importance of leveraging Business Intelligence tools to uncover actionable insights. Based on the analysis, strategic recommendations are proposed, including enhancing subscription programs, optimizing discount policies, strengthening customer loyalty initiatives, and implementing targeted marketing strategies. Overall, this project demonstrates how data-driven decision-making can help retail organizations improve customer engagement, increase sales performance, and achieve sustainable business growth.

Fields of Study & Subjects

Big Data and Business Intelligence Consumer Market Behavior and Pricing Customer churn and segmentation

Publication details

Journal / source
Zenodo (CERN European Organization for Nuclear Research)
Publication date
22 March 2026
Language
EN