Data Quality & Visualization Studio
100% In-Browser Processing • Zero Server CommunicationPerform complete client-side data analysis for CSV, TSV, and JSON datasets entirely in your browser. Profile data quality, check missing values and duplicates, clean and transform, calculate statistics and pivot tables, render 15 accessible charts, and export in multiple formats.
- 100% In-Browser Privacy & Zero Server Upload
- Data Quality & Statistical Profiling
- Safe Cleaning & Formula Derived Columns
- 15 Accessible Vector SVG Chart Types
- CSV, JSON, SVG, PNG & Verified PDF Export
100% In-Browser Processing • Zero Server Communication
All uploaded and pasted data remains strictly in your browser memory. Data is never uploaded to any remote server, nor saved to cookies or persistent storage.
Statistical correlation measures linear association between variables and does not indicate a causal relationship.
Statistical outliers identified via the IQR method are mathematical candidates, not necessarily erroneous data points.
Dataset Loaded
Drop CSV, TSV, or JSON files here
or click to browse local files (up to 100MB)
Total Rows
12
Total Columns
8
Missing Cells
2(2.1%)
Duplicate Rows
1(1 groups)
Data Quality Findings
Column Profiles & Distribution
Click a column row to inspect distribution & frequencies| # | Column Name | Inferred Type | Missing Count | Unique Count | Mean / Median / Quartiles | Outlier Candidates |
|---|---|---|---|---|---|---|
| 1 | Date | 0 | 11 | - | 0 | |
| 2 | Region | 0 | 6 | - | 0 | |
| 3 | Product | 0 | 3 | - | 0 | |
| 4 | Quantity | 1 (8.3%) | 10 | μ: 11.3 | med: 12.0 | 0 | |
| 5 | UnitPrice | 0 | 3 | μ: 2533.3 | med: 2500.0 | 0 | |
| 6 | Revenue | 1 (8.3%) | 8 | μ: 22218.2 | med: 21600.0 | 0 | |
| 7 | CustomerRating | 0 | 10 | μ: 4.5 | med: 4.5 | 0 | |
| 8 | InStock | 0 | 2 | - | 0 |
Column Details: Date
Detected as date (100% match)
Value Frequencies (Top Values)
| Value | Count | % |
|---|---|---|
| 2025-01-05 | 2 | 16.7% |
| 2025-01-06 | 1 | 8.3% |
| 2025-01-08 | 1 | 8.3% |
| 2025-01-12 | 1 | 8.3% |
| 2025-01-15 | 1 | 8.3% |
| 2025-01-18 | 1 | 8.3% |
| 2025-01-20 | 1 | 8.3% |
| 2025-01-22 | 1 | 8.3% |
| 2025-01-25 | 1 | 8.3% |
| 2025-01-28 | 1 | 8.3% |
| 2025-01-30 | 1 | 8.3% |
Statistical Distribution
Correlation Matrix (Pearson's r)
Notice: Correlation does not imply causation.
| Column | Quantity | UnitPrice | Revenue | CustomerRating |
|---|---|---|---|---|
| Quantity | 1.00 | -0.71 | 0.41 | 0.79 |
| UnitPrice | -0.71 | 1.00 | 0.24 | -0.93 |
| Revenue | 0.41 | 0.24 | 1.00 | -0.06 |
| CustomerRating | 0.79 | -0.93 | -0.06 | 1.00 |
About Data Quality & Visualization Studio
Solasu's Data Quality & Visualization Studio is far more than a basic CSV viewer or online chart maker.
From the moment you load your dataset, it automatically profiles data health—detecting missing cells, duplicate row clusters, type mismatches, statistical outliers, and variable correlations before you even build a chart.
Equipped with a deterministic transformation pipeline, safe formula derived columns, interactive pivot tables, 15 accessible vector SVG chart types, and multi-format export (CSV, JSON, SVG, PNG, and verified PDF reports), it offers a cohesive analytics workstation.
All computations take place strictly inside your browser's local memory. Sensitive research, financial, and customer data is never uploaded to any remote server.
Verify Data Quality Before Creating Visualizations
In addition to row, column, and total cell counts, the engine computes column-by-column missing rates, distinguishes empty strings from 'N/A' tokens, highlights duplicate row groups, and presents type inference confidence.
Solasu avoids arbitrary single scores like 'Data Quality 82/100', providing only objective mathematical metrics and actionable insights.
Reproducible Cleaning Pipeline & Safe Formula Columns
Perform trimming, case normalization, substring replacement, duplicate removal, missing value imputation, column reordering, and column deletion with one click.
Add derived columns using a secure AST expression parser (eval-free), allowing calculations like '[price] * [quantity]'. Every modification is recorded in a transparent transformation log that can be undone, redone, or reset to original at any time.
Statistical Profiling, IQR Outliers, Correlation & Pivot Tables
Calculate comprehensive descriptive statistics including minimum, maximum, mean, median, standard deviation, and quartiles (Q1, Q3, IQR). Statistical outlier candidates are identified objectively via the standard 1.5×IQR rule and Z-scores.
Compute Pearson correlation coefficients between numeric columns displayed as a heatmap matrix (noting that correlation does not imply causation). Construct customizable cross-tabulation pivot tables with sum, average, median, count, min, and max aggregations.
15 Accessible Vector SVG Charts with Rule-Based Suggestions
Render 15 vector SVG charts: Bar, Column, Stacked Bar, Grouped Bar, Line, Area, Scatter, Bubble, Pie, Donut, Histogram, Box Plot, Heatmap, Waterfall, and Funnel.
Automatic chart recommendations are determined via transparent rules based on column data types, not opaque AI heuristics. Accessible colorblind-safe palettes, line patterns, screen reader summaries, and data table alternatives are integrated natively.
100% In-Browser Privacy & Multi-Format Verification
Export cleaned or filtered data with CSV formula injection protection (DDE defense) and UTF-8 BOM, save/restore full project configurations in JSON, export vector SVG or PNG images, and compile audit-ready PDF reports verified with PDF.js.
No data is ever sent across the network or stored in cookies or persistent storage. Closing your browser tab immediately purges all dataset information.
Frequently Asked Questions (FAQ)
Can I load and analyze CSV files?
Yes. The built-in RFC 4180-compliant parser accurately handles quoted fields, escaped quotes, multiline cells, and CRLF or LF line endings. UTF-8 Byte Order Marks (BOM) are automatically detected and stripped.
Can I load and analyze JSON datasets?
Yes. Array of Objects JSON datasets are supported. Nested JSON objects are automatically flattened into tabular dot-notation columns (e.g., 'user.address.city') while preserving structural integrity.
Can I copy and paste tables directly from Excel or Google Sheets?
Yes. Simply copy your table cells in Excel or Google Sheets and paste them into the input area. The tool automatically detects tab delimiters (TSV) and loads your dataset instantly.
Can I detect and inspect missing values?
Yes. The studio calculates missing counts and percentages globally and per column. It distinguishes between nulls, empty strings, whitespace, 'NA', 'N/A', and custom missing value markers.
Can I identify and remove duplicate rows?
Yes. Duplicate rows across all columns are automatically grouped and counted. You can preview identical row entries and remove duplicates with a single click.
Is column data type inference automatic, and can I override types?
Yes. The tool automatically infers integer, decimal, boolean, date, datetime, categorical, and text types with confidence ratings. You can manually override any inferred column type at any time.
Can I clean and transform my dataset in the browser?
Yes. Clean whitespace, normalize letter casing (uppercase, lowercase, title-case), find and replace values, rename or delete columns, remove empty rows, and impute missing values (with blanks, zeros, or preceding values).
Can I filter rows by specific criteria?
Yes. Filter rows using operators such as equals, not equals, contains, starts with, greater than, less than, between, is empty, and is not empty. You can combine multiple filter rules using AND or OR logic.
Can I sort columns?
Yes. Sort any column in ascending or descending order with one click. Numbers, dates, and text strings are sorted accurately according to their respective data types.
Can I detect statistical outliers?
Yes. The tool calculates standard Interquartile Range (IQR) bounds (Q1 - 1.5×IQR to Q3 + 1.5×IQR) and Z-scores (|z| > 3). Outliers are labeled objectively as 'statistical outlier candidates' rather than errors.
Can I compute summary statistics like mean, median, and standard deviation?
Yes. For every numeric column, the studio calculates sum, min, max, mean, median, standard deviation, first quartile (Q1), third quartile (Q3), and IQR.
Can I calculate correlation coefficients between columns?
Yes. The tool computes Pearson correlation coefficients (r from -1.0 to +1.0) between all numeric column pairs and displays them in an interactive correlation matrix heatmap.
Can I create Pivot Tables (cross-tabulations)?
Yes. Configure row fields, optional column fields, value fields, and aggregation functions (sum, count, average, median, min, max) to generate flexible pivot tables with row, column, and grand totals.
What types of charts can I generate?
You can render 15 accessible chart types: Bar, Column, Stacked Bar, Grouped Bar, Line, Area, Scatter, Bubble, Pie, Donut, Histogram, Box Plot, Heatmap, Waterfall, and Funnel.
Does the tool automatically suggest charts?
Yes. The studio analyzes the combination of column types (e.g., date + numeric for line charts, category + numeric for bar charts) and provides deterministic, rule-based chart recommendations without opaque AI guesswork.
Can I export my cleaned dataset to CSV?
Yes. Download your full cleaned dataset, filtered view, or statistical summary as CSV files with UTF-8 BOM for seamless Excel compatibility and built-in CSV formula injection protection.
Can I save and restore my project configuration via JSON?
Yes. Export your complete transformation history, filter settings, and chart options as a project JSON file. Re-importing this file restores your analytical state instantly.
Can I generate a downloadable PDF report?
Yes. Generate an audit-ready PDF report summarizing dataset overview, quality findings, column profiles, and transformation steps. Generated PDFs are verified via PDF.js.
Is my data sent to any external server?
No. The application runs 100% on the client side in your web browser. No dataset records, column names, or cell contents are transmitted over the network.
Is my data stored in local storage, cookies, or databases?
No. Datasets are kept exclusively in transient browser memory. No data is written to localStorage, sessionStorage, IndexedDB, Cache Storage, or cookies. Closing the tab discards all data permanently.
Does correlation imply causation?
No. Statistical correlation indicates a mathematical linear association between variables, but it does not prove that one variable causes changes in the other. Confounding factors may be present.
Can the studio handle large datasets with tens of thousands of rows?
Yes. The table view utilizes virtualized scrolling to render only visible DOM nodes, allowing smooth interaction with 10,000 to 100,000+ rows while remaining responsive.