Both tables and pivot tables are powerful tools for presenting your data effectively. In this video, we'll explore the key differences between them and discuss scenarios where one might be more suitable than the other, helping you choose the best option for your data analysis needs.
Table Cell:
Great for quickly visualising your data
Easy sorting and filtering
Can work with aggregated data from the SQL cell
Good for exporting the CSV in the same format
Pivot Visual:
Great for summarising data
Easy grouping across rows/columns
Less flexible around sorting/filtering
Cannot export pivots in their pivot format