Great product and support but you need an internal owner with strong SQL and data model knowledge
August 21, 2015

Great product and support but you need an internal owner with strong SQL and data model knowledge

Spencer Wong | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Software Version

Looker Hosted Version

Modules Used

  • All Modules

Overall Satisfaction with Looker

We have a two sided marketplace with both consumers and merchants. I have a lead on my product team that is the Looker owner, he is responsible for setup and soon we will be allowing other members within the company to leverage the Model/Looks he has created. It is expected to be used across Marketing, Tech and Sales.
In addition, we may expose some data through the iFrame to Merchants to see their data and see how they may rank compared others in their area.
The business problems it addresses is that not everyone is competent in SQL and we have a lot of reporting needs so it helps to not rely on someone in Tech to do reports on demand.
  • The fact that you create it once and can allow everyone else to use the same Looks. It allows for consistency in how data is reported and provides a layer of abstraction over the straight db tables
  • Their client support has been very helpful, both the implementation specialists and the online chat
  • Not necessarily a criticism of Looker but in the end, you really need one internal owner and someone who really understands the data model in order to build it properly in Looker. Here I tried initially to leverage Tech, but within tech we had knowledge of data model spreadout and it was also hard to take the devs away from bugs/features to help work on Looker. In the end it required me to hire someone on my own team with advanced knowledge of SQL to own Looker.
  • As a company that is focused on local on demand delivery, the out of the box geo-mapping is very weak. We use carto-db now for mapping but it would have been nice to get this out of Looker. Ability to draw polygons and not just fixed points.
I chose looker because I like that you can always see the SQL being generated in case you run into an issue.
I like that it supports very advanced reporting requirements provided we have internal resources who can build the required SQL
I also like that Looker is a growing company so I expect their feature set to continue to advance faster than other competitors.

It's fine for a single source but you can't join across two data connections which I thought would have been one of the benefits of using Looker.
I haven't used all the sharing functions, right now I just have a couple scheduled reports that send. I like that it only sends when new data is availble
Ability to join across to separate data sources. We ended up having to do workarounds to get all data into one connection but it would have been useful to join across datasets which some other competitors allow.
For more fancy graphing and reporting, Looker's options are pretty basic and not as pretty as some competitors.
Looker is strong when trying to do more advanced reporting with cohort analysis and the use of measures where you can input your own case/sql statements is very powerful.

Looker Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
7
Report Formatting Templates
7
Drill-down analysis
8
Formatting capabilities
8
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
8
Publish to Web
Not Rated
Publish to PDF
Not Rated
Report Versioning
Not Rated
Report Delivery Scheduling
8
Pre-built visualization formats (heatmaps, scatter plots etc.)
4
Location Analytics / Geographic Visualization
4
Predictive Analytics
Not Rated
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Responsive Design for Web Access
Not Rated
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated