Overall Satisfaction with Looker
Non-technical users can simply view saved queries (“Looks”), consume dashboards (collections of “Looks”), or go deeper and explore data on their own.
Technical users can use Looker’s modeling language, LookML, to set up data for exploration. Once a data model is set up in Looker, we don’t have to waste time manually writing SQL queries. “Looks” can be saved which store common queries and therefore reduce the chance of a person accidentally issuing an incorrect query at a later date.
- Allowing an analyst or organizational stake holder to explore data
- Generating canned reports or dashboards
- Emailing out reports on a regular basis
- LookML can be difficult to comprehend and I've gotten stuck at times when trying to issue queries that would be manageable to write with raw SQL
- Dashboards could allow more customization
- Pricing is high for small businesses
ChartIO - Looker's LookML layer that predefined joins was appealing to us vs a tool like ChartIO which requires more raw SQL comprehension.
Who should have access to your data? If it's only a few analysts, a cheaper option may be a better bet. If you want to make data available across your organization, Looker is a great bet.