81–90 of 137 posts
Metabase is what you're looking for. https://metabase.com/
That looks great, but AGPL makes everyone nervous.
Also, "everyone nervous" is an interesting choice of words - I'm pretty sure most people wouldn't really care one way or the other. What is it about AGPL that causes stress among the masses?
Earlier quoted context omitted.
It's good, but wait until you discover Mathematica :)
What functions of Mathematica can do the job? I'm interested in checking it out.
I tried most of the free tools but I don't like any of them. In my experience they're all clunky and don't have a beautiful design (I'm on Windows at work and Linux at home). I just settled on DBeaver, but don't consider that an endorsement from my part. I found DB Browser for SQLite to be the least bad, but it's obviously limited to SQLite. My problem may come from the fact I have simple needs and they're all very c…
This may be an unpopular opinion, but if you have US$70/mo to spare, it's hard to beat Tableau for this exact use case. "Connect to an arbitrary database, create a view that joins numerous tables (including foreign tables, via blending) together, load to columnar storage on a local SSD for performance if necessary, add arbitrary derived columns (including well-defined lateral lookups for things like 'annotate this ac…
Earlier quoted context omitted.
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.
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.
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.
This may be an unpopular opinion, but if you have US$70/mo to spare, it's hard to beat Tableau for this exact use case. "Connect to an arbitrary database, create a view that joins numerous tables (including foreign tables, via blending) together, load to columnar storage on a local SSD for performance if necessary, add arbitrary derived columns (including well-defined lateral lookups for things like 'annotate this ac…
Tableau is my go-to too. People think of Tableau as a dashboarding tool (and it is), but it's actually a multidimensional exploratory data analysis tool. You can visualize more than 3 dimensions by way of colors, labels, sizes, etc. You can slice and dice your data and visualize it in so many different ways, and also do drill-downs and filters and aggregations in different ways. The downside is that you have to reall…
Use Excel, QlikSense and Tableau if Business Users need visualization. Excel pivot tables = OG data reshaping. Resist more complicated solutions : do you really need more than Excel?
QlikSense doesn't get enough love. It's actually better than Tableau at some scenarios. Or PowerBI if you're a Microsoft shop. Last time I checked, Power BI's Q&A [2] was a KILLER FEATURE. "Show me Sales per Region, Quarterly" and then you get to fine tune it. R and Shiny dashboards = last resort; too much bespoke work. 2 months using R + Shiny can be 1 week in Tableau / QlikSense / PowerBI.
1. "Efficient reshaping using data.tables" https://cran.r-project.org/web/packages/data.table/vignettes...
2. https://docs.microsoft.com/en-us/power-bi/natural-language/q...