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.