You are definitely correct when it comes to non-software developers needing tools to do data analysis that allow for a lot more iteration and ad hoc exploration.

How do you see this competing with / differentiating itself from RStudio? The python support?

In the statistics department I was recently at, R was the lingua franca and Rstudio was how we wrote it. I have not found a better product yet for ad hoc exploration than Rstudio but will certainly give this a go.