Ask HN: How to build scalable, real-time OLAP for dynamic data analysis in 2023?

What are some effective ways today to implement a dynamic OLAP (Online Analytical Processing) system that supports multiple users to connect their own databases and provide real-time data analysis capabilities? requirements: + There are multiple users, each user has their own data/databases. + Users may dynamic query their own data (like aggregation, filter) at same time. I am looking for suggestions on technologies, tools, and best practices for building a scalable and efficient solution that can handle dynamic and large scale data. Any insights would be greatly appreciated.