Now is a good time to discuss a perfect-world situation, and one you should aim for, even if you hardly ever reach it! Qlik Sense has an extremely powerful scripting engine that is capable of performing some extremely involved and challenging data transformations. However, just because you can extract, transform, and load data in Qlik Sense doesn’t mean that you should. Qlik Sense is a visualization and data analysis tool – data preparation should be handled upstream, where it can be managed by a BAU (Business as Usual) team with more mainstream skills, and from where it can be available to multiple tools, not just Qlik Sense.
On the other hand, Qlik Sense comes with a very powerful scripting language that will make more than one colleague jealous of the development speed. Things that could take months for a database...