Customer Insights Analysis

The Customer Insights Analysis project aimed to derive meaningful insights from two years of customer transaction data, providing valuable information for strategic decision-making. The dataset comprised over 1 million records, including invoice details, product information, and customer locations. The analysis focused on understanding customer purchasing behavior, identifying growth opportunities, and highlighting areas for improvement.

Key insights derived from the project included:

Customer Loyalty:

Insight: Repeat customers significantly outnumber one-time customers, indicating strong customer loyalty.

Impact: Enhanced customer retention strategies, resulting in increased long-term revenue.

Product Popularity:

Insight: Sales are highly concentrated in a few key products, such as "WORLD WAR 2 GLIDERS ASSTD DESIGNS."

Impact: Improved inventory management and targeted marketing campaigns for top-selling products.

Seasonal Sales Trends:

Insight: Sales exhibit strong seasonality, with peaks during the holiday season (November-December).

Impact: Optimized inventory levels and promotional efforts to maximize sales during peak periods.

Price Sensitivity:

Insight: Customers are highly price-sensitive, primarily purchasing low-priced items.

Impact: Adjusted pricing strategy to prioritize affordability and increase sales volume.

Geographical Insights:

Insight: The United Kingdom is the dominant market, with significant sales also in the Netherlands, EIRE, Germany, and France.