4 ms·

Looks like LLM-written article. It does not explain why Pivot tables never die. Also, somehow this page completely messed up my browser history - I could not ju

by dh2022 1y ago

Looks like LLM-written article. It does not explain why Pivot tables never die. Also, somehow this page completely messed up my browser history - I could not just click the back arrow to navigate back.

NetMageSCW 1y ago
That web site is impressively terrible.
articsputnik 1y ago
You can also read here, in case that works better: https://www.ssp.sh/blog/why-pivot-tables-never-die/ https://www.ssp.sh/blog/why-pivot-tables-never-die/. And it's definitely not LLM written. And I tried to answer the why in the chapter "Why Pivot Tables Endure": > The enduring power of pivot tables is their robustness, simple usage, and fast, interactive response. It's the Lingua Franca of data if you are not fluent in the language of SQL or Python. A common language everyone understands: the top management, domain experts, and developers. It's an interface to data; it's the first no-code interface. Instead of the multidimensional query language MDX or the newer DAX, people can use a simple drag-and-drop interface. It democratized data analysis.
gruez 1y ago
>Also, somehow this page completely messed up my browser history - I could not just click the back arrow to navigate back. It seems like the page updates the page url every time you scroll to a new section, which means you end up with 10+ history entries for the page if you scroll all the way through. To exit out of the page you'd have to click back 10+ times to go through those history entries. Google maps does something similar, where it adds a new entry to history every time you pan, which means your history is polluted with entries for google maps.
- rtkwe 1y ago
  No this does it worse, try actually backing out through it after scrolling down, when I tried it went back to the beginning of the current section but then I couldn't get any further back than that so it's adding more entries each time you go back.

by dh2022 1y ago

NetMageSCW 1y ago

That web site is impressively terrible.

articsputnik 1y ago

You can also read here, in case that works better: https://www.ssp.sh/blog/why-pivot-tables-never-die/ https://www.ssp.sh/blog/why-pivot-tables-never-die/. And it's definitely not LLM written. And I tried to answer the why in the chapter "Why Pivot Tables Endure": > The enduring power of pivot tables is their robustness, simple usage, and fast, interactive response. It's the Lingua Franca of data if you are not fluent in the language of SQL or Python. A common language everyone understands: the top management, domain experts, and developers. It's an interface to data; it's the first no-code interface. Instead of the multidimensional query language MDX or the newer DAX, people can use a simple drag-and-drop interface. It democratized data analysis.

gruez 1y ago

>Also, somehow this page completely messed up my browser history - I could not just click the back arrow to navigate back. It seems like the page updates the page url every time you scroll to a new section, which means you end up with 10+ history entries for the page if you scroll all the way through. To exit out of the page you'd have to click back 10+ times to go through those history entries. Google maps does something similar, where it adds a new entry to history every time you pan, which means your history is polluted with entries for google maps.

rtkwe 1y ago
No this does it worse, try actually backing out through it after scrolling down, when I tried it went back to the beginning of the current section but then I couldn't get any further back than that so it's adding more entries each time you go back.