P

Pivotdata

ထုတ်ဝေသူ: NRecosite
Virus scanned Windows Free
ဗားရှင်း1.0
ထုတ်ဝေသူNRecosite
ဖြန့်ချိသည့်ရက်Jul 14, 2015
ရက်စွဲထပ်ထည့်သည်Jul 14, 2015
Os လိုအပ်ချက်များWindows 10, Windows 2003, Windows 8, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP
လိုအပ်ချက်များMicrosoft .NET Framework 4 (or higher)
စုစုပေါင်း downloads19
စျေးနှုန်းFree

ဖော်ပြချက်

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).