Go read about OLAP vs OLTP, those keywords will lead to the answer you are seeking.
It's more about transactional vs analytical systems. You want those decoupled. You can absolutely still use a relational DB for your analytics database, it can even be column oriented and vectorized if you want.