labs@atheron:~/industries/wineries/data$ query --warehouse --dashboards

Craft sales data

Depletions, taproom and online sales in one view.

Distributor reports arrive as spreadsheets in a dozen shapes, and the taproom and the online shop report their own way. We bring them into one model, so you can see which accounts and products are moving while there is still time to act.

Start a project See the example projects

// what matters here

What is different in this industry.

Whatever shape the reports arrive in

Each distributor's file is read and mapped once, so the next month's report goes straight in.

Every channel side by side

Taproom, online, club and wholesale sales compared on the same terms, by product and package.

Accounts worth a call

Accounts sorted by growth, decline and last order, so your sales team knows where to go next.

Yours to keep

The data sits in a database you own, and the dashboard reads from it, so nothing is locked inside a tool.

// example projects

Priced examples for this service.

Each one is hypothetical, labelled as such, and priced live from our rate card. Open any of them in the estimator and make it yours.

Example projectWeb app

Depletion and sales dashboard

Hypothetical. Not a client, not a result.

// The problem

A craft brewery gets distributor depletion reports as spreadsheets in different shapes, and nobody can say which accounts are growing until the quarter is over.

// What we would build

A dashboard that reads distributor reports, the point of sale and the online shop into one model, so sales by account, region and product are current and comparable.

// What is in it

Distributor reports read in, whatever shape they arrive in
Taproom, online and wholesale sales side by side
Accounts by growth, decline and last order
Products and packages by region
Exports for your sales team and your accountant

// Stack

Next.js
PostgreSQL
dbt
Point of sale and shop interfaces
DigitalOcean

// estimate

Build: ≈ US$32,400 to US$49,500, delivered within 13 weeksCAD 46,100 to 70,500
Hosting: ≈ US$176 a monthCAD 250 a month
Support: ≈ US$1,000 a monthCAD 1,425 a month

Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.

Timeline by milestone

Discovery: 2.9 to 3.4 weeks
Design approved: 2.4 to 3.4 weeks
Core features: 1.4 to 2.4 weeks
Full build: 0.9 to 1.4 weeks
Testing and fixes: 0.9 to 1.4 weeks
Launch: 0.9 to 1.4 weeks

Outside our hands, and added to the calendar

Interface access from your shop or point of sale vendor: 1 to 4 weeks

How it is paid

Deposit 30%: CAD 13,830 to 21,150
Discovery 6.6%: CAD 3,042.60 to 4,653.00
Design approved 6.6%: CAD 3,042.60 to 4,653.00
Core features 20%: CAD 9,220 to 14,100
Full build 13.3%: CAD 6,131.30 to 9,376.50
Testing and fixes 6.6%: CAD 3,042.60 to 4,653.00
Launch 6.9%: CAD 3,180.90 to 4,864.50
Holdback, 30 days after launch (10%): CAD 4,610 to 7,050

Start from this example

// questions

Questions we get about this.

Can the depletion dashboard read reports from several distributors?

Yes. Each distributor's format is mapped once, and new files are read as they arrive by email or upload.

Will a craft producer need a data team to run it?

No. The reports refresh on their own, and we document how each figure is worked out so your team can trust it.

Can the sales dashboard include our club figures?

Yes, when the club runs in a system with an interface, such as your shop or a club app we build.

Back to the industry: Wineries, breweries and distilleries About the service: Data and analytics

// next

Not quite your project?

Tell us what you have in mind. We will come back to you with a range and the questions that would narrow it. Or book a call and talk it through.

Start a project Book a call