Maven Market Revenue Dashboard

Maven Market is a fictional supermarket chain with stores in the US, Canada and Mexico.

The country sales directors and store location managers need a dashboard to track revenue trends, product performance and store performance in the respective cities.

Some of the key questions that they want to answer are:

1. How much revenue was generate this month?
2. How did we perform compared to previous months?
3. Which are the best performing stores in the various countries?
4. Which are the best performing brands by profit margin?

Key Insights

• Plato products had the highest profit margin (63.55%) in 1998.
• Despite Horatio products having the highest overall return rate(1.26%) this year, they experienced a 26.56% increase in profit over the last quarter of 1998.
• In the lowest performing store(Store 5) in the US, Cormorant products(top 3 brand overall) seem to be generating the highest profit margin(63.06%). There should be more promotions for the products to boost sales in this store.

DATA SOURCE: Maven Analytics - provided in the Microsoft Power BI Desktop for Business Intelligence (2023) course.