This example illustrates how
PivotData Microservice can be used
for building user-defined pivot table reports and charts.
-
All pivot table calculations, HTML rendering, exports are performed on the server-side
with PivotData Microservice web API.
- Builder UI (js frontend) may be embedded into any web application. This part is highly customizable.
- Any dataset size for database sources; CSV files up to 200-500mb
- Live connection to SQL Server, MySQL, PostgreSql, SQLite, Amazon Redshift, Google BigQuery, Yandex ClickHouse, MongoDb, OLAP cube (Analysis Services).
- Labels grouping (several dimensions) for rows/columns, expand/collapse mode
- Grand total, totals column and row, subtotals for grouped labels
- Sort by table values, totals and labels (click on rows/columns/totals label)
- Multiple values in one table, percentage/difference/running totals calculation, server-side pagination and TOP N limits, heatmap, custom formatting.
- Pivot table exports: HTML <table>, CSV, Excel, PDF, JSON, Image
- Front-end (jQuery plugins) for interactive data exploration: fixed headers, sorting, filtering, pagination, drill-down.
- PivotData Microservice (.NET Core app) that can be hosted on Linux or Windows server.