2
Hello,
Nowadays, I see many B.I tools on the market advertising that their tools are "plug'n play", connect with relational bases, excels and "instantly generate B.I systems".
This gave me some doubt, because I have already trained in the area of B.I and I remember that we always used a mixture of Snowflake Schema and Star Schema, we would never resort to the relational. But it was never explained to me very well why of this.
What comes to mind of why it would be:
- Power to do Drill ups and Drill downs due to Snowflake Schema structure
- Be able to break the value by any part(dimensions), which could only be possible in the relational by means of "notaries" in the tables of values
- Have a portion of information only up to a certain level, without exaggerated granularity (Prevents, for example, the user trying to run a query or graph on something giant and very granular). .
Disadvantages:
-Having to transform the relational world data into the dimensional model
Are there other advantages/disadvantages I’m not remembering? Do you think that for a medium to large company it would really be better to adopt a dimensional model rather than the relational model?
Thank you!!