15 years later. How did it work out?
Also anyone now reading this in 2025. I would recommend a columnar database (snowflake, bigquery, clickhouse etc). And then let your visualization platform handle the semantic modeling