We have several BI tools in our data & analytics ecosystem , some of which we are trying to rationalize. However, we are likely to have at least 2 BI reporting tools used broadly across the enterprise (Tableau, Power BI, potentially MicroStrategy), with interoperability with the same data layer (Databricks). In am interested in learning about the topics below:    1. What decisioning criteria should one use to guide a end user to a tool vs the other?    2. What are the pros/cons of allowing users or teams to self select the reporting tool? 

We have two large analytic groups that had already adopted Tableau and Qlik which are two capabilities referenced in Gartner’s magic quadrant.
Any tool should look at:
1. User needs and skill level 
        a. What tool meets your organization requirements
        b. What training will be needed to onboard
2. Cost and licensing
3. Integration with existing systems
4. Performance and Scalability
5. Tool support – is the company responsible to customer support…

The key is to ensure the tool is scalable/flexible to meet current and future needs.

Hi, some 5 cent worth of thoughts:
1. high volume, high frequency, non aggregated (eg. IoT) is not very suited for PowerBI
2. Complicates maintenance, competency and cost plus double work wrt governance, access and security models 

   We have encouraged and consolidated the use of a single reporting tool due to better licensing/cost negotiations and improved maintainability of solutions.

   We previously used Tableau in our BI reporting environment but removed it following the recent Salesforce-Tableau licensing cost hike. Additionally, we have witnessed tremendous improvements in Power BI, which now handles most of our reporting needs.

Power BI has also consistently topped the Magic Quadrants, overtaking Tableau in recent years