A co-worker (Tableau lover) once told me “SQL is dead” in a whisper like it’s a secret I should know about. I did not like him before, most certainly not after that comment
Funny enough he just stopped me as in the office and said “dude, everyone is looking for experience in SQL, do you do that here?”.
Everyday bro, everyday.
He’s in the job hunt right now.
Having worked in both Tableau and Power BI, I thought Tableau was much more intuitive for visualizing, but prefer a combination of sql and power query for transformations with doing as much of the manipulating in SQL.
Not a fan of Hexagon partitions. To be clear, they’re efficient for db indexing but not good for science stuff which unfortunately lot of practitioners don’t get.
If I can't figure out how to do it using Postgres I just wait around until I do.
The exception is storing files as JSON if I want something lighter weight.