Sales Interactive Dashboard

my first task as an Intern2Grow Data Analyst intern, where my task was to analyze sales data and extract key insights. I used SQL to clean the data by removing duplicates, identifying and replacing null values using mathematical calculations with existing data, and filtering out unnecessary data.

The specific tasks included:

1- Total revenue generated by the company over the year.

2- Product with the highest revenue and its total revenue.

3- Average price of products sold.

4- Total quantity of products sold.

5- Category with the highest revenue and its total revenue.

6- Average revenue per sale.

7- Total revenue generated in each quarter (Q1, Q2, Q3, Q4).