This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Connect to Data web-based reporting tool setup

All data visualizations come from underlying dataset. SeekTable supports the following data sources:

CSV or TSV file
  • Supported separators: comma, tab, semicolon, colon, pipe. Separator and file encoding are determined automatically.
  • Headers row is required.
  • No limits on the number of rows or columns. Max file size upload limit: 50Mb.
  • File may be compressed with zip (".zip" extension) or gzip (".gz" extension) - this allows you to upload even large CSV files (up to 500mb).
  • Sample CSV file: sales.csv.
Excel file
  • both binary (".xls") and Open-XML (".xslx") files are supported.
  • Excel file max size: 5Mb. If you have larger Excel file you can save the worksheet as CSV.
Database
  • Supported databases:
    • SQL Server (Azure SQL)
    • MySql + protocol-compatible databases (like MariaDB, MemSQL, Amazon Aurora)
    • PostgreSql + protocol-compatible databases (like Amazon Redshift, PipelineDB)
    • Yandex ClickHouse (binary protocol)
    • MongoDb + protocol compatible databases (like Azure Cosmos DB)
    • ElasticSearch
    • Have another database? It can be added to the list upon request (if database has ODBC driver).
  • Your database server should be accessible by SeekTable server (34.210.10.23).
  • All queries are performed on-the-fly (without data import), nothing is stored on SeekTable server, except short-living in-memory cache. You can use SeekTable with database of any size.
  • Report parameters may be used for database-level (SQL WHERE) data filtering.

In case of file data source process is a very simple: click on "Upload Data" button, choose a file on your computer you want to upload and that's all. SeekTable automatically determines which columns could be used as dimensions and measures; you can customize this default setup later if needed.

Use Web Report Builder

Now you have a configured data source ("cube") and you can create a first report:

  1. Click on "New Report", or "+" icon in the left menu.
  2. Choose desired report type:
    Pivot table
    Cross-tab (summary) report that displays aggregated data.
    Flat table
    Grid that displays rows (records, documents) as is.
  3. In case of Pivot table report:
    • Select dimensions that you want to see as "Rows" and "Columns". Empty list is ok.
    • Select measure(s) that should be displayed in table cells. If no measures selected, "Count" is used by default.
    • Optional: choose Chart type if you want to get pivot chart visualization in addition to the pivot table.
  4. In case of Flat table report:
    • Select "Columns" to display. At least one column should be selected.
  5. You can specify keywords in the Filter input; click on "filter syntax help" link for quick reference.
    NOTE: filter works only for dimensions that are selected for the report.
  6. Click on "Apply".
Pivot table configuration form

Click on the label (grey cell) changes the order; arrow indicates sort direction (click once more to change the asc/desc direction). Add more dimensions if you want to get better detalization; use filter to remove unnecessary entries:

Pivot table example

Also you can click on the value cell to get more details (drill-down).

Save and Share Your Insights