Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the ...
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 ...