[elthor89]

“Be suspicious of companies that are heavily locked into the OLAP cube workflow. (Learn how to do this here).“

The opposite is true too. Be suspicious of companies trying to lock you into their selfservice of data visualization tool. I have seen many BI tool vendors trying lock their clients into their tool. As result they get unnecessary complex models running.

I find the olap a pretty good mental model. That developers and users can understand.

The sheer amount of handwritten, tailor made etl or elt pipelines is something I like to see automated or replaced with something better.

[glogla]

Yup. At my job we ended up some way too important stuff "modelled in BI tool" in a way that nobody could understand how it actually works, and had to do full rewrite to model it in SQL.

But not all BI tools are alike - something like Superset which internally uses SQL and expects users to do self-service transformation using views is easy to industrialize since you already have the queries. Something like Tableau, not so much.

(If only Superset were more mature)