News for hackers. Stuff that matters.
Re:The pivot table, the spreadsheet's most powerful tool (2020) by SOLAR_FIELDS on Monday October 09, 2023 @01:34PM (#37822957)
I worked at a company that had this (OLAP Cube + Pivot Tables) as one of my first internships and it was mind blowing. I bring this up in terms of amazing analytics tools in the data space somewhat often. Even highly developed BI tools like metabase can't handle dimensions as well as the pivot table.
Re:The pivot table, the spreadsheet's most powerful tool (2020) by Jgrubb on Monday October 09, 2023 @02:01PM (#37823249)
Can you give an example? I can make metabase pivot tables DANCE (imho).
Re:The pivot table, the spreadsheet's most powerful tool (2020) by namtab00 on Monday October 09, 2023 @04:26PM (#37825070)
I used to work on a BI and reporting platform on the Microsoft stack (SSIS + SSAS + SSRS).. Even got decent at writing MDX.

Thing is, you needed beasty servers to get good performance (event with loads of cube modeling optimizations), but that was rarely the case... This was in the physical servers era, mind you, even started on 32 bit Win Server, which choked up pretty fast...

I switched company around when tabular OLAP models started replacing multi-dimensional models, so I never got to understand those.

MS SSAS got replaced with Qlik / Tableau AFAIK.