There are many data visualization tools out there, and, like many other aspects in life, they all have Pros and Cons.
Power BI
Microsoft has their own BI tool: Power BI (yes, there are other tools out there other than Tableau).
PROS:
Friendly and intuitive UI; drag-and-drop what you need from a plethora of functions.
Leverages quick customization on Excel; you can still use several Excel functions like SUM(), MAX(), etc. within your data source as you work.
PowerQuery runs within PowerBI. You can run SQL queries on your source to get your data preprocessing done before anything is loaded.
Builds relational tables automatically so you can click and drag fields from related data instantly.
Global, local, and targeted filters ran by the analyst. i.e. the analyst can set one filter to apply to the whole report, one page within the report, or one viz in each page.
Built-in front end page filters ("Slicers") ran by users to quickly target data within a dashboard; no need to mess with the source data.
Cross functional filters between each viz element; e.x. you can click one bar chart's data point and PowerBi will filter the same data point across the dashboard page.
Modestly priced "Pro" version at ($10/month per user) compared to competition. There is a free version, but if you are using it for your business, you'll want to upgrade to "Pro."
CONS:
Backend programming language (DAX) is difficult to learn and understand.
Viz elements are not as striking as other competitors.
Extensive compatibility with online data sources, but largely cumbersome to perform set up.
No efficient way to share private information for internal website; if you want to share a PowerBI viz/dashboard within you company, users will require individual licenses. They will have to login to PowerBI to render the viz.