Case study · Observatori de Dades de Formentera · 2025
The island's open data bank
The Consell's data portal, with eight thematic views, interactive reports, public surveys in eight languages and a semi-automated collection flow from the tourist offices.
- Data
- Automation
- Surveys
thematic views
languages in the surveys
languages on the portal
The challenge
Data about Formentera was scattered across reports, spreadsheets and paper surveys. It needed a single public portal, a dashboard so the team could publish without depending on anyone, and a way to collect field data without manual work.
The solution
A Next.js application with Firestore as its single data store. The public portal organises information in a category tree with embedded Power BI reports. The admin dashboard includes an editor, drag-and-drop ordering and Excel export. The tourist offices enter data through their own form, and the public surveys, such as those for the Starlight project, work in eight languages. Gemini automatically translates content from Catalan into Spanish and English and powers a public chatbot about the data.
Project highlights
- 01
Frictionless publishing
Visual editor, reorderable categories and one-click exports.
- 02
Semi-automated collection
Forms for the tourist offices and multilingual surveys that feed the data bank.
- 03
AI translation
Every new piece of content is published in three languages with no extra work.
- 04
In-house authentication
Signed sessions in a secure cookie, encrypted passwords and per-route access control.
Technology
- Next.js 16
- React 19
- TypeScript
- Tailwind CSS 4
- Firestore
- Gemini
- Power BI
- Chart.js
- dnd-kit
- Docker
- Cloud Run
Need something similar?
Let's talk about your project