DataNinja

Dashboards for your trade

Pick what you do. You get a finished dashboard straight away, on worked numbers — then drop your own export in and the same dashboard redraws with yours.

Want it kept, refreshed each month, and open to your whole team? That is Reports.

Gyms and fitness studios Members, joins and cancellations, what each plan brings in, and when the place is actually busy. OverviewMembershipAttendanceBilling Cafes and coffee shops Takings and transactions, what sells and what actually makes the money, and when the rushes are. OverviewTradingMenu Trades and contractors What you invoiced, what kind of work it was, and how much of it is still sitting out there unpaid. OverviewJobsMoney Hair and beauty Takings and how many heads they came from, what gets booked, when the chairs are full, and who didn't turn up. OverviewDiaryServices
More trades Clinics, bakeries, mechanics, dog groomers. Tell us what you run and what you export, and yours goes next.

Cafe dashboards

A worked example on invented numbers. Drop your own file in below.

Aug 25 — Jul 26

How is trade going?

Fill this board from your Item sales export (Square, Lightspeed)

Takings
$44,986.50
+$1,290.50 on last month
Every line in the file, added up.
Sales
3,535
+65 on last month
Receipts, not lines. One sale can carry six items.
Average sale
$12.73
+$0.14 on last month
Takings over sales.
Items sold
6,066
+166 on last month
Every quantity on every line.

Takings

Every line in the file, by the month it sold in.

37,920
44,986.50
Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Jul 26
Show the numbers
PeriodTakings
Aug 25 37,920
Sep 25 39,186
Oct 25 40,670
Nov 25 40,819
Dec 25 39,186
Jan 26 35,029
Feb 26 39,721
Mar 26 41,505.50
Apr 26 40,437.50
May 26 42,100.50
Jun 26 43,696
Jul 26 44,986.50

Takings by category

Jul 26. The bars add to the month's takings.

Coffee $18,145.00 Food $16,977.50 Pastries $6,368.00 Retail $3,496.00

Adds to $44,986.50.

When is the place actually busy?

Fill this board from your Item sales export (Square, Lightspeed)

Busiest day
Fri
540 sales in Jul 26.
Busiest time
8–10am
1,079 sales across the week.
Quietest day
Sun
454 sales in Jul 26.
Weekend share
27.8%
981 of 3,535 sales fell on Sat or Sun.

When the rushes are

Sales through Jul 26, by day and time of day.

6–8am8–10am10am–1212–2pm2–4pm Mon 78 165 96 104 45 Tue 80 170 98 106 46 Wed 82 172 99 108 47 Thu 84 175 101 110 48 Fri 88 182 105 115 50 Sat 40 120 165 140 62 Sun 26 95 150 128 55

3,535 sales in the grid, busiest cell 182.

Sales by day of the week

Jul 26. The grid's rows, added up.

Mon 488 Tue 500 Wed 508 Thu 518 Fri 540 Sat 527 Sun 454

Adds to 3,535.

What sells, and what actually makes the money?

Fill this board from your Item sales export (Square, Lightspeed)

Top seller
Flat white
$8,525.00 of $44,986.50.
Biggest category
Coffee
$18,145.00 of $44,986.50.
Items per sale
1.7
Items sold over sales.
Average item
$7.42
Takings over items sold.

What each item brings in

Jul 26. The bars add to the month's takings.

Flat white $8,525.00 Bacon and egg roll $6,812.50 Smashed avo $6,480.00 Latte $5,875.00 Croissant $4,160.00 Toastie $3,685.00 Long black $2,835.00 Beans 250g $2,596.00 Banana bread $2,208.00 Cold brew $910.00 Keep cup $900.00

Adds to $44,986.50.

Takings by category, month by month

The columns add to the month's takings.

Coffee Food Pastries Retail
Aug 25
Oct 25
Dec 25
Feb 26
Apr 26
Jun 26
Jul 26
Show the numbers
Month CoffeeFoodPastriesRetail Total
Aug 25 $15,510.00 $14,230.00 $5,370.00 $2,810.00 $37,920.00
Sep 25 $16,155.00 $14,623.00 $5,496.00 $2,912.00 $39,186.00
Oct 25 $16,970.00 $15,016.00 $5,648.00 $3,036.00 $40,670.00
Nov 25 $17,222.50 $14,873.50 $5,585.00 $3,138.00 $40,819.00
Dec 25 $16,587.50 $13,543.00 $5,123.50 $3,932.00 $39,186.00
Jan 26 $15,257.50 $11,958.00 $4,529.50 $3,284.00 $35,029.00
Feb 26 $17,160.00 $14,279.50 $5,325.50 $2,956.00 $39,721.00
Mar 26 $17,515.00 $15,212.50 $5,698.00 $3,080.00 $41,505.50
Apr 26 $16,775.00 $15,016.00 $5,628.50 $3,018.00 $40,437.50
May 26 $17,242.50 $15,752.50 $5,919.50 $3,186.00 $42,100.50
Jun 26 $17,720.00 $16,500.00 $6,166.00 $3,310.00 $43,696.00
Jul 26 $18,145.00 $16,977.50 $6,368.00 $3,496.00 $44,986.50

Now with your numbers

Drop your own export in and every board above redraws with your data. Nothing is stored — the file is read in memory, the page comes back, and we keep no copy. That is also why this asks for the file again rather than remembering the last one.