Insights Unboxed: Maven Toys Revenue Dashboard

The "Insights Unboxed: Maven Toys Revenue Dashboard" was developed as part of the Advanced Excel Dashboard Design course to provide Maven Toys' Regional Sales Managers with a comprehensive view of revenue performance across locations. This dashboard enables users to easily navigate through data, focusing on specific regions and time periods. Key features include dynamic filtering, detailed KPIs, and visual analyses of top and bottom products to help identify growth opportunities and areas needing improvement.

For instance, the dashboard revealed contrasting trends in Chicago's stores, with Millennium performing strongly while O’Hare faced revenue challenges. This insight allows Maven Toys to strategize effectively, tailoring inventory and promotions to boost underperforming locations. Additionally, the dashboard's top and bottom product analysis, spotlighting items like the Nerf Gun and Lego Bricks, provides valuable input for inventory adjustments and marketing campaigns.

Skills applied: Data Cleaning & Preparation, Dynamic Filtering, Top & Bottom Product Analysis, Advanced Excel Formulas, and Interactive Visualization.

Link Here: https://www.loom.com/share/15734f6d89a149a1b6df49ae07920305?sid=5658f5aa-2886-427e-b719-02df63e6d6ba