What do you like best?
-Looker has an extensive data modelling layer ( not to be confused with statistical modelling). This is a feature that makes it stand apart from other tools. With the help of PDTs, we implement a lot of data transformation which wouldn't be very efficient on just another BI tool.
-With just a few lines of LookML code, you can join different data from source tables and view these fields in one place to be able to build Looks on it, without writing long lines of sql.
-Once you build a Look (one report) with drag/drop and filters, it is easy to to visualize data, add calculation fields, etc.
-When you run an individual look, you can see the underlying SQL generated and you can easily figure out if the report is doing exactly what you need it to
-Admin features like content validator let you check if changing views/dimensions/measures at one place is affecting anything else the rest of you ecosystem.
-Prompt Customer Support
What do you dislike?
-Slow learning curve - The terminologies like Looks, Explore, Model etc, as well as the site navigation for these is not very intuitive to a first time user, even thought he/she might be experienced in other BI tools. LookML might also seem non-intuitive at first, but is easy to learn and very useful.
-Data Visualization options are plenty, but not as great as other tools.
-Some complicated Looks tend to load very slowly, even though the actual query would have run pretty fast. Affects load time in Dashboards as well API
- Can be time consuming for exploratory analysis - but best once you know exactly what to implement.
Recommendations to others considering the product
If you need some tool to provide reports to a large amount of audience, make it self serve to an extent and have a strong team to manage it, you can go for it.
What business problems are you solving with the product? What benefits have you realized?
We have been able to implement a whole lot of our reporting requirements in Looker. Some of the savvy sales or higher management are able to gather simple insights from the UI by themselves. Daily/monthly tracking happens through dashboards in mails or UI.