InsightBoard — CSV reports
Web application that converts any CSV into a visual analytics report, 100% in the browser.
01 Problem and context
Explorar un CSV nuevo exige abrir un notebook o cargarlo a una herramienta con servidor — lo que además implica subir datos potencialmente sensibles a un tercero.
02 Solution
Todo el análisis corre en el navegador: perfilado de columnas, correlaciones de Pearson, outliers por IQR y alertas de calidad (nulos, encabezados duplicados, PII chilena por regex — email, teléfono, RUT). El reporte se visualiza con Recharts en pestañas y se exporta a PDF o PNG sin que los datos salgan de la máquina.
03 How it's built
InsightBoard is a React application that transforms CSV files into automated analytical reports without a backend: all processing happens directly in the browser. It parses the CSV with PapaParse, profiles columns with type detection, calculates statistics and Pearson correlations using simple-statistics, detects outliers via IQR, and generates data quality alerts (columns with excessive null values, duplicate headers, and potential personal data such as emails, phone numbers, and RUT). Results are visualized with Recharts and can be exported to PDF or PNG.
04 Highlights
- 100% client-side processing: no server or external APIs, session isolation via UUID, and in-memory data only.
- Proprietary analytics engine: Pearson correlation with a 30 valid-row guard, IQR outlier detection, histograms, and linear trends.
- Data quality alerts: PII via regex (email, phone, Chilean RUT), columns with excessive nulls, and auto-renamed duplicate headers.
- Report export to PDF and PNG using jsPDF and html2canvas.
- Architecture documented in SOPs with an Upload → Parse → Profile → Analyze → Render pipeline and included test datasets.