This documentation page assumes that you already have a SeekTable account.

Get Data

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.
  • Header row is required.
  • File may be compressed with zip (".zip" extension) or gzip (".gz" extension)
  • No limits on the number of rows or columns. Max file size upload limit: 50Mb.
  • 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 may save worksheet as CSV.
Database
  • Supported databases: SQL Server (Azure SQL), MySql, PostgreSql, MongoDb, Yandex ClickHouse.
  • Your database server should be accessible by SeekTable server (34.210.10.23).
  • All queries are performed on-the-fly (no data load or ETL), you can use SeekTable with database of any size.
  • Data can be filtered on database level with report parameters.

In case of file process is 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.

Build Reports

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. Select dimensions that you want to see as "Rows" or "Columns". Empty list is ok.
  3. Select measure(s) that should be displayed in table cells. If no measures selected, "Count" is used by default.
  4. Click on "Apply".

Click on the label changes table order; allow indicates sort direction (click once more to change the direction). Add more dimensions if you want to get better detalization; use filter to remove unnecessary entries.

Save and Share Your Insights