I was about to post a comment on power pivot myself. We were building a lot of tools in R but eventually switched most of it to power pivot. My onl complaint w

I was about to post a comment on power pivot myself. We were building a lot of tools in R but eventually switched most of it to power pivot. My onl complaint would be that it isn't practical to refresh it with new data, it requires more manipulations than I would like.