2020-02-19

Bex Bax Dax Pax

Recently I have participated in some BI meetings where the participants were discussing how to create new applications. Nowadays this seems to be very complicated, they use BEX DAX and all kinds of esoteric cryptic query languages. All tasks very complex, offloading data from one multi-dimensional data warehouse to data lakes into tabular data cubes stores.'You have to move the data to a data lake because you cannot have measures in BEX, then DAX with measures to a tabular cube and then we can apply PowerBI and create the application'. I use tables and SQL, after listening to the modern BI workers, SQL seems like an attractive option. What the modern BI consultant needs days or weeks for, I can do in hours.
The only interesting thing said at those meetings were tabular cubes. Tabular Cubes!? I do not know what that is, it seems to be a scaled down multi dimensional cube, the human brain can comprehend, still complex enough keeping business people out. O tempora, o mores.

No comments:

Post a Comment