P

Pivotdata

Editor: NRecosite
Virus scanned Windows Free
Descargar v1.0 19 downloads
Versión1.0
EditorNRecosite
Fecha de lanzamientoJul 14, 2015
Fecha AgregadaJul 14, 2015
Requisitos del sistema operativoWindows 10, Windows 2003, Windows 8, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP
RequisitosMicrosoft .NET Framework 4 (or higher)
Descargas totales19
PrecioFree

Descripción

Pivotdata is a command line utility that aggregates data from CSV files and SQL databases, builds in-memory data cube and produces pretty pivot table reports (HTML/Excel/CSV/PDF) without OLAP server and Excel. Pivotdata utility doesn't need any programming skills.

Pivotdata utility can aggregate large datasets that Excel cannot handle (csv files >1gb are processed in several minutes); load data directly from MS SQL (or any other DB that has ODBC driver); load pre-aggregated data (for example result of SQL GROUP BY query); save aggregated values for fast multiple reports generation; perform data cube slicing and filtering; generate 2-dimensional pivot table reports (HTML, CSV, Excel; PDF may be produced by HTML output).