I have seen that the way to blend data takes a lot of clicks, and also is too technical.
Too technical meaning, not many people might be able to write SQL queries to blend data. I can, but you are limiting this functionality for the highly technical users. In this case, there are several challenges. First, the technical background of the people. Maybe include a visual builder, something like creating charts and drag and drop, similar to how you create a single chart, but try to do the same technical stuff in the background, but with a simple way.
Also, there are problems on which the data is not on the same format. For example, the screenshots below are sessions from Google Analytics and clicks from Google Ads. I want to have a correlation between both, and it seems I cannot do it, because the format of data is not the same. I can very well do this on excel, but then, I have to create an excel and just create a simple chart. I understand the technical aspect on which you need a primary key to blend the data, but in this case, this is not a relational database, this is data visualization. Maybe date can be a single metric on the X axis, and what I want to measure on the Y axis, for example.
Lots of clicks, since I have to create a chart, then another chart, then the SQL, then try, etc. I suggest include all in the same step.
This is a great addition, but the technical stuff might be tougher for some users and also makes me just wanna use excel and do a simple graph. If doing blended data in here is easier to export to excel, join information there and then do a simple chart, then using this functionality works. Right now it seems the solution takes more steps than what I am doing right now.