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 BI Connector doesn't exist - if it fits your organization, it fits BI Connector.
Click here for more information on how your data can be hosted for BI Connector.