I made advanced BI queries with Scratch puzzle pieces
1–10 of 21 posts
Re: I made advanced BI queries with Scratch puzzle pieces
#2Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
Re: I made advanced BI queries with Scratch puzzle pieces
#3Thanks for making a whole blog post out of the anecdote mentioned yesterday. Really excellent to see the whole story!
Re: I made advanced BI queries with Scratch puzzle pieces
#4Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
Not because they're any better of a fit for BI stuff mind you. At my place of work, the BI department is a black hole you can keep shoving more compute into, and they'll just come up with worse queries.
Re: I made advanced BI queries with Scratch puzzle pieces
#5Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
Like excel this tools really help making user ->power users I think the problem whit no code is they make developer tools les powerfull instend of regular tools more powerfull
Re: I made advanced BI queries with Scratch puzzle pieces
#6Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
I do a lot of BI and am a coder. I find these tools (Tableau) super frustrating. So much point and click. Such poor abstractions. Not at all DRY. I like the end product just not the process. Lacks a good API for doing it programmatically - which makes sense as they make money selling desktops.
Re: I made advanced BI queries with Scratch puzzle pieces
#7Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
Not because they're any better of a fit for BI stuff mind you. At my place of work, the BI department is a black hole you can keep shoving more compute into, and they'll just come up with worse queries.
I mostly agree, but I think there's a reason behind the madness. Back in the early 00s to early 10s they really were more productive, "secret alien technology"-type tools.
But these days obviously ten lines of python (or whatever else) calling the database do exactly the same thing, except you actually have git, debuggers, ides, etc.
Many BI departments still cling to them because they're comparing 2020s no-code tools to early 2000s programming languages.
Re: I made advanced BI queries with Scratch puzzle pieces
#8Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
I do a lot of BI and am a coder. I find these tools (Tableau) super frustrating. So much point and click. Such poor abstractions. Not at all DRY. I like the end product just not the process. Lacks a good API for doing it programmatically - which makes sense as they make money selling desktops.
Dis you tried Shiny, Dash or something like those tools?
Re: I made advanced BI queries with Scratch puzzle pieces
#9Earlier quoted context omitted.
Not because they're any better of a fit for BI stuff mind you. At my place of work, the BI department is a black hole you can keep shoving more compute into, and they'll just come up with worse queries.
I mostly agree, but I think there's a reason behind the madness. Back in the early 00s to early 10s they really were more productive, "secret alien technology"-type tools. But these days obviously ten lines of python (or whatever else) calling the database do exactly the same thing, except you actually have git, debuggers, ides, etc. Many BI departments still cling to them because they're comparing 2020s no-code tool…
Tableau is way faster to demonstrate your work on.
These professions need to get shit done fast. The workplaces that need them are extremely reactive to the market, etc.
So having debuggers isn’t necessarily a thing they’re interested in.
Now if you’re in a slower paced BI environment that’s where you generally see more traditional programming tooling be used.
Re: I made advanced BI queries with Scratch puzzle pieces
#10Probably a bit of a tangent, but the BI world sure loves their no-code tools. It's one of the few sub-industries where they really took hold.
There may be no other sub-industry that desperately craves to abstract away as much complexity as possible