Unlocking the Power of Regional Sales -A Comprehensive Dashboard for US Toy Store Chain Performance Analysis

Objective & Precedents

A small toy store chain in the US requires the preparation of a new monthly dashboard for the company’s Regional Sales Managers.

The dashboard should be able to filter by region, track monthly revenue trends, compare performance year-over-year, compare performance across stores, and identify which specific products drove the biggest gains and losses.

Key Objectives

1. Define the purpose for the dashboard
2. Choose the key metrics & interactivity
3. Plan 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.

Dataset Summary

• Monthly sales figures, from January 2020 to July 2021
• Dimensions: Year, Month, Store Name/Region/Type, Product Name/Category
• Measures: Units Sold, Revenue, Profit