Eugene Meidinger on Nostr: There's a weird antagonism in the #PowerBI space. The tool reaches a broader ...
There's a weird antagonism in the #PowerBI space. The tool reaches a broader audience, so you have many, many more people making reasonable mistakes. They get it working, and it's good enough until it isn't. People do what is easy and intuitive.
In most cases this leads to poor performance or butt ugly data models. Expert users get frustrated with the same mistakes being made over and over, so they say "always do this, never do this", without much explanation of why. It comes across as dogmatic.
Yes, I'd love to wrap everyone in guard rails and avoid easy mistakes. But it's better to say "Use star schema **because it leads to better compression, simpler DAX, and intuitive filtering**". Help build their intuition instead of handing down commandments.
In most cases this leads to poor performance or butt ugly data models. Expert users get frustrated with the same mistakes being made over and over, so they say "always do this, never do this", without much explanation of why. It comes across as dogmatic.
Yes, I'd love to wrap everyone in guard rails and avoid easy mistakes. But it's better to say "Use star schema **because it leads to better compression, simpler DAX, and intuitive filtering**". Help build their intuition instead of handing down commandments.