Our Work/E-commerce Sales Dashboard
REPORTING & DASHBOARDS · E-COMMERCE ANALYTICS

E-commerce Sales Dashboard

A sales and performance dashboard that brings revenue, orders, customers, product performance, sales channels and profitability into one clear management view.

United StatesJanuary 2024 – December 2025USD
Revenue$2.123M
Orders21,360
Customers8,240 customers
Gross Margin31.8%

DASHBOARD

Explore the dashboard

Move through the four views to see overall performance, product detail, geographic reporting and revenue concentration. Open the viewer for a larger look.

SALES PERFORMANCE

Executive Dashboard

Management view of sales, customers, channel mix and profitability.

Averidi
DateJanuary 2024 – December 2025
MarketUnited States
CategoryAll categories
ChannelAll channels
Revenue$2.123M24-month total
Orders21,360
Customers8,240 customers
Average Order Value$99.39
Gross Margin31.8%
Website Revenue Share54.9%
Revenue TrendMonthly revenue, January 2024 to December 2025
USD · $000s
$130K$107K$83K$60KJan 24: $68KFeb 24: $72KMar 24: $70KApr 24: $75KMay 24: $73KJun 24: $79KJul 24: $81KAug 24: $77KSep 24: $83KOct 24: $86KNov 24: $91KDec 24: $88KJan 25: $82KFeb 25: $85KMar 25: $89KApr 25: $94KMay 25: $91KJun 25: $98KJul 25: $101KAug 25: $96KSep 25: $104KOct 25: $108KNov 25: $113KDec 25: $119KJan 24Dec 24Dec 25
Revenue by CategoryRanked contribution to total revenue
Electronics$660K
Home$500K
Lifestyle$420K
Accessories$320K
Other$223K
Revenue by ChannelShare of total revenue
Website54.9%$1,165K
Marketplace29.0%$615K
Wholesale16.2%$343K
Gross Margin by CategoryRevenue scale and margin are reviewed separately
Electronics27.4%
Home32.8%
Lifestyle34.6%
Accessories38.1%
Other29.7%
Performance SummaryManagement review
$119KDecember 2025 monthly revenue
54.7%Revenue from Electronics and Home combined
38.1%Accessories gross margin, highest by category

KEY FINDINGS

What the dashboard revealed

01

Revenue strengthened during 2025

Monthly revenue moved from a $68K starting point in January 2024 to $119K in December 2025, with the strongest monthly values concentrated toward the end of the period.

02

Revenue is concentrated in two categories

Electronics and Home generated $1.160M combined, representing approximately 54.7% of total revenue.

03

The largest category is not the highest-margin category

Electronics generated the most revenue but carried a 27.4% gross margin, while Accessories generated less revenue with a 38.1% gross margin.

04

The website is the primary sales channel

Website sales contributed $1.165M, or approximately 54.9% of total revenue, making it the largest channel in the dataset.

PROJECT DETAILS

The work behind the dashboard

Review the business question, data, method, validation and limits behind the dashboard.

Business question

How are sales performing over time, which categories and channels are driving revenue, and where does revenue performance differ from profitability?

A growing online retailer had sales data across orders, products and channels, but management needed a consistent view of performance for recurring reviews. The main challenge was bringing the core measures into one reporting structure without losing the detail needed to explain changes.

Data used

Order-level sales data covering 21,360 orders across 24 months.

  • Customers: 8,240 customers
  • Period: January 2024 – December 2025
  • Fields: Order date, product, category, channel, region, quantity, revenue, discount and cost
Analysis approach
  1. Validated order dates, revenue and cost fields.
  2. Calculated revenue, order volume, average order value and gross margin.
  3. Aggregated performance by month, product category and sales channel.
  4. Compared revenue contribution with gross profitability to identify differences in performance.
  5. Designed a management view around the measures most relevant to recurring sales reviews.

Review Averidi's analytical methodology ↗

Data preparation
  1. Standardized order dates and reviewed product-category and channel labels before aggregation.
  2. Checked revenue, cost, quantity and discount fields for usable numeric values and retained the order-level grain as the analytical source.
  3. Derived gross profit from revenue less cost and gross margin from gross profit divided by revenue.
  4. Created monthly, category and channel summaries from the same prepared order-level dataset so headline totals could be reconciled.
Validation
  • Category revenue reconciles to the $2.123M overall revenue total.
  • Channel revenue independently reconciles to the same $2.123M overall revenue total.
  • Average order value recalculates to $99.39 from $2.123M revenue across 21,360 orders.
  • Category gross-margin comparisons were checked against the prepared revenue and cost measures before interpretation.
What to investigate next
  • Review revenue and margin together: Keep category revenue and gross margin visible in the same management review so growth is not judged on sales value alone.
  • Investigate the Electronics margin gap: Before prioritizing further Electronics growth, break down cost, discount and product mix to understand why its 27.4% gross margin trails several smaller categories.
  • Extend channel analysis before reallocating spend: Website contributes 54.9% of revenue, but channel-level profitability is not shown. Add channel cost and acquisition measures before making budget or channel-mix decisions.
Limitations
  • The project does not include inventory availability, returns, taxes, shipping economics or customer-acquisition cost, so those factors are not used to explain profitability.
  • Channel views show revenue contribution; channel-level margin is not available in this example and should not be inferred from the category margin table.
  • The dashboard describes observed performance and does not establish why a category or channel changed.

PROJECT OUTPUT

What was delivered

01Sales KPI dashboard

A clear management view of the headline sales measures.

02Monthly revenue trend

A time-based view for spotting movement in revenue performance.

03Category and channel performance views

Breakdowns that show where sales are coming from.

04Profitability comparison

A comparison of sales scale and gross-margin performance.

RELATED SERVICE

Dashboards & Reporting

The output provides a recurring management view that can be used to review sales performance, investigate changes and focus discussion on product and channel differences.

YOUR DATA · YOUR BUSINESS QUESTIONS

Need a clearer view of your business performance?

Bring the question and the data you already have. Averidi can help turn it into reporting your team can actually use.