I don’t think personal data warehouses are immune to any of these forces.
I don’t think personal data warehouses are immune to any of these forces.
If their data model changes, stuff will break and you will need to fix it. I'm fine with that.
This is common and most organizations overcome this problem with a higher effort downstream by Analysts & BI. I personally prefer 3NF tables, event streams or Kimball, in that order, as solutions to create a better DW. The reality is ugly behavior in data modeling can be overcome by Analysts & BI tools. And that seems to be the norm these days...use a DW to structure data to make data accessible, then let Analysts figure out the metrics. With the recent emphasis on tools like Looker or Tableau, this pattern seems to be working.
wrt that, what do you think about Solid from Tim Berners-Lee? (solidproject.org)