Maison Vasseur · Wholesale Analyst Project

Wholesale Business Review Dashboard

A dashboard covering the core of the role: Sell-In, Sell-Out, Sell-Through %, and Returns — sliceable by month, season, division, region, channel, account, and product.

Topline view of the Vasseur Dashboard: Sell-In, Sell-Out, Sell-Through %, and Returns by Total, Wholesale/Franchise, Division, and Product, with Month and Season slicers live — Topline

Channel view of the Vasseur Dashboard: Sell-In, Sell-Out, Sell-Through %, and Returns by Region and named Account, with Region, Product, Channel, and Account slicers live — Channel

.xlsx

Vasseur Dashboard.xlsx

Download and explore the live slicers yourself.

344 KB Download ↓

Static Excel workbook with live slicers — full interactivity requires opening it in Excel.

What this dashboard is built for

Analyze wholesale and franchise customer performance, sell-through, and purchasing trends.
Prepare and maintain regular reporting tools and dashboards for Wholesale, Merchandising, and senior management teams.
Gather and consolidate customer data to produce weekly and monthly business reviews.
Support preparation for commercial meetings with Women's, Men's, and Leather Goods teams by providing insights and performance analysis.
Monitor key business KPIs and proactively highlight areas requiring attention or action.

Data structure

Four flat, relational tables — no formulas baked into the file itself. The real data work — merges, transformations, and the native PivotTables behind the Business Review above — happens in Power Query on top of this source, not inside these sheets. Click a table to see a sample of the actual rows.

Accounts12 rows

Account ID · Account Name · Region · Country · Account Type

Two wholesale/franchise accounts per region across UK & Ireland, Nordics & Baltics, DACH, France & Benelux, Iberia, and Southern Europe.

Account ID	Account Name	Region	Country	Account Type
ACC-01	Hartwell & Vane	UK and Ireland	United Kingdom	Wholesale
ACC-02	Belgrave Maison	UK and Ireland	United Kingdom	Franchise
ACC-05	Alpenrose Schuhhaus	DACH	Germany	Wholesale
ACC-07	Le Comptoir de la Mode	France and Benelux	France	Wholesale
ACC-09	Casa Serrano	Iberia	Spain	Wholesale
ACC-11	Casa Lombardi	Southern Europe	Italy	Wholesale

Products16 rows

Product ID · Product Name · Category · Season · Wholesale Price (CHF) · Retail Price (CHF)

Women's Footwear, Men's Footwear, and Leather Goods, weighted so footwear carries the large majority of both SKU count and revenue.

Product ID	Product Name	Category	Season	Wholesale (CHF)	Retail (CHF)
PRD-01	Etoile Pump 100	Women's Footwear	SS24	620	1,550
PRD-02	Vasseur Oxford	Men's Footwear	FW24	590	1,450
PRD-05	Voltige Sandal	Women's Footwear	SS25	560	1,400
PRD-09	Aurore Ankle Boot	Women's Footwear	FW24	710	1,780
PRD-12	Cambon Card Holder	Leather Goods	SS24	190	450
PRD-13	Voltige Belt	Leather Goods	FW24	340	800

Transactions_Monthly2,478 rows

Account ID · Product ID · Month (YYYY-MM) · Sell-In Units · Sell-In Value (CHF) · Sell-Out Units · Sell-Out Value (CHF) · Stock Units · Returns Units

One row per active account-product-month. Stock rolls forward consistently: prior stock + sell-in − sell-out − returns.

Account ID	Product ID	Month	Sell-In Units	Sell-In Value	Sell-Out Units	Sell-Out Value	Stock Units	Returns
ACC-01	PRD-01	2024-01	0	0	0	0	0	0
ACC-01	PRD-01	2024-02	1,469	910,780	435	674,250	1,020	14
ACC-01	PRD-01	2024-03	0	0	339	525,450	673	8
ACC-01	PRD-01	2024-04	1,444	895,280	921	1,427,550	1,167	29
ACC-01	PRD-01	2024-05	0	0	471	730,050	679	17
ACC-01	PRD-01	2024-06	0	0	364	564,200	306	9

Transactions_Weekly11,627 rows

Account ID · Product ID · Week (ISO YYYY-Www) · Sell-Out Units · Sell-Out Value (CHF)

Weekly sell-out only, reconciling exactly to the monthly totals — the grain a weekly business review actually runs on.

Account ID	Product ID	Week	Sell-Out Units	Sell-Out Value
ACC-01	PRD-01	2024-W05	133	206,150
ACC-01	PRD-01	2024-W06	89	137,950
ACC-01	PRD-01	2024-W07	62	96,100
ACC-01	PRD-01	2024-W08	76	117,800
ACC-01	PRD-01	2024-W10	49	75,950
ACC-01	PRD-01	2024-W11	84	130,200

Source files

The two files behind this case study. Download them directly.

.xlsx

Vasseur_Wholesale_Database_2024_2025.xlsx

The four-sheet source database: Accounts, Products, Transactions_Monthly, Transactions_Weekly.

388 KB Download ↓

.xlsx

Vasseur Dashboard.xlsx

The Wholesale Business Review: a formatted ONEPAGE summary plus the native pivot tables behind it.

344 KB Download ↓

This is the raw source layer. The sell-through, purchasing-trend, and customer-performance analysis built on top of it is live in the Wholesale Business Review Dashboard section above.

MaisonVasseur

Maison
Vasseur