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.
| # | History |
|---|---|
| Jan | 61.2K |
| Feb | 58.4K |
| Mar | 66.9K |
| Apr | 70.3K |
| May | 74.1K |
| Jun | 81.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.
Explore with the pointer or keyboard. Tap a value to keep its detail visible.
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.
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
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.
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.
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
Action plan
Prioritized opportunities and follow-up goals.
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).