Lyall Paldano
CV
© 2026 Lyall Paldano. All rights reserved.
Back to Home

KPI-Canvas

Nov 2025 - Present

CSV-to-dashboard SaaS for freelancers, bookkeepers and small business owners. Upload a CSV, get a shareable dashboard in under 60 seconds. Also the primary testbed for the OpenClaw agent pipeline.

Tech Stack
Next.js 14TypeScriptSupabasePostgreSQLRow-Level SecurityNivoZodStripeVercelPlaywrightfast-check

Challenge

Freelance bookkeepers export CSVs from Xero, QuickBooks and bank apps every week, but Tableau and Power BI are overkill and Excel is painful. Freelancers needed a sub-minute path from raw data to a shareable client dashboard.

Solution

Built a Next.js 14 App Router app with server-first rendering, Supabase Postgres with Row-Level Security enforcing per-user data isolation at the database layer (not the app), Nivo for SSR-friendly charts, Zod schema-first chart configuration, and Stripe billing. Property-based testing with fast-check hammers the CSV parser against malformed headers, mixed encodings and edge-case delimiters.

Outcome

Architecture and foundation phases complete. 385+ passing tests across unit, integration and E2E. Serves as the production-quality testbed that proves the OpenClaw agent pipeline can ship real code.

Skills Learned

Schema-first chart configurationProperty-based testingRow-Level Security as authorisationPricing strategyFeature scope discipline