Build $20K dashboards with Claude Code, then sell them for $2,000

The Excel file from the video, so you can practice on a real workbook instead of made-up numbers.

Marty VaughnAI Agents on YouTube

Just watched the dashboard build? This is the Excel file from it. It is the performance workbook for a company that does not exist, with enough real detail behind it that a dashboard built on top has something to be right or wrong about.

Still from the video: building a KPI dashboard with Claude Code

Why you want a file like this

Nearly every company keeps some version of this. A spreadsheet somebody updates by hand every week so the owner can see how the month is going. It works, it is slow, and a lot of businesses are paying thousands a year for software that does the same job. Claude Code can turn one of these into a live dashboard, and this is a workbook to try it on before you try it on somebody's real numbers.

That matters more than it sounds. The hard part of this build is not making the page look good, it is checking that the numbers coming out the other end are the numbers that went in. You cannot check that against data you invented.

Metric               This Year  Last Year  Change
Orders                     417        346  +20.5%
Gross Sales            376,295    313,020  +20.2%
Discounts              -30,294    -23,298  -30.0%
Returns                -32,592    -25,788  -26.4%
Shipping                 3,505      2,878  +21.8%
Net Sales              316,915    266,812  +18.8%
Total COGS             -97,902    -82,394  -18.8%
Ad Spend               -70,949    -58,314  -21.7%
Contribution Margin    148,064    126,103  +17.4%
AOV                     838.15     845.66   -0.9%
ROAS                      4.93       5.02   -1.8%
Online Sessions         13,087     10,134  +29.1%
Completed Checkouts        466        393  +18.6%
Conversion Rate          3.56%      3.88%   -8.2%
New Customers              213        187  +13.9%
Returning Customers        204        159  +28.3%

The summary tab, last seven days. Month to date sits beside it in the file, on the same seventeen metrics.

What is in the file

A year and a half of daily data. Sixteen months rather than twelve, which is the part that matters: it is what lets every number carry a real comparison to the same week last year instead of an empty column.
The detail underneath, not just the totals. Around 39,000 rows of individual order lines, plus daily traffic, checkouts, customers, unit costs, and spend from both Google and Meta. Every number on the summary can be traced back to what produced it.
Margin that actually resolves. Product costs and ad spend are both in there, so gross sales run all the way down to contribution margin. A dashboard that stops at revenue is the one nobody in charge of a business finds useful.

It opens in Excel, and the summary tab uses newer formulas, so open it in a recent version. Google Sheets will show errors on that one tab and correct data on the other seven, which is still everything the dashboard gets built from.

What it costs to run

The file is free and there is nothing to sign up for to use it. The build in the video needs Claude Code, and the video puts the finished dashboard on a free hosting account rather than a paid one, so you can follow the whole thing without spending anything. The paid pieces only appear when a real client does. That is a sign-in wall for their private numbers, and the accounts are theirs, not yours.