I know that OLAP is used in Power Pivot, as far as I know, to speed up interacting with data.

But I know that big data databases like Google BigQuery and Amazon RedShift have appeared in the last few years. Do SQL targeted BI solutions like Looker and Chart. io use OLAPs or do they rely on the speed of the databases?