Syntha Lab RU

Analyst: what to learn and where to start

An analyst turns sales and stock data into decisions: computes measures, looks for the causes of deviations and tests forecasts. Start with master data, single definitions of measures and forecast accuracy.

Brand and retail

Open interactively →

What to understand

Metric dictionary
Every metric has one definition: numerator and denominator, with or without VAT, units or money, which date.
Gross and net sales
Gross is sales before returns and discounts, net after.
Baseline and effect
The effect of a promotion or change is measured against a control group or baseline, not against last week.
Forecast accuracy
Forecast error (WAPE) and bias show whether the plan can be trusted.
Reference books and data quality
Unified reference books for sizes, attributes and categories make reports comparable.
Tolerances and traffic lights
A deviation matters if it exceeds a tolerance set in advance.
Scraping and external data
Competitor prices and market estimates must be brought to one base and date.
CRM metrics and coverage
Active, repeat, new and returned customers, cohort retention and CRM coverage: how many sales you see and can reach.
Store: pace, receipts, the sales equation
A single scheme to explain sales change over four factors, period pace and receipt bands.
Season results and the report dictionary
The season ladder, sell-through by delivery, style classes, year on year.
Sensitivity and scenarios
Tornado and plan scenarios show which assumptions cost most.
Master data: style, color-style, SKU, barcode
Each field lives at its level: style, color-style, SKU, pack.
Data quality: completeness, uniqueness, validity, timeliness
Four checks give an overall quality score, and the data owner is accountable for fixing.
Common measures and report readiness
The measures dictionary fixes the definition, source, owner and frequency.
Data exchange templates
The product, stock, sales, order, supplier and customer templates set columns, types and validation rules.

The first 30 days

  1. Read the rep-* terms and compare with your reports. Season results report
  2. Compute CRM coverage. CRM coverage: how many sales and customers you can see and reach
  3. Build cohort retention. Cohort retention: curve, churn and cohort LTV
  4. Decompose store sales by the equation. Sales equation: traffic, conversion, units per receipt, price per unit
  5. Build the season ladder. Season result: from gross sales to contribution
  6. Build the plan sensitivity tornado. Plan sensitivity and breaking point
  7. Describe the master data grain and levels. Master data: SKU, SKU, barcode
  8. Score the reference books and name owners. Data quality and data owners
  9. Build the common measures dictionary. KPI dictionary and common definitions
  10. Check data readiness for standard reports. Data readiness for standard reports
  11. Walk the path from product card to ready reports. From the product card to ready reports

Which measures to track

MeasureFormula
Forecast error (WAPE)Sum of absolute errors ÷ sum of actual sales
Forecast biasSum (forecast − actual) ÷ sum of actuals
Promotion upliftPromotion actual − baseline
Effect versus control(Test after − before) − (control after − before)
Share of correct product cardsCards without category or attribute errors ÷ checked
Indicator traffic lightDeviation from plan versus tolerance
CRM coverageSales with an identified customer ÷ all sales
Cohort retention at a periodReturned cohort customers ÷ cohort customers
Contribution by season ladder stepStep amount ÷ gross sales
Plan sensitivityChange in result when an assumption moves by a set step
Data quality scoreAverage of completeness, uniqueness, validity and timeliness of the needed fields
Report readinessReports with all needed fields ÷ all standard reports
Data exchange lagTime from an event in the source to its appearance in the report
Forecast accuracy with valueForecast error versus a naive forecast (what the method added)

Calculations in order

  1. Sales forecast: method, horizon, error
    Builds a forecast from sales history using four methods, shows each method’s error on past data and suggests which is more reliable for your series.
  2. S&OP: forecast bias, error and the balance of demand and supply
    For the monthly sales and operations planning cycle: reconciles the forecast with actual (bias, WAPE, tracking signal) and the supply plan with the demand plan. Shows whether the team overstates the forecast, where the error is large and when supply does not cover demand.
  3. Promotion result: incremental profit
    Compares the profit of a promotion with the profit you would have had without it and subtracts cannibalization, pull-forward demand and costs. Shows the required and actual sales growth, the baseline cushion and the sensitivity to its estimate.
  4. Control group: promotion effect (difference-in-differences)
    Compares stores or regions in a promotion with similar ones without it, before and after. Shows the effect of the promotion in pieces and percent, a rough interval from the pre-promotion spread, a “parallel trends” check before the promotion and the result in money.
  5. Channel incrementality: test against control
    Compares the revenue of a group with ads on against a similar group without them. Shows incremental revenue, incremental return and profit after spend, and compares with the ad platform’s last-click report.
  6. How to read market figures: bringing estimates to one basis
    Different sources give different market sizes because they count differently: with or without VAT, by orders or by what was bought, not the whole market. The calculation brings your estimates to one basis (excl. VAT, bought-out, the whole market) and shows how much of the spread the method explains.
  7. Product classifier check
    Shows how fully the required attributes of a product table (group, category, season, size, color, fibre content) are filled, how many duplicates there are and which attributes fall below your target. Without a single classification, analytics does not add up.
  8. Owner dashboard: 10 indicators and a traffic light
    Compares key business indicators with plan, colors the deviation as a traffic light with your tolerance and points to where to work out the cause. The set of indicators is a platform suggestion, replace it with your own.
  9. WACC: cost of capital, ROIC against WACC and economic profit
    Calculates the weighted average cost of capital from the shares, the cost of equity and debt after tax, then compares it with ROIC and finds economic profit (EVA); the table shows how WACC and EVA change at another debt share.
  10. Consolidation of two entities: eliminating turnover and unrealized profit
    Adds up the P&L and balance sheets of two group entities and eliminates intra-group turnover, mutual balances and unrealized profit in the buyer’s stock; shows consolidated revenue, EBITDA, profit, assets and equity and checks that the consolidated balance sheet ties.
  11. Management balance sheet from the P&L and turnover figures
    From the P&L, the inventory, receivable and payable days and the opening balance sheet builds the closing balance sheet: cash by the indirect method, assets, liabilities, equity; checks that it ties, shows net working capital and net debt and compares the calculated cash with the actual.
  12. Forecast value added by stage and the price of error in roubles: the season assortment
    For groups of the assortment compares three forecasts of one season: naive (a repeat of the last season), a model (statistics or AI) and the result after manual adjustments. Counts the WAPE and bias of each stage, the value added of each step (FVA) and turns the error into roubles: over-forecast costs a markdown and holding, under-forecast costs lost margin. The definitions of WAPE, bias and FVA are given in the “Forecast accuracy by week” calculation (fcdash); here the point is the price of error and the stages.

Documents to start with

Data templates

  • Product master data

    One row per SKU: style, color, size and code. The base for stock, sales and marking.

  • Sales by SKU and day

    Sales and returns by SKU, store or channel and date; price and discount separate.

Questions you will be asked

  • Can we trust our forecast and which way does it err?
  • What was the real effect of the promotion?
  • Does a channel work or would customers come anyway?
  • How to bring market figures to one base?
  • Are categories and attributes in cards correct?
  • Which 10 indicators belong on the owner dashboard?
  • What does a control week show?
  • How many sales do we see in CRM and is it enough for conclusions?
  • Which cohorts retain better and why?
  • What made up the store sales change?
  • Which plan assumption is the most dangerous?
  • At which level does a field live and what does one row mean?
  • Is there enough data for the standard reports?
  • Who is the data owner and who is accountable for fixes?

Where next

Full description of the role

Study routes

Topics

Open interactively →