3 ms·
How does Apache Drill compare to Power Pivot/ Power Query? As far as I understand, both aim to solve the problem if heterogeneous data sources. What I don't und
by polskibus 11y ago
How does Apache Drill compare to Power Pivot/ Power Query? As far as I understand, both aim to solve the problem if heterogeneous data sources. What I don't understand is how they differ.
- IndianAstronaut 11y agoI'm not sure power pivot deals well with heterogeneous data sources. It rests on OLAP services which rely on a fixed star schemas in a data warehouse. Power pivot is just a front end for MDX(multi-dimensional expression) queries.