Overview Documentation Methodology Use Cases 🧪 Live Demo

Documentation

How to use every feature of the DataLens BI platform, from loading data to exporting results.

Quick start

Open the sandbox

Click Live Demo in the top navigation.

Load a file

Click Choose file in the sidebar (CSV or Excel), or click Open file in the top bar. CSV files parse automatically. For Excel, select a sheet and click Analyse.

Review data quality

The KPI bar at the top shows rows, columns, completeness %, and active filter count immediately after loading.

Clean your data

Go to the Data Cleaning tab. Click Run auto-clean for one-step cleaning, or apply individual operations per column.

Explore & export

Use the Charts, Trends, Breakdown, and Relationships tabs. Download results from the Export tab.

Tab reference

Tab	What it does	Key controls
Summary	KPIs, auto-insights, and a data preview	Preview mode (Top/Bottom), row count selector
Data Cleaning	Auto-clean and individual column operations with audit log	Run auto-clean, Apply individual, Reset to original
Data Quality	Completeness, duplicates, outlier summary and missing-value charts	Visual bar chart of missing % per column
Charts	Distribution histogram, category breakdown, pie share, segment averages	Metric selector, Group by selector
Relationships	Correlation heatmap, scatter explorer, driver ranking	X/Y axis selectors, Target field for driver analysis
Trends	Time-series line chart with fill	Date field, Metric, Aggregate function, Period grain
Breakdown	Pivot table	Row, Column, Values, Aggregate function
Chart Builder	Custom chart: bar, line, area, pie, scatter	Type, X, Y, Group by, Aggregate
Map	Geographic scatter plot on world map	Lat, Lon, Size by, Label by
Export	Download filtered, cleaned, pivot, HTML report, Excel workbook	Buttons per format

Using filters

Filters live in the left sidebar. Select a field from the "+ Add filter field" dropdown, then click the pill to open its control:

Numeric fields — min/max range inputs.
Date fields — from/to date pickers.
Category fields — searchable checkbox list with value counts.

Active filters appear as chips below the topbar. All 10 tabs respond instantly to filter changes.

Column selector

The column checklist in the sidebar controls which fields appear in analysis, tables, quality reports, and exports. Use All, None, or Metrics only shortcuts, or check/uncheck individual columns. Columns are tagged with type badges: NUM CAT DATE ID

Export formats

Filtered CSV

Current view with all active filters, selected columns only.

Cleaned CSV

Post-clean dataset (only available after running cleaning operations).

Pivot CSV

Current pivot table from the Breakdown tab.

HTML Report

Shareable standalone page with KPIs, insights, and quality summary.

Excel Workbook

Multi-sheet: Overview, Column dictionary, Data preview.

File support: CSV (any delimiter, auto-detected), .xlsx, .xls. Maximum practical size is ~100k rows before browser memory becomes a constraint. For larger datasets, pre-filter before upload.