Craft retail is a margin business dressed up as a hobby business. A single shop can carry seven or eight buying categories, several own-brand product lines, a marketplace channel, an online store and a workshop programme, and every one of them pulls the gross margin in a different direction. The DIY Craft Stores Dashboard in Power BI is a five-page report pack built on exactly that shape of data: 500 sample orders, 21 columns, a full year of trading from January to December 2025, spread across 8 stores, 8 cities, 7 product categories, 6 product lines, 5 customer segments, 3 membership tiers and 4 sales channels. Out of the box it reports $108,668 of revenue, $33,392 of gross profit, a 36.0% gross margin, a $186 average order value and 4,529 units sold.
Key Features of the DIY Craft Stores Dashboard in Power BI
- Five report pages on one model. Overview, Sales Trend, Product Mix, Store Operations and Customers and Channels, plus a sixth Get More Dashboards page.
- 15 distinct KPIs spread over 20 cards. Total revenue, gross profit, gross margin, average order value, total orders, units sold, average unit price, discount rate, completion rate, return rate, low stock lines, average stock on hand, online share, customer rating and workshop revenue.
- A month-on-month delta and a sparkline on every card. Each tile compares December with November and draws its own 12-point trend line, so the 17.5% revenue rise and the 57.1% drop in returns are readable at a glance.
- Nine slicer fields. Date Range, Region, Product Category, Sales Channel, Store Name, Membership Tier, Product Line, Order Status and Customer Segment, five to a page.
- Workshop income as a first-class measure. Class revenue is its own column, reported at $15,861 and broken down by customer segment.
- Stock cover on the operations page. Stock On Hand and Reorder Point drive a Lines Below Reorder Point by Store chart and a low-stock KPI.
- Editable theme and visible DAX. Every measure is written out in the model and the colours live in the report theme.
Dashboard Pages Explanation
Page 1 – Overview
The landing page answers the question a shop owner asks first: are we ahead or behind? A combo chart, Total Revenue and Gross Margin by Month, puts revenue columns against a margin line so a good sales month with a thin margin cannot hide. Beneath it, Revenue Share by Sales Channel splits the year into In-Store $49.5K (45.5%), Online $30.6K (28.1%), Marketplace $18.1K (16.7%) and Workshop Counter $10.5K (9.6%). Revenue by Product Category ranks all seven buying groups, from Paints and Art Supply at $20.1K down to Woodcraft and Models at $11.7K. The right-hand rail carries Total Revenue, Gross Profit, Gross Margin and Average Order Value.
Page 2 – Sales Trend
Total Revenue by Month is drawn as an area chart with every point labelled, running from $6.5K in January through a $9.3K February, a soft spring around $7K, and then a steady climb to $13.5K in December. Store Sales and Workshop Income by Month stacks the two revenue streams so you can see how much of the December peak is product and how much is classes. A Quarterly Scorecard table closes the page: Q4 $34,559 at 35.5% margin and a $181 basket, Q3 $29,587 at 35.2% and $200, Q1 $22,603 at 37.5% and $176, Q2 $21,920 at 36.3% and $186. The Membership Tier slicer replaces Store Name on this page.
Page 3 – Product Mix
This is the range-review page. Net Sales and Gross Profit by Product Category puts the two bars side by side for all seven categories, and the gap between them is the point: Paints and Art Supply turns $17.6K of net sales into $5.9K of gross profit, while Woodcraft and Models returns only $3.2K on $10.3K. The Product Line Performance table ranks six own-brand lines on revenue, gross margin %, units sold and average unit price, from CraftCore Basics at $27,622 down to EcoMake at $9,442. Discount Rate by Product Line sits next to it, showing EcoMake being discounted hardest at 7.7% and Studio Pro least at 6.4%. Average Unit Price ($24.78) and Discount Rate (7.0%) are the page KPIs.
Page 4 – Store Operations
The Store Scorecard lists all eight branches with revenue, an inline data bar, completion rate, return rate and average stock on hand. Maker’s Mill leads on revenue at $19,589 but carries the worst completion rate at 70.9% and the highest return rate at 13.9%, while Hobby Haven sits at $11,058 with an 87.5% completion rate and no returns at all. Orders by Fulfillment Status splits the 500 orders into 402 completed, 41 returned, 31 exchanged and 26 cancelled. Lines Below Reorder Point by Store ranks the branches on stock risk, with Yarn and Yonder at 8 lines and Pacific Paper Works at 2.
Page 5 – Customers and Channels
Revenue and Workshop Income by Customer Segment shows Workshop Group at $29.4K of revenue and $7.6K of workshop income, ahead of Hobbyist ($26.4K / $3.0K) and Professional Crafter ($26.3K / $1.9K). Revenue Share by Membership Tier splits Basic $59.0K (54.3%), Silver $28.0K (25.8%) and Gold $21.7K (20.0%). Revenue by City ranks eight markets from Boston at $19.6K to Portland at $9.1K. Online Share (27.4%), Customer Rating (3.92 out of 5) and Workshop Revenue ($15,861) are the page KPIs.
Power BI vs Excel vs Paid Retail BI – Feature Comparison
| This Power BI template | Excel dashboard edition | Tableau / Qlik retail BI | |
|---|---|---|---|
| Cost | $17.99 once | $17.99 once | $840+ per user per year |
| Platform | Power BI Desktop (free) | Excel 2016 and later | Vendor cloud plus licence |
| Setup time | About 10 minutes | About 10 minutes | Days to weeks |
| Real-time team collaboration | Via Power BI Service | File sharing only | Yes |
| Mobile access | Power BI mobile app | Excel mobile, read mostly | Native apps |
| Customisable fields | All DAX visible and editable | Calculated fields editable | Restricted by role |
| Share with a link | Yes, after publishing | No | Yes |
| Year-1 cost at 5 users | $17.99 | $17.99 | $4,200+ |
| Workshop revenue modelled | Yes, its own measure | Yes | Build it yourself |
| Reorder-point view | Included on page 4 | Included | Separate module |
Who Should Use This Template
It fits the independent craft retailer with one shop and a workshop room, and it fits a small chain of up to a dozen branches that already exports orders to Excel or CSV. Yarn shops, bead and jewellery makers, paper-craft and scrapbooking stores, sewing and fabric retailers and art-supply chains all map onto the seven categories in the sample. Buyers and range planners get the most out of page 3; area managers live on page 4.
It is not the right tool if you need live till integration, stock write-back to a point-of-sale system, multi-currency consolidation or transaction-level customer history. This is a reporting layer over an export, not an operational system, and it will not place a purchase order for you.
Real-World Use Cases
A three-shop yarn group. The owner refreshes on the first working day of the month and opens the Store Scorecard. One branch showing a 13.9% return rate against an 8.2% group average becomes a conversation that week, not a line item at the year-end review.
An eight-store craft chain buyer. Page 3 tells him which of the seven categories is carrying the margin and which is being propped up by discount. A category returning $3.2K of gross profit on $10.3K of net sales is where the next range review starts.
A paper-craft shop with weekend classes. Page 5 shows Workshop Group customers producing more revenue than any other segment and $7.6K of workshop income on top. That is the case for adding a second Saturday session rather than another shelf of stock.
Advantages of the DIY Craft Stores Dashboard in Power BI
- Every visual is populated before you touch it, so you can judge the layout on real-looking numbers rather than an empty shell.
- Gross profit and gross margin are modelled from Gross Sales, Discount Amount and Cost of Goods, so the report shows earnings rather than turnover alone.
- The 21-column data schema is deliberately flat, which makes replacing the sample rows with a POS export a paste rather than a remodelling exercise.
- Workshop revenue and membership tier are craft-retail specific fields that a generic retail template would not carry.
- The .pbix, the Excel data file and a user manual PDF all ship together, and Power BI Desktop itself is free.
Opportunities for Improvement
Being honest about a template’s edges is more useful than a feature list. Three things are worth knowing before you buy.
- There is no budget or target column. Everything is actual-versus-prior-month; if you want actual-versus-plan you will need to add a target table and two measures.
- Year-on-year is not modelled. The sample carries a single year of data, so the comparisons are month-on-month and quarter-on-quarter. Loading a second year gives you the rows, but the YoY measures are yours to write.
- Stock is a snapshot, not a movement history. Stock On Hand and Reorder Point describe the position at export time, so the low-stock KPI answers “what is short now”, not “how often does this line run out”.
Best Practices
- Keep the 21 column headers exactly as shipped. Renaming a column breaks the measure that depends on it.
- Export a full month at a time. Partial months make the MoM arrows on the KPI cards misleading.
- Set the Date Range slicer first, then narrow with the categorical slicers, and reset to All before you screenshot anything for a meeting.
- Fill Cost of Goods honestly, including landed cost where you can. Every margin figure in the report depends on it.
- Publish to the Power BI Service if more than one person needs the report. Microsoft’s Power BI Desktop getting started guide covers the publish and refresh steps.
- Keep a dated copy of each month’s data file. The report will happily overwrite history you did not archive.
Explore Relevant Templates
- DIY Craft Stores Dashboard in Excel – the same subject built on pivot tables and slicers, for teams that would rather stay in Excel.
- DIY Craft Marketplaces Dashboard in Power BI – for makers selling through online marketplaces rather than a shop floor.
- DIY Home Improvement Stores KPI Dashboard in Excel – a scorecard-style companion for the wider DIY retail sector.
Frequently Asked Questions
Do I need a paid Power BI licence to open it?
No. Power BI Desktop is free and opens the .pbix with every visual working. A Pro licence is only needed to publish to the Power BI Service and share the report with colleagues.
How do I load my own sales data?
Open the included Data.xlsx, paste your export under the existing 21 headers, save it, then use Transform data in Power BI to repoint the query at your file and press Refresh.
How many orders can the model handle?
The sample is 500 rows, but it is a straight import model and handles tens of thousands of rows comfortably on a normal laptop.
Can I add my own logo and colours?
Yes. The report theme is editable and the header banner can be swapped, exactly as in any other Power BI report.
Does it connect to my till or POS system?
Not directly. It reads an Excel or CSV export. If your POS can schedule an export to a folder, you can point the query at that folder and refresh on a schedule.
Is there a Google Sheets version?
Not for this topic. The two editions available are Power BI and Excel, and both are listed above.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
A craft shop’s numbers are not hard to collect; they are hard to look at in one place. The DIY Craft Stores Dashboard in Power BI puts revenue, margin, product mix, fulfilment quality, stock cover, customer segments and workshop income onto five pages that share one model and nine filters, and it does it on data you already export. Download it, paste your rows in, and you have a monthly management pack that takes ten minutes to refresh instead of an afternoon to rebuild.
Get the DIY Craft Stores Dashboard in Power BI on NextGenTemplates – instant download, one-time payment, free lifetime updates.
For step-by-step Excel and Power BI tutorials, subscribe to youtube.com/@PKAnExcelExpert.
