EZReports
AI analytics for spreadsheet data
The problem
Business users had data stuck in CSV and Excel exports, and needed an analyst every time they wanted a chart or an answer. Messy files with misplaced headers made even simple reports slow.
What we built
- Built the entire backend; a teammate built the frontend
- Upload and auto-clean: the system finds the real header row, checks the structure and prepares the data
- AI chart suggestions with OpenAI and Google Gemini, which users can then filter and customise
- "Chat with your data": plain-English questions, chat history, and suggested starter questions
- An instant dashboard with summary cards, a searchable data table, formula-based columns and PDF export
- Calculations done in code rather than by the AI, so the numbers are always correct
The result
Raw spreadsheet exports became a dashboard and an AI assistant, without an analyst. The API went from first commit to AI chat in about 3 months and runs in production.
