From our dataset given we are to analyze the trend in the our bike sales and to understand which country bring more of the sales and important metric like Revenue generated, total number of customer, order quantity and so much more. .
we created extra column highlighted in the purple color where we have the Revenue, Month, Month name, Weekday Name, and hour. The goal is to find the The month that bring in more sales? What hour do we experience high customer? Which weekday seems to be the busiest and customer enjoy coffee? Which location brings in more of the revenue? Generally, create a dashboard for easy navigation and to better understand the data to make inform decision.
This Dashborad focuses on the the key metrics of understanding different reasons of cases brought on the service desk such as High, Medium, and Low cases, Agent with the highest number of cases, Users with the number of cases, Category with the number of cases.
The objective of this project is to design an Electronic Sales Performance system that helps management make data-driven decisions about sales, pricing, and promotions. Using SQL for data analysis and Excel for reporting and visualization, the project aims to: Track and monitor accessories across regions to prevent stockouts and overstocking. Identify fast-moving and slow-moving products to optimize stock allocation. Evaluate sales performance by product, category, monthly trend, and region.