Earlier quoted context omitted.
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.
The reason for point and click is that you need to be able to experiment and iterate quickly, which is what point and click is good for (ie tweaking knobs). BI is about asking lots of questions of your data and seeing which ones provide useful results. If you already know what question you have in mind, then yeah, it's going to be a bit tedious.
There are absolutely needs for engineers who (deeply) understand SQL, can write python code, and can whip up a d3 chart. But that's an expensive project.
There are many, many more individuals in organizations who would make much smarter decisions if they learned a tiny bit of SQL, a basic data warehouse, and were presented with a GUI tool (PowerBI, Tableau, Qlik, etc, etc).