Public sample project

Sales Data Analysis Example: From Data to Decisions

See a complete sales data analysis example with governed metrics, data-quality checks, findings, a forecast, customer segments, and an action plan.

About this example: Northstar Outfitters is fictional. Every record, metric, finding, and recommendation on this page uses synthetic data created solely to demonstrate the Datumry workflow.

Business question

What is driving profitable growth, and what should the operating team do before the fall sales period?

Govern the source

name
orders_2025_2026.csv
rows
31,842 orders
period
Jan 2025–Jun 2026
freshness
Complete through Jun 30, 2026
grain
One row per completed order

Establish the scorecard

  • Net revenue: $2.48M (+14.7% YoY)
  • Orders: 31,842 (+9.2% YoY)
  • Average order value: $77.89 (+5.1% YoY)
  • Gross margin: 58.4% (-1.8 pts YoY)

Check data quality

  • Required-field completeness: 98.7% — Pass
  • Duplicate order IDs: 0 — Pass
  • Unmapped product categories: 412 rows — Review
  • Negative net revenue: 37 refunds — Expected

Explain the movement

Growth driver · High confidence

Returning customers produced 63% of the revenue increase

Returning-customer revenue increased $191K year over year, compared with $112K from first-time customers. Their order frequency rose from 2.1 to 2.4 orders per customer.

Margin pressure · Moderate confidence

Discount depth—not product cost—explains most of the margin decline

Gross margin fell 1.8 points while unit cost remained broadly stable. Orders discounted above 20% grew from 11% to 19% of volume and contributed 72% of the margin-rate decline.

Product concentration · High confidence

Trail essentials account for nearly half of incremental revenue

Three products generated $143K of the $303K year-over-year revenue increase. Two experienced stockouts during last year’s fall peak, creating an avoidable availability risk.

Plan with a range, not a promise

Next 12 weeks forecast: $668K; expected range $610K–$729K.

Seasonal trend model compared with naive and moving-average baselines. Validation: 9.8% holdout MAPE.

Limitation: The interval assumes historical seasonality continues. It does not account for unplanned stockouts, major price changes, or a new campaign outside the observed history.

Describe customer segments in business terms

  • Loyal repeat buyers: 18% of customers; 43% of revenue. High frequency, recent purchase, limited discount reliance
  • Growing customers: 26% of customers; 29% of revenue. Second or third purchase with rising order value
  • Occasional shoppers: 43% of customers; 23% of revenue. One or two purchases and longer gaps
  • At-risk repeat buyers: 13% of customers; 5% of revenue. Previously active but outside normal purchase cadence

Turn evidence into owned next actions

Protect fall availability

Increase safety stock for the three trail-essential products before the seasonal ramp.

Owner: Operations · Review: Aug 28

Reduce margin leakage

Test a 15% discount ceiling for repeat buyers against the current broad 20–25% offers.

Owner: Growth · Review: Sep 18

Re-engage at-risk buyers

Run a controlled retention offer for the at-risk repeat segment and measure incremental return.

Owner: Lifecycle · Review: Sep 30

Analyze your own data · Read the Excel sales analysis guide · Explore more examples