In Tableau, almost every operation maps to some SQL operation (in fact, you can peek at the underlying SQL query if you run the profiler), so mastery of Tableau almost always entails mastery of deep SQL concepts. For instance, almost everything in Tableau is an aggregation, so displaying a simple unaggregated table is actually really hard (you have to make certain fields Dimensions, others Values, etc).

The most common workarounds are for folks coming in with an Excel mindset (where operations are cell-level) who want to accomplish something that is easy in Excel but hard in Tableau.

They aren't workarounds as such, but they are often used for workarounds. Not the cheapest though.Ĭalculated fields are simply field level transformations in SQL. The IDE supplies a ton of guards to help avoid human errors. solid refactoring, peeks, referencing, Intellisense, etc. I'm a big fan of the C# language and the integration with dev tooling is unparalleled e.g. Visual Studio: I don't use this every day, but I do maintain a complex C# codebase from time to time (among other things), and Visual Studio (not VS Code! though I like VS Code too) is genuinely a pleasant IDE.

It's not just dragging-and-dropping - a certain mindset is required.Īctive Directory: it's just there. There is a learning curve for Tableau though, especially around how to structure your data for visualization (you have to think in SQL-like operations). I find that on a new dataset, I can get usable results out of Tableau faster than if were to muck around with ggplot2's syntax, even though I'm familiar with the latter. The UI lets you really interact deeply with your data. I do use Jupyter (seaborn, plotly) and R (ggplot2) which are good, but Tableau lets you touch your data and move stuff around in a more fluid fashion. You can use it to visualize multidimensional data easily. Tableau: more than a dashboarding tool, it's actually a really good multivariate exploratory data analysis (EDA) tool. Live query plans, clustered columnstore indices, linked servers, rich SQL features. SQL Server: it's not cheap, but it's genuinely good.

Lansweeper snmp competitors