Looker lookin' good
August 21, 2015

Looker lookin' good

Tom Hosford | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Looker

Our company uses Looker to make data accessible to non developers. With its UI that generates SQL to query to our database, it allows anyone with or without technical skills to access, analyze and pull data or canned reports.
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
Tableau- Not web based which makes it more difficult to use and share templates etc. Seems more dated.
ChartIO - Looker's LookML layer that predefined joins was appealing to us vs a tool like ChartIO which requires more raw SQL comprehension.
Supports new data stores like Redshift which is nice. Not a huge need but if it allowed exploration of data across multiple selections this would be useful. For instance, joining Google Analytics data against our database.
It's nice that you can publish reports. However, I would find it much more secure if you could publish a report but have simple password control to restrict access. Otherwise a bot for instance could always discover a public report.
Do you have a central SQL database that stores all your data? If not, the tool won't apply.
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.

Looker Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
6
Report Formatting Templates
6
Drill-down analysis
8
Formatting capabilities
7
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
8
Publish to Web
6
Publish to PDF
9
Report Delivery Scheduling
8
Multi-User Support (named login)
7
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
9