| Phiên bản | 1.0 |
|---|---|
| Nhà xuất bản | NRecosite |
| Ngày phát hành | Jul 14, 2015 |
| Ngày thêm | Jul 14, 2015 |
| Yêu cầu Os | Windows 10, Windows 2003, Windows 8, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP |
| Yêu cầu | Microsoft .NET Framework 4 (or higher) |
| Tổng số lượt tải xuống | 19 |
| Giá bán | Free |
Sự miêu tả
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).
