Re:Ask HN: Tools to visualize data in SQL databases?
by Psyladine on Sunday February 13, 2022 @03:21PM
(#30325238)
Anything solved by tableau is as easily solved by Excel, which likewise supports direct SQL connections. The template graphs & incorporation of function logic, for versatility & business availability make it no contest. Though Tableau has some gorgeous templates, it doesn't also have DAX & PowerBI.
[ Parent
| on HN ]
Re:Ask HN: Tools to visualize data in SQL databases?
by mgradowski on Sunday February 13, 2022 @06:03PM
(#30326483)
I'm curious why do you think of DAX as a virtue. My poor SQL-shaped peg brain has never really fit the DAX hole of MS software.
Also, it always struck me as something too complex for the non-technical folks, and not expressive enough for tech-literate analysts/data engineers &c.
Re:Ask HN: Tools to visualize data in SQL databases?
by Psyladine on Sunday February 13, 2022 @08:29PM
(#30327479)
Just options. VBA is there as well. Excel's virtue is not specializing in any specific task, but being versatile enough to express a multitude of business solutions. 'Excel is my database' wasn't always a punchline.
That's more than an equally domain specific process like Qlik, and more than a specific vendor tool like tableau. And anyway if PowerBI didn't have a pain point it wouldn't be a MS product.