Sales Analysis Using SQL

SQL project focused on uncovering valuable insights from a sales dataset.

Here's what I analyzed:

Seasonality Patterns & Business Trends

Identified recurring sales peaks and dips across months and years to understand how seasonality impacts business performance.

Cumulative Growth Analysis

Tracked cumulative sales over time to evaluate whether the business is growing or declining — with clear year-over-year comparisons.

Performance vs. Target Analysis

Measured actual performance against sales targets to quickly spot gaps or achievements, helping decision-makers stay on track.

Part-to-Whole Analysis

Revealed a heavy reliance on a single product category – Bikes – an insight critical for diversification and risk management strategies.

? Data Segmentation

Segmented data by product cost, and product category to enable targeted marketing and regional strategy optimization.

Customer Reporting

Created a detailed customer-level report highlighting purchase frequency, average order value, customer age, and customer status.

Tools Used:

SQL (CTEs, Window Functions, Aggregations, CASE statements, SubQuery)