Sales Dashboard

Here are some discoveries :

Sales Insights:

Total sales 33.67M

Total Quantity Ordered 200.85K

Number of Orders 178K

Products have been requested from 9 Distinct Cities

The month with the highest sales number is December with 4.6M in Sales

Most of the orders were received during the time period from 11 AM to 8:35 PM

we received 233 orders at 11:58:00 AM

The product with the highest number of sales is Mac book pro laptop with 7.87M in sales

The product with the lowest number of sales is AAA batteries(4pack) with 90.81K in sales

The product with the highest number of orders is AAA batteries(4pack) with 30372 Orders

The product with the lowest number of orders is LG Dryer with 633 orders

number 1st city in sales in San Francisco

The top 5 most requested products are AAA batteries(4pack), AA batteries(4pack), lightning charging cables, USB-C charging cables, and Wired headphones.

Recommendations:

increasing our marketing efforts in the period from Jan to Sep.

The perfect time to advertise during the day is from 11 AM to 8:38 PM

make sure to focus on developing the marketing plan for Mac book pro to make sure its number of sales stays high.

review our marketing plans for the lowest cities in numbers of sales like Austin