Skip to main content
These examples use fictitious data, names and figures. Their content and format are illustrative; available results depend on the product you choose and the data you provide.

Valerian Sales analyzes sales history and forecasts monetary revenue using the data supported by its template. This example explores a broader commercial interpretation; check the product scope for its available results.

Demo reportSample report

Sales diagnosis and commercial opportunities · Tienda Nórdica

Example business: Tienda Nórdica — home and decor retail, with two physical branches and an online store.

The ten sections organize this illustrative example. Each product report has its own scope and format.

Analysis overview

Business, period and available dimensions.

Business
Tienda Nórdica (fictitious data)
Period
January – June 2025, compared with July – December 2024
Available dimensions
Date, amount, product, category, channel and branch.
Currency
USD

Executive summary

Overall behavior and highlighted findings.

Half-year sales were USD 412,800, an 8.3% increase over the previous half. Growth is uneven: the online channel grew 29% and contributes more than two thirds of the increase, the Centro branch grew moderately and the Norte branch fell 3.1%.

  • June was the best month of the half (USD 81,900), driven by the anniversary campaign.
  • Decor and Lighting grow above average; Textiles is flat.
  • The average ticket rose 2.1%, so growth comes mostly from more orders.

Historical quality and coverage

Incomplete periods and missing data.

The history covers 18 continuous months with no date gaps. The channel is identified in 100% of records; the branch is missing in 2.4% of older tickets, grouped as “unassigned” without affecting comparisons.

  • 24,660 tickets in the analyzed period; 9,870 in the current half.
  • Net returns already deducted from the amounts.
  • No traffic or visit data: conversion cannot be calculated.

Key indicators

Sales, units, orders and average ticket when calculable.

Half-year sales

USD 412,800

+8.3%

Orders

9,870

+6.1%

Units sold

15,340

+5.5%

Average ticket

USD 41.80

+2.1%

Evolution over time

Growth, declines and comparisons between equivalent periods.

The monthly series shows sustained growth since March. Month-over-equivalent-month, May and June grow above 12%.

Sales by month

Monthly net sales from January to June 2025.

84.7K77.4K70.2K62.9K55.6KJanFebMarAprMayJun
Monthly net sales from January to June 2025.
#History
Jan61.2K
Feb58.4K
Mar66.9K
Apr70.3K
May74.1K
Jun81.9K

Explore with the pointer or keyboard. Tap a value to keep its detail visible.

Disaggregated performance

Products, categories, branches, channels or salespeople.

By category, Decor concentrates 31% of sales. By outlet, the contrast is between the online channel (+29%) and the Norte branch (−3.1%).

Sales by category

Half-year net sales by product category.

  • DecorUSD 128,400
  • TextilesUSD 96,200
  • KitchenUSD 88,700
  • LightingUSD 58,300
  • OtherUSD 41,200

Explore with the pointer or keyboard. Tap a value to keep its detail visible.

Performance by outlet
OutletSalesChange vs. previous halfAverage ticket
Online storeUSD 108,90029.0%USD 46.20
Centro branchUSD 182,3006.4%USD 40.90
Norte branchUSD 121,600-3.1%USD 38.70

Contribution to changes

Which segments explain the increase or decrease in sales.

The total half-year increase was USD 31,600. The decomposition shows how much of the change each outlet explains: the online channel contributes 78% of the growth and the Norte branch subtracts from it.

Contribution to the sales change
OutletSales changeShare of the change
Online storeUSD 24,50078.0%
Centro branchUSD 11,00035.0%
Norte branch-USD 3,900-13.0%

AI analysis

Commercial reading of the patterns and hypotheses worth investigating.

Key findings

Growth depends on a single channel

The online channel explains 78% of the half-year growth. Without it, the business would have grown 1.9% instead of 8.3%.

Evidence: Contribution to the change table (element 7).

The Norte branch declines while the rest of the business grows

Norte fell 3.1% with an average ticket 5.4% below Centro. The decline is gradual and sustained across all six months, not a one-off event.

Evidence: Performance by outlet (element 6) and the monthly series in the annex.

Textiles does not follow the growth

At USD 96,200, Textiles grew 0.4% against an 8.3% average. It is the second-largest category, so its stagnation weighs on the total.

Evidence: Sales by category (element 6).

Business interpretation

Online sales proved there is demand; the commercial question is whether Norte has an assortment, execution or location problem. Since the ticket barely grew, short-term levers are purchase frequency and new orders, not price increases. This diagnosis supports channel investment decisions and a commercial review of Norte and Textiles.

Hypotheses and limitations

  • Part of the online growth may be migration of Norte customers; validate by crossing shipping postal codes with the branch’s area.
  • The Textiles stagnation coincides with fewer active catalog references (−12%); the assortment history is needed to confirm it.

Prioritized recommendations

Priority: High

Commercial review of the Norte branch

Compare assortment, prices and opening hours against Centro, and measure whether the decline concentrates in specific categories before deciding on investments or closures.

Priority: Medium

Double acquisition investment in the online channel

The channel grows 29% on the current budget. Increase spend gradually while measuring cost per order to find the channel’s ceiling.

Priority: Medium

Textiles assortment refresh test

Introduce 15–20 new references in one branch and compare category sales against the other branch as a control for 8 weeks.

Proposed follow-up

Proposed follow-up
IndicatorReference valueReview period
Norte branch sales change−3.1% → stop the decline (a goal, not a projection)Monthly review
Online channel share26.4% of total salesQuarterly review

Action plan

Prioritized opportunities and follow-up goals.

Action plan
ActionSuggested ownerFollow-up metricPriority
Commercial audit of the Norte branch (assortment, prices, execution)Commercial managementNorte monthly sales changeHigh
Staged online acquisition investment planMarketingCost per order and new orders per monthMedium
Controlled Textiles assortment testPurchasingWeekly category sales, test vs. controlMedium

Methodology and annexes

Indicator definitions and result tables.

Comparisons use equivalent periods (half against half). Contribution to the change is calculated as each outlet’s sales difference between periods, expressed over the total change.

  • Annex A: monthly series by branch and channel.
  • Annex B: sales and change by category and subcategory.
  • Annex C: indicator definitions (ticket, order, unit).

Other sample reports

Apply the question to your data

Valerian Sales analyzes sales history and forecasts monetary revenue using the data supported by its template. This example explores a broader commercial interpretation; check the product scope for its available results.

Back to the examples
Sales diagnosis and commercial opportunities · Sample report · Valerian Data