CORDIS Research Explorer
A production-style web application for exploring cleaned CORDIS European research project data. The app combines a portable Python ETL pipeline, Supabase database, Next.js frontend, authentication, guest access limits, project filters, dashboard cards and a research chat interface.
CORDIS Research Explorer Full Document
Document Preview
This document explains the full project: objective, data engineering work, application features, architecture, challenges solved and final outcome.
- Next.js and Supabase web app
- CORDIS data preparation and loading
- Search, filters, dashboard and chat features
- Guest access and sign-in logic
CORDIS research projects loaded for web search.
FP7, H2020 and Horizon Europe combined into one web-ready dataset.
Guest access flow before sign-in is required.
What I Built
- Cleaned and prepared CORDIS project data for web access.
- Built the Next.js and Supabase application for search and dashboard views.
- Implemented guest usage limits and signed-in full access.
- Created a Research Dashboard with programme, status, country, organisation, role and funding visuals.
- Reduced expensive Supabase queries to avoid free database timeouts.
- Added a research chat interface and production-ready deployment on Vercel.
Why It Matters
The app converts a large public research dataset into an easy-to-use discovery tool. It demonstrates practical data engineering, frontend development, database loading, authentication logic, BI dashboard thinking and production deployment.