Toy Store KPI Report

Maven toys have multiple stores located in Mexico. Provided data contains transactional record from January 2022 to September 2023 and as a data analyst I have to create a dashboard for leadership team to monitor key business metrics and high-level trends.

Dashboard has three KPI cards that shows revenue, profit and total number of orders for September 2023 and compares it with previous month. Line chart shows revenue generated for each month, we can further drill through and see revenue generated by week and day. Donut chat gives us revenue generated by each product category. By looking at the bar char we can find which product has been mostly ordered. we can also explore KPI, trends and product details for each location by selection locations from slicer.