Abstract: The present solution is directed to reporting and analytics tools uniquely designed for easy integration with cloud based applications and enterprise applications with on-premise data and easy use by such applications' end users. The present solution provides this functionality as a service to cloud service providers, enabling them to augment their product's capabilities with a reporting and analytics tools that is seamlessly and securely integrated with their product. The present solution is also beneficial as a reporting tool in any market or vertical to enable end users to easily and securely create custom reports. As such, the present solution reduces the skills required for such reports and reduces the delay, time and expense of using specially skilled resources or technical resources to build the custom reports for the end users.