Often the fastest way to get answers out of your data is to ask a question using natural language. This is like a Google but for numbers and your private business data. Just try it.
|→||create reports with search-based queries|
|→||autocomplete suggestions help to form the question|
Typical business questions that start with "How much?", "How many?" and pivot table (aka crosstab, matrix report) can provide those types of answers.
Pivot tables are great for analyzing large datasets. They help you make data-driven decisions and get valuable insights from your data.
|→||Labels grouping, sort by values|
|→||Several measures in one pivot table|
|→||Totals and sub-totals|
|→||Charts: bar, stacked bar, horizontal bar, line, pie|
SemanticTool is good for both one-time and periodic summary reports you need for meeting, presentation or executives.
You can do it in minutes even if you know nothing about pivot tables!
Report can be saved and reused next time like in other reporting tools.
|→||Keyword-based data filter with autcomplete suggestions|
|→||Rows or columns exclusion|
Start by uploading your data via comma separated file (.CSV), tab separated file (.TSV) or spreadsheet file (.xls, .xslx, .ods).
SemanticTool automatically detects file format, column data types, data cube dimensions and measures.
|→||Analyze large CSV files (>100k rows, >100 mb)|
|→||Import data from SQL data sources (MS SQL and others)|
|→||Custom data upload with REST API|
|→||Automated data refresh|
Simply share your insights with colleagues and partners by an email or a public link. The report can be easily included in a document, presentation or a web page.
Keep your thoughts and notes by adding comments to the report with one click. Collaborate and discuss pivot tables just by replying on the email - anytime and from any device.
|→||Shared report is included into email body|
|→||Export pivot table to CSV/Excel/HTML/PDF formats|
|→||Schedule periodic reports (daily, weekly etc)|