The Dark Knight Rises

Batman has officially entered the race! Although he is used to saving lives and fighting criminals, he found a gap in his busy schedule to save Maven Toys time and money by providing an in-depth analysis of the Maven Toys Stores in Mexico, helping them to make the right next move.

The Mission

The dataset is a sample of sales & inventory data for a fictitious chain of toy stores in Mexico called Maven Toys, including information about products, stores, daily sales transactions, and current inventory levels at each location.

The goal was to create a dashboard to help Maven Toys answer these questions:

Which product category drives the most profits? Is this the same across store locations? Can you find any seasonal trends or patterns in the sales data? Are sales being lost with out-of-stock products at particular locations? How much money is tied up in inventory at the toy stores? And lastly recommendation for the best possible new location.