3 ms·
I don't know about Tableau, but Microsoft Power BI does use a columnar engine - I believe its the same VertiPaq/xVelocity component used in Excel Power Pivot an
by arethuza 7y ago
I don't know about Tableau, but Microsoft Power BI does use a columnar engine - I believe its the same VertiPaq/xVelocity component used in Excel Power Pivot and SSAS Tabular Models.
- greggyb 7y agoCorrect. It also shares a fair bit of implementation with columnstore indices in MSSQL Server. There's also a proprietary relational query language shared among Power BI, Power Pivot, and SSAS Tabular, called DAX.