Modern Data Stack : Centralize intelligence, not data...
Modern Data Stack : Centralize intelligence, not data... Each BI tool vendor has invented its own "language," its own grammar, its own internal logic. Examples include DAX, MDX, LookML, Semantic Models, etc. And each tool adds its own internal mechanisms, which change completely from one tool to another. Next, users create specific business rules, which are not always the same from one dashboard to another, from one technology to another, sometimes replicated, sometimes adapted… with subtle variations that create uncertainty. So we "patch", we "tinker", and we end up consolidating a business logic specific to each tool... which amounts, slowly but surely, to creating a... fatal dependency. There are several options to change this situation. Option 1: Data preparation in the database A (false) good idea… Centralizing data preparation in modern and scalable databases has real advantages : We "empty" the BI layer of its complexity,...