I like the connectivity of the solution. We are able to put in large sets of data and are able to share that with a small query. We can then offer others access. 

The solution allows you to create your own cube, particularly in a shared environment, and that is very useful and extremely powerful. 

The ability to then link to a Power BI or Power Query where you have nice visualization tools is quite useful. The solution works seamlessly with them as a package. It's fantastic.

Anyone who has even a little bit of knowledge of the solution can begin to create things. You don't have to be technical to use the solution.