I built something similar in my previous job. The part that we were never able to figure out is how to guarantee that everybody is looking at the right numbers. Even if you have a comprehensive semantic layer, there are still a lot of things that can go wrong in putting metrics on a dashboard. This is why analysts are still needed, IMHO.

Exactly this. My joke tagline for BI is "Lie to your colleagues with confidence and ease".

It doesn't have to be intentional, it just needs to be a sufficiently complex, messy real-world data.

[flagged]