BusinessNES Tools

PCA Insight Studio

Drop in a spreadsheet and see what your data is really made of: the main patterns, the natural groups, the unusual rows, and the features that drive them. Everything runs privately on this page. Nothing is uploaded anywhere.

  • Runs fully in your browser
  • CSV, TSV and Excel files
  • Interactive 2D and cinematic 3D
  • Beginner and researcher modes
  • Robust outlier-aware scaling
  • Hypothesis prompts
Explanations:
  1. 1Add your data
  2. 2Choose settings
  3. 3Explore results

1Add your data

Use a file, paste rows straight from a spreadsheet, or start with a practice dataset.

Or try a practice dataset

Synthetic practice data, generated fresh on this page. Not real statistics.

Paste rows copied from Excel or Google Sheets

2Choose settings

Sensible defaults are already selected. You can simply press Run.

Columns to include

Load data first. Numeric columns will appear here.

No data loaded yet.

How to read the results

The map, in one minute

Principal component analysis draws every row of your table as one point on a map. Rows that behave alike across all of their numbers land close together. Rows that behave differently land far apart. The horizontal axis is the single strongest pattern in your data, and the vertical axis is the strongest remaining pattern that is independent of the first one.

Three things are worth spotting on any map: clumps of points, which are groups of similar rows; lonely points far from everything, which are unusual rows worth checking; and the overall direction of spread, which shows where most of the variation lives.

What the arrows mean in the drivers view

In the map plus drivers view, each arrow is one of your original columns. An arrow points toward the side of the map where that column has high values. Long arrows matter a lot for the visible plane, short arrows matter little. Two arrows pointing the same way are columns that rise and fall together, while arrows pointing in opposite directions are columns that trade off against each other.

The variance chart, the compass and the heatmap

The variance chart shows how much of the total variation each pattern captures, together with the running total. When the running total is high after two or three patterns, a flat map already tells most of the story. The feature compass places every column inside a circle: columns near the rim are represented well by the current plane, columns near the center are mostly living in other patterns. The heatmap shows every column against every computed pattern at once, so you can name each pattern by the columns that load on it most strongly.

Method notes for researchers

Features are standardized to unit variance by default, robust scaled by mean centering plus MAD spread when outliers dominate, or centered only on request. The decomposition is an exact eigendecomposition of the covariance matrix by cyclic Jacobi rotations when the smaller data dimension allows it, and a matrix free orthogonal iteration with Rayleigh Ritz refinement for very large tables. Explained variance uses the full trace, so percentages are exact in both paths. Component signs are fixed so that the largest absolute loading of each component is positive.

The correlation circle shows the correlation between each variable and each component. Group ellipses are 95 percent normal confidence regions from each group covariance. Outlier scores use Hotelling T squared over the retained components against a chi square threshold. Cluster search runs k-means with a k-means++ start and a fixed seed on the leading component scores, and selects k by the mean silhouette, reporting the Calinski-Harabasz score as a second separation signal. Suggested component counts report the Kaiser rule and the broken stick model alongside cumulative variance. All computation happens locally and results are fully reproducible. The 3D scene is a local WebGL visualization with a canvas fallback; the quality mode changes only rendering density, never the PCA statistics.

Privacy and limits

Your data is processed entirely inside your browser tab. The page makes no network requests with your data, there is no upload and no server side processing, and closing the tab removes everything. Very wide or very long tables are handled with progressive computation, and the display thins extremely dense point clouds while statistics always use every row. PCA describes structure and correlation; it does not by itself prove causation.

More BusinessNES tools

Free interactive tools built for smarter business decisions. No account needed.

Browse all BusinessNES tools

PCA Insight Studio v6.2 by BusinessNES. All computation happens locally in your browser.

'; downloadText('pca-report.html', doc, 'text/html'); setStatus('Report saved. Open the file in any browser, then print to PDF if needed.'); }); }); });/* ======================= observers and init ======================= */ var RO_PEND = 0; function onResized(){ clearTimeout(RO_PEND); RO_PEND = setTimeout(function(){ if (!RES) return; if (VS.view === '3d'){ if (GL3 && GL3.resize) GL3.resize(); } else draw2D(VS.view === 'biplot'); renderScree(); renderCircle(); renderHeat(); }, 140); } if (typeof ResizeObserver === 'function'){ var ro = new ResizeObserver(onResized); ro.observe(ROOT); } else { on(window, 'resize', onResized); } if (typeof IntersectionObserver === 'function'){ var io = new IntersectionObserver(function(entries){ for (var i = 0; i < entries.length; i++){ if (GL3 && GL3.setVisible) GL3.setVisible(entries[i].isIntersecting); } }, { threshold: 0.05 }); io.observe(U.stage); } on(document, 'visibilitychange', function(){ if (!GL3) return; if (document.hidden){ if (GL3.sleep) GL3.sleep(); } else if (VS.view === '3d' && GL3.wake) GL3.wake(); }); on(ROOT, 'dragover', function(e){ e.preventDefault(); }); on(ROOT, 'drop', function(e){ e.preventDefault(); }); if (REDUCED) U.rotate.checked = false; applyMode('guided'); setStep(1); setStatus('Load a CSV or Excel file, paste rows, or try a sample dataset. Nothing is uploaded anywhere.'); /* test hook: only exists when a harness sets the flag before load; inert in production */ if (window.__BNES_PCA_TEST__){ window.__bnesPcaDebug = { getRES: function(){ return RES; }, getDATA: function(){ return DATA; }, getCL: function(){ return CL; }, getVS: function(){ return VS; }, pcaCompute: pcaCompute, calinskiHarabaszScore: calinskiHarabaszScore, vecTipsCount: function(){ return VEC_TIPS.length; }, ingestFile: handleFile, colRef: colRef, selectRow: function(i){ VS.sel = i; describeSelection(i); }, gl3: function(){ return GL3; }, parseNum: parseNum, sniffDelim: sniffDelim, decideDecimalMode: decideDecimalMode, chi2Inv: chi2Inv, ellipseFromCov2: ellipseFromCov2, kmeansBest: kmeansBest, silhouetteMean: silhouetteMean, prng: prng, gaussMaker: gaussMaker, findingsText: findingsText }; } })();

What is PCA?

Principal Component Analysis (PCA) is a mathematical technique that simplifies complex datasets. It transforms many correlated variables into a smaller set of new variables - called principal components - that capture the largest patterns of variation in the data.

  • PC1 captures the strongest overall pattern.

  • PC2 captures the next strongest pattern, independent of PC1.

  • Each additional component explains progressively less variation.

By projecting your data onto these components, PCA makes it easier to:

  • Detect clusters and group structure

  • Identify outliers

  • Understand which features drive the main patterns

  • Visualize high-dimensional data in 2D or 3D

PCA does not prove causation. It is a structured, variance-preserving transformation that reveals how your data is organized.

Turning Data into Business Opportunities

Principal Component Analysis (PCA) helps businesses turn overwhelming amounts of data into clear, actionable insights. By simplifying complex information into its most important patterns, PCA allows companies to spot hidden trends, understand customer behavior, and identify the real drivers of performance. This not only makes decision-making faster and more confident but also sparks innovation - helping businesses discover new opportunities, design smarter products, and stay ahead of the competition.