{"repo":"danilo-css/analytics-data-pivot","free":true,"listed":false,"github":"https://github.com/danilo-css/analytics-data-pivot","clone":"git clone https://github.com/danilo-css/analytics-data-pivot.git","description":"A no code tool to help build pivot tables from any database with a few clicks.","language":"TypeScript","stars":24,"topics":["analytics","duckdb","excel","nextjs","parquet","pivot-tables","react","xlsx","wasm"],"license":"MIT","category":"analytics","readme_excerpt":"Analytics Data Pivot (ADPivot) Analytics Data Pivot (ADPivot) is a no code tool that helps build pivot tables from databases of any size with a few clicks. You can access a live version of the app through the link: https://datapivot.analyticsdata.pro/. The databases have to be in the Apache Parquet (.parquet) format. ADPivot also supports uploading Excel spreadsheets (.xlsx), selecting a sheet and converting it to a Parquet file that can be used in the application. Support for CSV files is being considered for future versions. ADPivot advantages - Client-side . The application is run entirely on the client (on the user's device) without the need to send any data to a server, allowing fast interactivity and increased security. - Table focused . Unlike similar solutions, this tool is completely focused on creating pivot tables. No overhead for trying to handle charts. - Relational . Multiple databases can be added to allow relational database analytics. - MultiIndex . The resulting pivot table then can be visualized or downloaded preserving the MultiIndex (hierarchical index) structure defined in the application. - Fast . Under the hood, ADPivot uses WebAssembly DuckDB and Pyodide for maximum querying performance. On the front-end side, React and Next.js provide the best UI performance. - Open-source and free: ADPivot is completely open-source licensed under the MIT license. See the launch article%20launch) for further details. How to use it You can use the ADPivot app that's c","default_branch":null,"files":null,"tree":[],"storefront":"/r/danilo-css","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/danilo-css/analytics-data-pivot/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}