The Business Intelligence Connector is a stream of your organization's data, packed up and sent on a recurring schedule. Because it's sent in a standardized way, any data tool can be used to visualize the data. Ultimately, the decision of what data tool to use will depend on your organization's existing tools and goals.
In other words - the "best" or "right" data tool for the BI Connector doesn't exist - if it fits your organization, it fits the BI Connector.
Click here for more information on how your data can be hosted for the BI Connector.