Short answer: a wine sales dashboard works when it puts DTC against distribution, breaks revenue down by varietal, region and vintage, and tracks club retention — so you see where the margin really comes from. Agree the channel definitions before you build, or the comparison is meaningless.
Define channels and margin first
The measure-first question is “which channel and which wine actually make money?” DTC and distribution behave nothing alike — cellar door, club and e-commerce carry far higher margin than a distributor sale, but lower volume. So the first job is a clean channel field and a margin calculation per channel, agreed with whoever owns the numbers. Varietal, region and vintage are your dimensions; revenue, units, margin and club retention are your measures.
Sales data usually arrives from more than one system — an e-commerce platform, a club tool, a distributor report — so Tableau Prep is essential to unify them into one source with consistent channel, varietal and vintage fields. Connect as a refreshed extract; sales rarely need a live feed.
Build the channel and market views
Lead with a DTC-versus-distribution comparison: revenue and margin side by side, so the high-margin DTC story is visible against the high-volume distribution story. A FIXED level-of-detail calculation — {FIXED [Varietal], [Vintage] : SUM([Revenue])} — lets you build varietal-by-vintage breakdowns that hold steady regardless of other filters.
Add a market map using geographic roles so distribution and e-commerce sales appear by region, sized by revenue and coloured by margin — useful for spotting where a varietal sells. Track club retention as a cohort or simple retention curve by join month. Filter actions tie it together: click a varietal and every view reflows to that wine, with row-level security so a regional manager sees only their territory.
Let Pulse watch the numbers that move
Set Tableau Pulse on club retention and DTC revenue, and it sends a natural-language digest when something shifts — “Club retention down two points this quarter” — before it shows up in a monthly report. Einstein Copilot can help a non-analyst ask “which varietal grew fastest in DTC last quarter” in plain language and get a chart back.
Where it breaks
The honest limits are about data and sample size. Channel data lives in silos, and a distributor depletion report may lag weeks behind your DTC sales, so the comparison is never perfectly contemporaneous — be clear in the title which channels are current. Small wineries also hit small-sample problems: a club cohort of forty members produces a retention curve that swings wildly on a handful of cancellations, so do not over-read it. And the built-in forecast does not know a vintage is nearly sold out; it will project sales of wine that no longer exists.
The bottom line
A Tableau wine sales dashboard ties channels together: DTC against distribution, revenue by varietal, region and vintage, club retention and a market map, with Pulse flagging the metrics that move. Define channels and margin first, mind the silos and small samples, and treat the built-in forecast as a hint rather than a plan.
Part of the Winemaking & AI track. Related: a cellar and barrel-ageing inventory dashboard in Tableau.
Frequently asked questions
What should a wine sales dashboard in Tableau cover? Direct-to-consumer channels — cellar door, club and e-commerce — against distribution, plus sales broken down by varietal, region and vintage, and club retention over time. A market map adds the geographic view.
How do I compare DTC and distribution margins in Tableau? Bring both channels into one source with a consistent channel field, then build a calculated field for margin per channel. A side-by-side bar makes the margin gap between DTC and distribution obvious.
Can Tableau forecast wine sales by vintage? The built-in exponential-smoothing forecast gives a rough trend, but vintage volumes are finite and seasonal, so treat it as indicative. For real planning, model demand externally and visualise the result.