7 ms·
How does something like Tableau fit in? I know of people using Tableau with a Postgres connector, but I am not sure if that allows you the same kind of performa
by sgt 7y ago
How does something like Tableau fit in? I know of people using Tableau with a Postgres connector, but I am not sure if that allows you the same kind of performance as you'd get with OLAP or even a columnar DB.
- arethuza 7y agoI 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.
- jsd3 7y agoTableau (the general visualization engine) just runs queries against whatever database (relational, cube, columnar, web service, file). Tableau has a proprietary extract engine called Hyper that uses a sort of columnar storage. Then you can use the extract in dashboards.