Excel Dashboard: Maven Toys

The Maven Toys project is part of the course, "Microsoft Excel: Advanced Excel Dashboard Design," on Udemy.

In this mock project, Maven Toys is a small toy store chain in the US. The company needs a new monthly dashboard that management can use during their monthly meeting to filter their data by region, track monthly revenue trends, and see performance year-over-year. The dashboard also needs to compare performance across stores and identify which projects drove the biggest gains and losses. The dashboard is explanatory and exploratory.

The data set is monthly sales figures from January 2020 to July 2021. The variables included are year, month, store name, region, type, product name, category, units sold, revenue, and profit.

The key objectives for this project are:

1. Define the purpose of the dashboard.

2. Choose the key metrics & interactivity.

3. Plan ahead for growing source data.

4. Prepare the data for visualization.

5. Create primary & supporting visuals.

6. design the final dashboard layout.

7. Configure the workbook for sharing.

This project includes the following features:

• a KIP chart, a line chart (with zero values hidden), and bar charts,

• two tables,

• IF, VLOOKUP, NA(), INDEX(MATCH()), top N functions,

• previous period calculations,

• automatic sorting,

• conditional formatting,

• linked pictures,

• absolute structured references,

• sharing dashboard online,

• custom color theme, and

• worksheet and structure protection.

Download file