Analytics Tools

Chart Types

OpenAnalyst ships with a comprehensive library of chart types suitable for every analytical scenario. All charts are interactive by default — hover for tooltips, click to filter, and drag to zoom.

• Line chart — Time-series trends, continuous data, and multi-series comparisons. Supports area fills, smoothing, and reference lines.
• Bar chart — Categorical comparisons in vertical or horizontal orientation. Supports grouped, stacked, and 100% stacked variants.
• Pie and donut chart — Part-to-whole relationships. Donut variant supports a center metric for at-a-glance KPIs.
• Scatter plot — Correlation and distribution between two continuous variables. Bubble mode adds a third dimension via point size.
• Heatmap — Two-dimensional density visualization, ideal for time-of-day activity grids and correlation matrices.
• Funnel chart — Conversion analysis across sequential stages. Supports drop-off percentage labels between stages.
• Treemap — Hierarchical data as nested rectangles, sized and colored by chosen metrics. Drilldown navigation is built in.
• Gauge chart — Single-metric progress toward a goal or threshold, with configurable color bands for status indication.

Table and Pivot Views

Raw tabular data is rendered through a high-performance table component capable of displaying millions of rows using virtual scrolling. Columns are sortable, filterable, and resizable. Built-in pagination controls allow you to set page size from 25 to 500 rows.

The pivot table extends the standard table with drag-and-drop row and column groupings. Place any dimension in the row or column axis and choose an aggregation function — sum, average, count, min, max, or custom expression — for the value cells. Pivot results can be exported to CSV or loaded directly into a chart.

-- Example: pivot aggregation via SQL
SELECT
  region,
  product_category,
  SUM(revenue) AS total_revenue
FROM sales
GROUP BY region, product_category
ORDER BY region, product_category;

Statistical Tools

OpenAnalyst includes a set of statistical analysis capabilities that run server-side and return results as chart overlays or separate panels.

• Regression — Linear, polynomial, and logistic regression. Results display the equation, R-squared, and a trend line overlay on scatter or line charts.
• Correlation matrix — Pearson or Spearman correlation between all numeric columns in a dataset, rendered as an interactive heatmap.
• Distribution analysis — Histogram with optional kernel density estimate (KDE) overlay, plus summary statistics (mean, median, std, skewness, kurtosis).
• Outlier detection — IQR-based and Z-score methods flag anomalous data points directly on charts.
• Moving averages — Simple, weighted, and exponential moving averages configurable as overlays on any time-series chart.

SQL Editor

The built-in SQL editor provides a full-featured query environment with syntax highlighting, auto-complete, and schema browsing. Write standard SQL against any connected data source and visualize results immediately.

• Schema explorer panel shows tables, columns, and data types from all connected connectors.
• Query history stores the last 500 queries per workspace, searchable by keyword or date.
• Saved queries can be named, tagged, and shared with team members.
• Results are paginated and exportable to CSV, JSON, or Excel.

Natural Language Queries

Ask questions in plain English and OpenAnalyst will generate the appropriate SQL, execute it, and return a chart or table — no SQL knowledge required. Natural language queries are powered by the AI model selected in your workspace settings.

Type your question in the query bar at the top of any dashboard or report panel, for example:

"Show me monthly revenue by region for the past 12 months"
"Which products had the highest return rate last quarter?"
"Compare this week's signups to the same period last year"

The generated SQL is shown below the result so you can inspect, copy, or further refine it in the SQL editor.