There are tools such as Klipfolio and Grow but you're only limited using their UI to build the reports. That's always limiting no matter how flexible their lang

There are tools such as Klipfolio and Grow but you're only limited using their UI to build the reports. That's always limiting no matter how flexible their language & UI is and larger companies tend to build their own data-warehouse to be able to query the data using SQL without any limit. That's why Periscope, Looker and Mode Analytics are quite popular. There are also open-source tools that help you to ingest the data to your database such as Singer.io. Once you have all your data in raw format, you can model your data and power your BI without any limitation.