Global Electronics Sales Dashboard

Sales data for a fictitious global electronics retailer, including tables containing information about transactions, products, customers, stores and currency exchange rates.

Objectives:

1. What types of products does the company sell, and where are customers located?
2. Are there any seasonal patterns or trends for order volume or revenue?
3. How long is the average delivery time in days? Has that changed over time?
4. Is there a difference in average order value (AOV) for online vs. in-store sales?

Key Insights:

1. Offline stores are generating more revenue than online store.
2. USA contributes the largest % of revenue and presence of offline stores.
3. The avg delivery time is 4.5 days.
4. Majority of the brands had a successful year in 2019 except for Northwind Traders which had their highest revenue in 2018.
5. FY 2020 took a significant toll for all the brands as revenue and no of store openings dropped significantly.
6. USA again stands 1st with respect to customer base holdings, followed by Canada and Australia.
7. Computers is the highest revenue generating category.****

Please find the link to my video presentation of this project: Global Electronics Sales Analysis