Executive Scorecard Dashboard

Overview

I built a weekly executive scorecard dashboard to make ecommerce performance easier to review across multiple sales channels. The dashboard brought together sales, units, orders, revenue, gross profit, advertising spend, TACOS, net sales, and margin metrics in one place.

The goal was to create a reporting tool that made performance easy to understand without needing to manually pull reports from multiple systems.

Problem

Performance data was spread across different channels and reports. Reviewing the business required manual exports, spreadsheet work, and repeated calculations.

It was also difficult to quickly understand whether a metric was good, bad, improving, or declining without comparing it against historical performance.

Solution

I created a Next.js and Supabase dashboard that allowed users to upload or import order data, generate weekly reports, and view performance by channel.

The system included:

• Role-based access for admins and members
• Channel-level reporting
• Overall business summaries
• Weekly report generation
• Revenue and gross profit calculations
• Advertising spend and TACOS tracking
• Net sales and margin metrics
• Trend sparklines
• Custom grading logic based on historical lookbacks
• Searchable and sortable data tables

The dashboard transformed raw order and advertising data into a business-friendly scorecard.

Impact

The dashboard reduced reporting time and made weekly business performance easier to understand. It helped turn scattered data into a consistent reporting system that could be used for faster decision-making.

The grading system also made it easier to identify outliers, strong performance, and areas that needed attention.

What I Learned

This project helped me connect frontend development, database design, data modeling, and business analytics into one complete product. It also showed me the importance of making data tools not just accurate, but easy to understand and use.