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

Grant reporting

Funder reports from your own records, not a blank spreadsheet.

Arts councils, foundations and boards each want figures in their own format, and most arts organisations gather them by hand every year. We record applications, awards, attendance and volunteer hours once, and build the dashboard and exports that answer each funder from the same records.

Start a project See the example projects

// what matters here

What is different in this industry.

Recorded as it happens

Applications, awards, ticket scans and volunteer check-ins counted when they happen, not typed up later.

Each funder's format

Exports shaped to the questions each funder asks, from the same records.

By programme and year

Figures by programme, venue, season and year, so trends are visible.

No personal details in reports

Reports show counts and totals; names and contact details stay in the records.

// 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

Grant portal for an arts council

Hypothetical. Not a client, not a result.

// The problem

A municipal arts council takes grant applications by email, assembles jury packages by hand, and rebuilds the figures for its annual report from spreadsheets.

// What we would build

An application portal where artists and organisations apply, save and return, a jury workspace with scoring and conflict declarations, award letters and final reports, and a dashboard of applications, awards and outcomes by programme. The rules and criteria are the ones your council sets.

// What is in it

Applications with uploads, saved and returned to at any time
Eligibility checks set by your programme staff
A jury workspace with scoring and conflicts of interest declared
Award letters, payment schedules and final reports from grantees
A dashboard of applications and awards by programme and year
Exports in the format your board and funders ask for

// Stack

Next.js
PostgreSQL
Metabase
Transactional email
DigitalOcean Toronto

// estimate

Build: ≈ US$68,700 to US$105,000, delivered within 18 weeksCAD 97,800 to 149,500
Hosting: ≈ US$176 a monthCAD 250 a month
Support: ≈ US$2,500 a monthCAD 3,565 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: 3.4 to 5.4 weeks
Core features: 2.4 to 3.9 weeks
Full build: 1.4 to 2.9 weeks
Testing and fixes: 0.9 to 1.4 weeks
Launch: 0.9 to 1.4 weeks

How it is paid

Deposit 20%: CAD 19,560 to 29,900
Discovery 7.7%: CAD 7,530.60 to 11,511.50
Design approved 7.7%: CAD 7,530.60 to 11,511.50
Core features 23.3%: CAD 22,787.40 to 34,833.50
Full build 15.5%: CAD 15,159.00 to 23,172.50
Testing and fixes 7.7%: CAD 7,530.60 to 11,511.50
Launch 8.1%: CAD 7,921.80 to 12,109.50
Holdback, 30 days after launch (10%): CAD 9,780 to 14,950

Start from this example

Example projectWeb appBot with a web dashboard

Festival volunteer rotas

Hypothetical. Not a client, not a result.

// The problem

A summer festival recruits hundreds of volunteers across several venues each year, fills shifts from a shared spreadsheet and sends every change by group text.

// What we would build

Volunteer sign-up with roles and availability, shift rotas by venue that coordinators build and change, and a Telegram bot that sends reminders, takes check-ins and lets volunteers swap shifts, in the languages your volunteers speak.

// What is in it

Sign-up with roles, availability and training recorded
Rotas by venue and day, built and changed by coordinators
A Telegram bot for reminders, check-ins and swaps
Coordinators told of every swap and gap
Hours by volunteer for thank-yous and funder reports

// Stack

Next.js
PostgreSQL
Telegram Bot API
DigitalOcean Toronto

// estimate

Build: ≈ US$50,800 to US$77,600, delivered within 17 weeksCAD 72,300 to 110,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
Commands agreed: 0.4 weeks
Design approved: 2.4 to 4.4 weeks
Core features: 1.9 to 2.9 weeks
Full build: 0.9 to 1.9 weeks
Working in a test server: 0.9 to 1.4 weeks
Testing and fixes: 0.9 to 1.4 weeks
Launch: 0.9 to 1.4 weeks

How it is paid

Deposit 30%: CAD 21,690 to 33,150
Discovery 5%: CAD 3,615 to 5,525
Commands agreed 3.5%: CAD 2,530.50 to 3,867.50
Design approved 5%: CAD 3,615 to 5,525
Core features 15.2%: CAD 10,989.60 to 16,796.00
Full build 10.1%: CAD 7,302.30 to 11,160.50
Working in a test server 7.1%: CAD 5,133.30 to 7,845.50
Testing and fixes 5%: CAD 3,615 to 5,525
Launch 9.1%: CAD 6,579.30 to 10,055.50
Holdback, 30 days after launch (10%): CAD 7,230 to 11,050

Start from this example

// questions

Questions we get about this.

Can our board see the grant figures without a full login?

Yes, with a read-only view of the totals you choose.

Can it count attendance across several venues?

Yes. Each venue and programme is counted separately and added up in the dashboard.

Can past years of grant data be brought in?

Yes, from your spreadsheets, so this year's figures sit beside earlier ones.

Back to the industry: Museums, arts and culture 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