Customer Behavior Analysis
Customer Behavior Analysis
Embedded Files
A comprehensive customer behavior analysis aimed at identifying purchasing patterns, understanding spending trends, and evaluating how different factors influence sales.
Completed Tasks
Completed Tasks
Cleaned and processed raw data using the Pandas library.
Created age groups and converted textual data into numeric values for deeper analysis.
Ran SQL queries to answer key business questions such as comparing subscriber vs. non-subscriber spending, and analyzing the impact of discounts and ratings.
Designed a Power BI dashboard featuring KPIs and interactive slicers.
Python Snippets
Python Snippets
Sample SQL Queries
Sample SQL Queries
Dashboard
Dashboard
Key Insights
Key Insights
Subscribers spend 25% more than non-subscribers.
The clothing and accessories category generates the highest revenue.
Discounts increase the number of orders but reduce revenue per transaction.
Recommendations
Recommendations
Invest more in acquiring and retaining subscribers.
Boost and promote top-selling categories like clothing and accessories.
Use smart, limited discounts to raise orders without hurting margins.
Add simple loyalty perks to increase subscriber spending
Page updated
Google Sites
Report abuse