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?
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 .