Blog
Retail Analytics Blog: Power BI, Excel and Assortment Planning
Practical notes from fashion retail analytics — measures, models and the definitions that stop two people quoting different numbers.
How to Calculate Sell-Through Rate in Power BI
The DAX pattern, the two denominators retailers confuse, and how to show it by week.
Read the articleHow to Build a Size Curve from Last Season’s Sales Data
Cleaning returns and stock-outs out of the data before you trust the size split.
Product Attribute Standards That Survive Three Markets
A practical attribute dictionary for PLM, with rules for colour, season and composition.
How to Read a Price Ladder Before Setting Next Season’s Prices
Entry and exit points per category, and what a gap in the ladder actually costs.
Five DAX Measures Every Retail KPI Dashboard Needs
Stock cover, full-price share, returns rate, weeks of supply and contribution margin.
Building an Open-to-Buy Model in Excel That Planners Will Maintain
Structure, phasing and the three checks that stop the model drifting mid-season.
Row-Level Security in Power BI for Multi-Market Retail Reporting
One report, many markets: how to give each team its own numbers without copies.
Why Your Sell-Through Chart Disagrees with Finance
Three definition mismatches that explain most reporting arguments in retail.
Free Retail Analytics Templates for Excel and Power BI
Placeholder: two downloads sent by email — an open-to-buy planning model and a checklist for a retail KPI dashboard that a commercial team will actually open.