100% Browser-Side Processing
CSV and Excel workbooks are parsed inside your browser using dedicated Web Workers. File content never traverses the public internet or external API gateways.
- Runs on user's device with zero server dependency
- SheetJS CE & PapaParse parsing in worker thread
- Multi-sheet Excel workbook tab selector
- Configurable CSV delimiter overrides (comma, tab, semicolon)
Automated Data Profiler
Immediately highlights null values, distinct cardinalities, min/max distributions, and identifies field types (Number, Categorical, Date, Boolean, Identifier).
- Identifies missing value percentage per column
- Detects potential primary keys and dimensions
- Column data type override with 1 click
- Calculates mean, median, min, max for numeric fields
Reversible Data Cleaning Engine
Clean dirty data without corrupting your raw file. OpenMIS maintains an immutable snapshot and a reversible stack of operations.
- Trim whitespace to consolidate fragmented groups
- Deduplicate identical rows
- Filter noise rows by numeric or text thresholds
- Full Undo/Redo stack with transformation history
Deterministic Business Insights
No hallucinated AI summaries. Insights are generated from pure mathematical rules and verified distributions.
- Top-N category concentration (e.g. Top 3 categories drive 68% volume)
- Outlier detection using Interquartile Range (IQR)
- Growth and decline velocity with MoM and YoY formulas
- Evidentiary calculation modal explaining every formula
Apache ECharts Visual Canvas
Automatic visualization engine maps your fields to Bar, Line, Area, Donut, Scatter, and Metric cards based on statistical cardinality.
- Accessible table view toggle on every single widget
- Fluid resize observer with auto-scaling layout
- Color palette themes (Corporate, Ocean, Emerald, Amber)
- Top-N grouping with automatic 'Other' rollup
Visual Report Inspector
Customize every widget title, dimension, measure, aggregation type (SUM, AVG, MIN, MAX, COUNT), sort order, and color scheme.
- Global dashboard filters (date range, categories)
- Widget-level override filters
- Reorder, duplicate, or remove widgets with keyboard access
- Auto-saved state to IndexedDB with JSON export
Export Sanitization (Anti-DDE)
Guards against Dynamic Data Exchange (DDE) formula injection by escaping dangerous characters (=, +, -, @, \t, \r) before writing CSV or XLSX files.
- Automatic apostrophe prefixing for dangerous formula cells
- Preserves legitimate negative numbers (-42) and positives
- Filtered dataset download honoring active canvas filters
- Clean print-ready CSS for boardroom PDF reports
Zero Telemetry & Strict Privacy
No hidden SaaS subscriptions, compulsory logins, or tracking pixels. All data stays confined to your browser session.
- Zero tracking cookies or third-party ad scripts
- Local IndexedDB storage for offline report access
- 1-Click 'Clear Data' memory and cache wipe
- Permissive MIT open-source license