SeekTable
This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

Ad-hoc Reporting & Analytics get started

SeekTable is good for data exploration and ad-hoc reporting and can be used even by non-IT users. It is easy to create, save, export and share reports that are based on your CSV data or connected to a database. Supported visualizations are:

SeekTable can be used for a managed self-service BI scenario when data sources and models (cubes) are maintained by the IT team and users consume them to create their own reports in a controlled way, without having a direct access to the data sources.

Connect to Data

All data visualizations come from the underlying dataset. You can use SeekTable with the following data sources:

CSV/TSV/Excel file

Click on "Upload Data" button, choose a file on your computer you want to upload and - that's all.
SeekTable automatically determines the columns and configures them as a cube dimensions and measures; you can customize default CSV cube setup later if needed.

  • First row with column headers is required.
  • Supported separators: comma, tab, semicolon, colon, pipe. Separator and file encoding are determined automatically.
  • 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 files: both ".xls" and ".xslx" are supported, max file size is 5Mb. If you have larger Excel file you can save the worksheet as CSV.
Database

Click on "Connect to Database" and choose your database type, then configure the connection. Your database should be accessible from SeekTable server (34.210.10.23). If database cannot be accessed from internet you can consider usage of self-hosted SeekTable version. Supported databases:

All queries are performed on-the-fly (without data import) and nothing is stored on SeekTable server (except short-living in-memory cache). You can use SeekTable with database of any size.

Note: aggregated data for summary reports (pivot tables/charts) is cached in-memory for the short periods of time; cloud SeekTable cache settings are (you can customize them in self-hosted SeekTable):

Create reports

Once data source data source ("cube") is configured you can create your 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.
    Use this report type to build a chart.
    Flat table
    Grid that displays dataset rows '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. Click on "Apply".
Pivot table configuration form
Pivot table example

See also create pivot table how-to to get more details on the report creation (filter/sort/drill-down etc).

Save and Share Your Insights

Join the SeekTable Community

Communicate with SeekTable support team, ask questions and share tips: