Looker vs Microsoft SQL Server - BI Edition

The pricing is somewhat high, but if you are a larger company it might be worth the money.

Not exactly a con, but we tend to join most of our tables and clean our data in snowflake rather than Looker, so I can't speak to the advanced develop/derived table features.

The only Con is that there are free tools like Postgresql that are also great, but they are not quite as slick as Sql Server.

You will come across error messages every once in awhile when performing tasks, however they are usually easy fixes.