Skip to main content

Welcome to TeeBI documentation

Build high-performance data applications with TeeBI’s in-memory database, SQL-like queries, and powerful visualization components for Delphi and RAD Studio.

Quick start

Get up and running with TeeBI in minutes

1

Install TeeBI

Download and install TeeBI for your RAD Studio version. TeeBI supports Delphi and C++ Builder from XE4 onwards, plus Lazarus/FreePascal.
// Add TeeBI units to your uses clause
uses
  BI.DataItem, BI.CSV, BI.JSON, BI.Db, BI.SQL;
Use the installer tool or manually add the TeeBI source directory to your library path. No external dependencies required—TeeBI is 100% pure Pascal.
2

Load your data

Import data from CSV, JSON, XML, databases, or any other source with a single line of code.
var Data: TDataItem;

// From CSV file
Data := TBICSV.FromFile('mydata.csv');

// From database
Data := TBIDB.From(SQLConnection1);

// From JSON
Data := TBIJson.From('{"name":"John","age":30}');
TeeBI automatically detects data types and creates optimized in-memory structures for fast querying.
3

Query and visualize

Use SQL-like queries to analyze your data and instantly visualize results with built-in chart and grid components.
// Perform aggregation with group-by
var Result := TBISQL.From(Data, 
  'sum(Sales) where Region="Europe" group by Month'
);

// Display in a chart
BIChart1.Data := Result;

// Or display in a grid
BIGrid1.Data := Result;
TeeBI handles billions of rows efficiently thanks to array-based column storage and parallel processing.

Explore by topic

Dive into specific areas of TeeBI

Core concepts

Learn about TDataItem, data types, arrays, and relationships

Data import

Import from CSV, JSON, XML, databases, Excel, and AI agents

Queries

Master SQL-like queries, filtering, sorting, and expressions

Pivot tables

Create Excel-like pivot tables with dimensions and measures

Visualization

Build charts, grids, trees, and geographic maps

Performance

Optimize for big data and parallel processing

Key features

What makes TeeBI powerful for data-intensive applications

Ultra-fast performance

Array-based column storage delivers exceptional speed for queries and aggregations. Handle billions of cells with ease.

SQL-like queries

Write familiar SQL-style queries with support for WHERE, GROUP BY, ORDER BY, aggregations, expressions, and sub-selects.

Multi-platform

Works on Windows, macOS, Linux, Android, and iOS with VCL, FireMonkey, and Lazarus. 100% pure Pascal, no dependencies.

Rich visualizations

Automatically generate charts, grids, pivot tables, trees, and geographic maps. Full TeeChart integration included.

Ready to get started?

Follow our quickstart guide to build your first data application with TeeBI in minutes.

Get started now