readme.md

Data-mining

Given one or more fields, sort a table and create a new "rank" field for groups:

Queries

Create "Select" queries, pivot-tables, summaries and multi-dimensional queries using the editor dialog:

And at design-time, edit the properties and callbacks for each part of the query, if desired:

Geographical queries (ie, "sum by country") and charts are easy using the included "Geo" database:

Summaries

Dimensions of a summary include expressions (sum, average, etc), or a custom Delphi function callback:

Also Histograms (numeric and alphabetic) to split results in groups by a given field:

Filtering

Filter expressions can be writen as strings and also visually constructed:

Searching can also include highlighting data that match the filters:

Expressions

Expressions used at query filtering, sorting, etc, can be configured and debugged:

Gridifying

The "gridify" algorithm converts a flat table to a two-dimensional grid automatically:

The output grid can be "colorized" using custom colors and criteria:

Map and Reduce

Sort and aggregate data using the "map and reduce" algorithm, ultra fast:

Importing

Data can be imported to TeeBI in multiple ways, for example from a single file, a folder full of files, or an FTP server:

Exporting

TeeBI Data can be exported to multiple formats (xml, json, csv, tree hierarchical, grids, html tables, etc), also to a TRichview control:

Or to Adobe Portable Document Format, PDF:

Data stores

Data can (totally optional) be organized locally in folders, imported from different sources:

An Store can be a folder in your machine, or at a URL web address (Remote Stores) :

REST

Import data from a TeeBI web server using the Delphi REST components:

BIChart

Using a BIChart at design-time, connecting datasets and configuring options:

TeeChart

Connect a TeeBI data item to a TeeChart series:

Statistical, Financial Functions

All functions available in TeeChart can be used and applied to any TeeBI DataItem data, outside charts too:

Geographical charts

TeeChart "Pro" version includes many world maps of polygons, like USA States or Counties:

Using TeeChart "Pro" version allows creating custom entity polygons and used with TeeBI queries:

Several countries are included, with polygons and entity names, for example France:

Using the TeeChart "Pro" 3D components (Skia, GDI+, OpenGL), the world map can be displayed as a live globe:

BIWeb Server

Compile the TeeBI web server as a Microsoft IIS isapi dll:

Or as a Linux executable:

Dashboards

Although now deprecated, Dashboards can be created using TeeBI, for desktop/mobile and web:

Installing and recompiling packages

TeeBIRecompile is the tool that automatically detects ides, recompiles and installs / uninstalls:

RAD Studio

Use RAD Studio "FireUI Live Preview" to see how a TeeBI output looks on a mobile device at design-time:

Lazarus ide and FreePascal

Design-time

Components and controls can be selected at design-time as datasources of BI Grids and Charts:

Design-time menu

TeeBI installs a handy menu to configure local data using the Data Manager dialog:

Component Palette

The different components and controls installed in the RAD Studio IDE:

DUnitX and TestInsight Testing

A Test project is provided that can be used with DUnitX and TestInsight to check TeeBI:

Excel-like Spreadsheet

The "TeeGrid Sheet" demo implements a simple spreadsheet like Excel or Libreoffice, using TeeBI expressions and TeeGrid: