Two-Week Retail Data Diagnostic
Suits: brands that suspect the range, prices or reporting are wrong but cannot prove it from their own reports.
You get: a findings memo, quantified gaps and a prioritised plan.
2 weeksBook a diagnostic
Warsaw, Poland · EN / PL / RU
Tatsiana Bandziuk,
Retail and Fashion Analytics Consultant
I help fashion and retail brands plan the assortment, set prices that hold across markets, clean up product data and build Power BI reporting the team actually uses.
10+years in fashion retail analytics
30+dashboards and models delivered
3working languages EN / PL / RU
Retail and Brand Analytics Experience at Luxvisage, Fashion House, OMA and an International Fashion Brand
LuxvisageFashion HouseOMAInternational fashion brand
Retail Analytics Consulting Services for Fashion and Retail Brands
01
Assortment Planning and Merchandise Planning
Range architecture, size and colour curves, open-to-buy and in-season monitoring, so the buy follows real demand rather than last season’s habit.
size curve · XS–3XL
02Retail Pricing Analysis and Price Architecture
Price architecture by category, good-better-best tiers, cross-market price alignment and markdown scenarios tested before the season.
price ladder · entry → top tier
03Power BI Consultant for Retail KPI Dashboards
One Power BI model for sell-through, stock cover, margin and returns that the commercial team actually opens.
dashboard layout · schematic
04Excel Merchandise Financial Planning Models
Open-to-buy, buy plan and margin models in Excel, built for your planners to maintain rather than a consultant.
open-to-buy · units, illustrative
05Product Data Quality and PLM Standardisation
One attribute dictionary across markets: consistent seasons, colours, compositions and categories in the PLM system.
attribute completeness · illustrative
06Retail Reporting Process and Analytics Team Setup
A reporting calendar, KPI owners, agreed definitions and weekly reviews, so numbers are agreed once and reused everywhere.
reporting calendar · weekly / monthly / quarterly
About Tatsiana Bandziuk, Retail and Fashion Analytics Consultant
I have spent about ten years in international fashion retail, working between the commercial teams and the systems behind them: assortment, pricing, product data and the reporting that has to agree with all three.
Today I am Global Brand Analyst and Product Data Lead at an international fashion brand, where I also lead a team of product specialists. From Warsaw I take on consulting projects in English, Polish and Russian.
Career timeline
- 2014 — 2017OMACommercial analyst
- 2017 — 2018Fashion HouseRetail analyst
- 2018 — 2022LuxvisageCategory & pricing analyst
- 2022 — todayInternational fashion brandGlobal Brand Analyst & Product Data Lead
Master of Economics and Management, BSEUAbout Tatsiana Bandziuk
Retail Analytics Consulting Results in Numbers
+18pp
sell-through on core categories after the range rebuild
−31%
markdown spend across two seasons
40h
monthly reporting time removed by one Power BI model
98%
product attribute completeness in PLM after standardisation
Retail Analytics Consulting Formats: Diagnostic, Project, Ongoing Support
Retail Analytics Project: Assortment, Pricing, Data or Reporting
Suits: teams with one clear problem to fix: the range plan, the price architecture, the PLM data or the KPI reporting.
You get: working models or dashboards, documentation and a team handover.
4–10 weeksDiscuss a project
Ongoing Retail Analytics Support
Suits: growing brands without an in-house analyst that still need a reliable monthly reporting rhythm.
You get: maintained reports, a monthly review and documented decisions.
monthly retainerAsk about support
Who I work withFashion brands· Distributors· E-commerce retailers· Growing brands without an analytics team
How a Retail Analytics Consulting Project Works
Retail Data Diagnostic: Sales, Stock and Product Data
Two weeks with your sales, stock and product data. You get a short memo that names where margin and time are being lost.
Retail Analytics Plan with Priorities and Owners
A written plan: what changes in the range, pricing, data and reporting, in which order, and who owns each change.
Building the Excel Models, PLM Rules and Power BI Reports
Models, attribute rules and dashboards built on your live data, checked against the numbers your team already trusts.
Handover of the Analytics Process to Your Team
Definitions, documentation and training sessions, so the process keeps running after the project ends.
Most projects start with one honest look at the data.
Retail Analytics Tools: Power BI, Excel and PLM Systems
Power BI for Retail Reporting
One data model per brand for sell-through, stock cover and margin, refreshed without manual work.
DAXPower Queryrow-level security
Advanced Excel for Merchandise Planning
Buy plans, open-to-buy and margin scenarios your planners can open, read and keep using.
open-to-buyscenariospivot models
PLM Systems for Product Data
Attribute dictionaries, season and colour structures, and rules that keep product data clean at entry.
attribute dictionarydata governance
Education in Logistics, Economics and Management
Master of Economics and Management, Logistics — BSEU, 2015Logistician-economist, Logistics — BSEU, 2014EU Tempus Be-Safe certificate — Sapienza CTL and BSEU, 2014–2015Knowledge Transfer certificate — Loughborough UniversityBNTU Young Researchers Seminar 2016 — best paper, 2nd place
Retail and Fashion Analytics Case Studies
All case studiesschematic dashboard · illustrative data
Product data · PLM
Standardising Product Data Across European and Asian Markets in a PLM System
A fashion brand selling in Europe and Asia replaced local naming habits with one PLM attribute dictionary and validation at entry.
98% completeness−60% data fixes
schematic dashboard · illustrative data
Assortment · Range
Rebuilding the Womenswear Range Plan for a European Fashion Distributor
Fewer options, more depth in proven sizes and colours, and a new open-to-buy plan for a womenswear distributor.
+18 pp sell-through−31% markdown
schematic dashboard · illustrative data
Pricing · Reporting
Building a Price Architecture and Margin Report for a Fashion E-commerce Retailer
Clear entry, core and top price points per category, one set of pricing rules for all markets and a weekly margin report.
+2.4 pp margin6 weeks
Free Open-to-Buy Excel Template and Retail KPI Dashboard Checklist
Two free downloads sent by email: an open-to-buy planning model in Excel and a checklist for a Power BI retail KPI dashboard that a commercial team will actually open.
Retail Analytics Consultant FAQ
Short answers to the questions brands ask before the first call.
A retail analytics consultant turns a brand’s sales, stock, price and product data into decisions about what to buy, how to price it and how to report on it. In practice that means assortment and pricing analysis, agreed KPI definitions and models or dashboards the team can maintain. My focus is fashion retail: range plans, size curves, price architecture, PLM product data and Power BI.
Retail analytics is the analysis of sales, stock, pricing, customer and product data to improve buying, pricing, allocation and store or online performance. It covers KPIs such as sell-through, stock cover, margin and returns, and the models used to plan the next season. Good retail analytics ends in a decision, not in a report.
For a fashion brand, the five KPIs I would track weekly are sell-through rate, gross margin, stock cover (weeks of supply), full-price sales share and returns rate. GMROI and stock turn complete the picture at season level. The exact list matters less than having one written definition for each KPI that every team uses.
A data diagnostic takes two weeks. A focused project, such as a range plan, a pricing review or a Power BI reporting model, usually takes four to ten weeks depending on the number of categories and markets. Ongoing support runs month by month.
Sales, stock, receipts and returns at SKU and week level, plus product attributes and prices, ideally for two seasons. Standard exports from your ERP, PLM or e-commerce platform are enough to start. An NDA can be signed before any data is shared.
Yes. I am based in Warsaw and work remotely with brands across Europe and beyond, in English, Polish or Russian. On-site workshops are possible when a project needs them.
Retail Analytics Articles on Power BI, Pricing and Assortment
All articlesPower BI
Weeks of Cover in Power BI: DAX Measure and Formula
The weeks of cover formula, why the averaging window changes the answer, a DAX measure that counts only in-stock weeks, and how cover converts to stock turn.
Power BI
Weekly Trading Report in Power BI: What to Include
The four pages of a weekly trading report in Power BI, the measures each one needs, the retail calendar underneath it, and the mistakes that make it useless.
Power BI
4-5-4 Retail Calendar in Power BI: How to Build It
The columns a 4-5-4 retail calendar needs, DAX that builds the table, why Power BI time intelligence breaks on it, and what the 53rd week does.
Contact Tatsiana Bandziuk about a Retail Analytics Project
I read every enquiry myself. Tell me what is not working — the range, the prices, the product data or the reporting — and I will reply within one working day with the first questions I would ask. If the project is not a good fit for me, I will say so.
business@tatsianabandziuk.comWarsaw · CET