The Kendo UI for jQuery PivotGrid is a powerful data visualization component allowing developers to perform operations over multi-dimensional/ pivot data. Bind it to an OLAP cube or flat data remotely or locally, and get an advanced data view in no time.
The jQuery PivotGrid uses the Online Analytical Processing (OLAP) approach to present the result of multidimensional queries in a comprehensive way. Populate the jQuery PivotGrid to OLAP cube or service which implements XMLA standard to easily display, sort, page and filter data from your Cube.
Allow your users to display dashboard-type views in their jQuery PivotGrid by supporting OLAP and KPIs. The PivotGrid allows them to sort, filter, and page them to get the view they need.
If you need to define your own templates instead of using the built-in cell elements of the jQuery PivotGrid, you can easily define exactly what to be displayed in a certain cell. The component has many built-in cell templates allowing you to customize each of its parts and even place other controls into the different types of cells.
Allow your users to export the content of the jQuery PivotGrid to Excel or PDF with built-in functionality for both. Thanks to the jQuery Excel and PDF export libraries, you can customize the appearance and layout.
Adding the jQuery PivotGrid component to your applications allows you to build basic BI capabilities. You can enable the filtering mechanism in PivotGrid via the API configuration and thus, let your end-users filter their data in Excel-like manner.
Leverage the built-in sorting of the jQuery PivotGrid to allow end users to sort the Row and Column data in an ascending or descending manner.