3 ms·
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 analy
by SOLAR_FIELDS 3y ago
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.
- Jgrubb 3y agoCan you give an example? I can make metabase pivot tables DANCE (imho).
- deleted 3y ago[deleted]
- namtab00 3y agoI 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.