The Online Pivot Tables plugin is a free plugin that works with sqlReports, but can also be used to analyze data from other reports and/or SIS export options. Below is an example of a pivot table based on data from the output of the Current Grades Report - No Minimum sqlReport. After the sqlReport is run, the data is copied by clicking on the Copy button of the report output:
Once copied, the data is pasted into the box on the Online Pivot Tables page. Doing so creates a work area with the column headings from the report.
The column headings can be dragged and dropped into different areas to create various pivot tables or charts. In the screenshot below, the Grade Level column heading was placed in the columns area and Course placed in the rows area
Data can be copied from any report in the SIS or you can upload a CSV file created by an export. The plugin is based on the free open source software located at this web site.