Ad-hoc Analysis of Sales data using SQL

Ad-hoc Analysis of Sales data using SQL

This project is an exploratory data analysis aimed at understanding the sales patterns and cohort analysis of sales and customer data for an e-commerce store.

Skills demonstrated: Data Analysis, SQL, BigQuery

The report answers the following business questions:

  1. What are the top performing products and where they are coming from?

Query:

2. Which sales channel brings the most sales?

Query:

Query:

3. What are the customers who made orders less than 300 units in 2020?

4. Analyse the customer pruchasing behaviour over time (cohort analysis)

Query:

5. Total order quantites per day of the week.

Query:


6.Calculate the total order qunatities for each month

Query:

7. Show the annual sales trend over the entire period.

Query:

Thank You!

You can access the code from this Github Repo:

Read detail project report here.