Cool. Rolling your own BI seems fraught with peril at most orgs where I imagine the buy vs build decision is always buy. How many PowerBI or Tableau seats do you need before rolling your own internal BI platform starts to make sense?
I don't think it ever makes sense because the large players will always be able to make new innovations (mobile apps, natural language querying, SSO integrations, etc) that, short of large corps hiring BI teams to invest in the open source ecosystem like superset, your open source solution won't have.
I must like to live dangerously. In all seriousness though there are low cost alternatives to those mega BI tools that suit many use cases. If I wasn't rolling my own I'd probably start with Metabase or Superset. What I use: https://github.com/totalhack/zillion
There are tons of data brokers that get near real time user level location data from mobile apps (usually not from ‘name brand’ apps but from the long tail) and then sell this as aggregated data products to others: eg https://docs.safegraph.com/docs/monthly-patterns .
Secondary sales and secondary sales rights generally impoverish the common engineer versus founders and exec management. It is extremely rare to find a scale-up that has had secondaries that put non-founder non-execs on equal footing. So sadly it is just business as usual in our industry.