Microsoft BI is used across many departments within the organization. Due to the availability of other software tools, Microsoft BI is only used in certain parts of the business. Microsoft Power BI is used for automated data reporting and interactive visualizations. The software is also used for some analytics processes.
Microsoft BI has an advantage over other BI platforms because it integrates nicely with the Microsoft products, such as Excel, Microsoft SQL, Access, and all the other parts of the Microsoft business. A user that has spent time with Microsoft products will find Microsoft BI to be similar in functionality to other Microsoft products. Microsoft puts ease of use as a top priority, and it shows up in Microsoft BI. Microsoft BI is, of course, not the top business intelligence platform. It does not have the nicest graphics, the biggest user base, or the most advanced analytics capabilities. It's sort of a starter BI solution.
I have yet to run across a data source that Microsoft BI can't connect to. Microsoft BI easily connects to JSON, SQL, and pretty much every other data source. The software is not the best at merging data from disparate sources. It takes some time to get things up and running with different data sources. Real-time updating of Microsoft BI visualizations is probably one of the best BI tools out there. Works just fine.
Microsoft BI makes sharing data across the department and organization relatively straight-forward. As long as each user has some understanding of Microsoft BI, sharing data and visualizations couldn't be easier. I'm not really a security guy, but from what I can tell, controlling access works just fine and controlling versioning is also straight-forward. Formatting visualizations is clunky.
Microsoft BI is great if you and your team have used Microsoft products for a long time. Connecting Microsoft BI to your current processes will be a breeze. The software also makes it easy to create executive dashboards and automated data reporting. For simple financial reporting, Microsoft BI is as easy as they come.