The Best BI User Experience
March 14, 2016

The Best BI User Experience

Gleb Mezhanskiy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Looker

Looker helps us democratize data around 10+ product lines and 4 functions.

We have Looker connected to multiple product databases (PostgreSQL, MySQL) and to a data warehouse (Redshift).

Currently have over 50 internal active users of Looker.
  • I believe that among BI tools, Looker provides the best balance between flexibility and configurability for the data team, ease of deployment and support for dev ops and great user experience for the end users – consumers of data.
  • The data modeling layer, LookML proved to be extremely helpful for the Data team to define data models and abstract end users – data consumers – away from the complexity of underlying data sets.
  • Documentation is clear, comprehensive and easy to find.
  • Live chart support within the Looker interface is very helpful.
  • Powerful permission management system allows to provide access to multiple data sets to a big number of users without the risk of compromising security.
  • Very easy to deploy: is shipped as a standalone server Java application. Or even better: can be hosted by Looker company.
  • Add the ability to perform joins across physically distributed databases
Mode & Chartio require user to write SQL. Looker – Looker has very powerful data modeling layer – LookML that allows data engineers to abstract end users away from the complexity of underlying data (and SQL). End users can perform analysis by selecting dimensions, measures, pivots and filters very easily.

Domo performs a lot of "magic" under the hood that sometimes fails and is very hard to debug.

Looker does not store any data in itself and provides full transparency to both the user and the data engineer about the data processing.

Tableau lacks many sharing, dashboarding capabilities that Looker has, and again – lacks data modeling layer.
Supports all common SQL connectors including but not limited to Hive and Spark.
Does not support No-SQL
Sharing features include scheduling reports to be delivered by email, downloaded as PDF, bookmarked, published to a common space, exported as iframe etc.
Very well suited for modeling and exposing data of any data source with a SQL interface including but not limited to Hive and Spark.

Greatly reduces the burden on engineers by allowing business users to perform analysis, build visualizations and put together dashboards themselves.

Currently cannot handle other data interfaces, such as Splunk.

Looker Feature Ratings

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