Skip to content
Mike RotichPERSONAL PORTFOLIOSearch Ctrl KWorkspace ↗

DATA / AVAILABLE

ROTICH Data Studio

A browser workspace for exploring tabular data without uploading the source file.

ROTICH Data Studio with synthetic data
Local demonstration · synthetic data
Open working example ↗

The problem

A spreadsheet can contain useful patterns, but a first inspection should not require a complicated analytics setup.

Implementation

CSV and XLSX inputs are parsed in a browser worker. Users select numeric columns, filter rows and inspect descriptive summaries and charts. Saving requires an account and stores a summary rather than the source workbook.

Architecture

Data flow
  1. Browser file
  2. parser worker
  3. filtered records
  4. statistics and visualisation
  5. optional account-owned summary.

Technical challenge

Mixed data types, missing values and large files need explicit limits. A chart should never quietly substitute missing values with zero.

Outcome & limitations

The implementation includes reference-dataset tests, bounded imports and account-scoped saved summaries. It is an exploratory tool, not a substitute for a full statistical study.

My project

This is part of my ROTICH TECHNOLOGIES initiative. The implementation described above is available to inspect through the working example; it is not a claim of client delivery or sole authorship.

Technology: JavaScript. No public source repository is currently linked.

← All projects

Public content only. Tab through results; Esc closes search.