DAX vs. Tableau

No.

Feature

DAX (in Power BI)

Tableau

1

ETL & Modelling

✔ Power Query for ETL & Power Pivot for Modelling (aka. Relationship Management)

☒ Lack of ETL and modeling feature. E.g. “I routinely have to connect to multiple sources ranging from zipped file, text file, db, to API and wanted ETL that handled all these situations, without need for integration with other software” intimately shared Chihiro.

E.g. Have to get the data into the right format before you can present it

2

Mastery

✔ A small Drill-Down - in term on Filter and Row Context - once you master the understanding of the concepts, you pretty much master DAX (roughly) – Microsoft’s horse power for extensive 250 functions for complex data manipulation!

☒ Tableau language for only Tableau with about 170 functions – Tableau main strength = Simplicity. E.g. I don't think you can create tables with Tableau formula language.

E.g. No “virtual” table via such CALCULATETABLE.

3

Visualization

! Sufficient visuals

✔ More appealing because Tableau was built more around the principles outlined by Stephen Few and Edward Tufte.

4

Integration Service

✔ Integration with other Microsoft products, such as Excel, SQL Server Tabular cubes or SQL Server Analysis Services (SSAS), or Power BI.

☒ Naaah

5

Pricing

! PBI Desktop = FREE on Windows but no such PBI for MacOS.

$9.99/month/Pro User

$20/month/Premium User

$4,995/month/Capacity

Gotta persuade Management & IT dept for this corporate-wide implementation of this tool.

✔ Tableau Public = FREE & Available on both Windows & Mac

$15/month/Viewer

$42/month/Explorer

$70/month/Creator;