Sqliteviz allows building pivot tables and visualizing them. To build a pivot run a query to get data. Then open visualisation panel by clicking in any of the two side toolbars and choose a pivot mode ...
1.1 - The Data Analysis Report tab details this Excel Analysis project with screenshots of all the below steps. 1.2 - The Original Data tab shows the details of the Excel file - ...