Project Overview

The Amazon Store Analytics project is a testament to my growing expertise as a data analyst, highlighting skills in SQL and data exploration. Utilizing a Kaggle dataset, I dissected and derived valuable insights across key domains:

Sales Analysis

I quantified total revenue, identified top-selling products, calculated average order value, and pinpointed peak sales periods, showcasing my aptitude for sales analytics.

Customer Analysis

My focus on customer insights uncovered top cities/states for sales, revealed trends in order cancellations, and examined the distribution of B2B vs. B2C customers, demonstrating my proficiency in customer analytics.

Product Analysis

By categorizing popular products and analyzing styles, I delved into product popularity and average quantities ordered, offering insights that can inform inventory management and marketing.

Promotional Analysis

My investigation into the effectiveness of promotions based on discount averages and increased sales during promotions highlights my ability to assess marketing strategies.

The project reflects not only my technical prowess in SQL but also my ability to ask relevant questions, apply a variety of SQL functions and clauses, and deliver actionable insights. My progression as a data analyst is evident in the thorough exploration of the dataset and the capability to extract meaningful information.