Overview
What is Looker?
Looker is a BI application with an analytics-oriented application server that sits on top of relational data stores. It includes an end-user interface for exploring data, a reusable development paradigm for data discovery, and an API for supporting data in…
User experience on Looker
Look no further!
Looker: the essential tool for marketing analysts.
It's performance is better than it's name
A Dynamic And Customisable BI Tool Perfect For Semantic Layers
Not the most advanced option; great value for the price
Nice and easy to use solution!
Great reporting tool
A deeper look into Looker.
When it comes to data visualization, Looker is an excellent and flexible platform.
Looker: easy, quick, and very well integrated with Google Sheets.
Looker Studio web based report maker.
Invaluable and Intuitive Data Analysis and Visualization
The perfect data visualization tool for Google Suite users
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Customizable dashboards (92)8.787%
- Report sharing and collaboration (94)8.686%
- Drill-down analysis (91)8.282%
- Formatting capabilities (92)7.474%
Reviewer Pros & Cons
Pricing
What is Looker?
Looker is a BI application with an analytics-oriented application server that sits on top of relational data stores. It includes an end-user interface for exploring data, a reusable development paradigm for data discovery, and an API for supporting data in other systems.
Entry-level set up fee?
- Setup fee required
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
100 people also want pricing
Alternatives Pricing
What is SAP Crystal?
SAP Crystal is an analytics and reporting software solution for SMBs. SAP Crystal comprises Crystal Reports for pixel-perfect reporting, and SAP Crystal Server for automated distribution and self-service access to reports, dashboards and data exploration.
What is SAP Lumira Discovery?
SAP Lumira Discovery is SAP’s data visualization and discovery application. It facilitates data discovery, visualization, and analysis by assisting users with creation of dashboards, infographics, presentations, data facets, tag clouds, and more.
Product Demos
How To Use Looker as a Business User
Features
BI Standard Reporting
Standard reporting means pre-built or canned reports available to users without having to create them.
- 7.6Pixel Perfect reports(78) Ratings
Pixel Perfect reports are highly-formatted reports with graphics and ability to preview the report before printing.
- 8.7Customizable dashboards(92) Ratings
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
- 7.9Report Formatting Templates(78) Ratings
Ad-hoc Reporting
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- 8.2Drill-down analysis(91) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
- 7.4Formatting capabilities(92) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
- 8Integration with R or other statistical packages(37) Ratings
Integration with the open-source R predictive modeling environment.
- 8.6Report sharing and collaboration(94) Ratings
Report sharing and collaboration is the ability to easily share reports with others.
Report Output and Scheduling
Ability to schedule and manager report output.
- 8.5Publish to Web(74) Ratings
- 8.7Publish to PDF(80) Ratings
- 8.2Report Versioning(60) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
- 8.9Report Delivery Scheduling(80) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
Data Discovery and Visualization
Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.
- 8.1Pre-built visualization formats (heatmaps, scatter plots etc.)(89) Ratings
Pre-built visualization formats are canned visualization types that can be selected to visualize different kinds of data.
- 7.6Location Analytics / Geographic Visualization(78) Ratings
Location analytics is the visualization of geographical or spatial data.
- 4.6Predictive Analytics(6) Ratings
Predictive Analytics is the ability to build forecasting models based on existing data sets.
Access Control and Security
Access control means being able to determine who has access to which data.
- 8.9Multi-User Support (named login)(85) Ratings
Named model access means that users have access based on name and password.
- 8.3Role-Based Security Model(78) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
- 8.6Multiple Access Permission Levels (Create, Read, Delete)(85) Ratings
Multiple access permission levels means that different levels of users have different rights.
- 8.4Report-Level Access Control(26) Ratings
Report-level access control means that the type of report determines who has access to it.
Mobile Capabilities
Support for mobile devices like smartphones and tablets.
- 6.7Responsive Design for Web Access(63) Ratings
Web design aimed at producing easy-to-read sites across a range of different devices.
- 5Mobile Application(1) Ratings
A dedicated app for iOS and/or Android.
- 6.5Dashboard / Report / Visualization Interactivity on Mobile(58) Ratings
In-app dashboard reports and data visualization.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Looker?
Looker vs. Looker Studio
Looker Studio is a part of Google's Looker Suite for business intelligence. Looker Studio is a self-serve BI solution where less technical users can create charts and reports, while Looker is a complete, enterprise BI platform, where technical users can build complex models that consider every aspect of the business. Looker Studio offers both free and pro versions, while Looker is not available for free. Looker and Looker Studio integrate with each other to support both types of analysis at businesses.
Looker Features
BI Platform Features
- Supported: Administration via Web Interface
- Supported: Live Connection to External Data
- Supported: In-memory data model
- Supported: Multi-Data Source Reporting (Blending)
- Supported: Data warehouse / dictionary layer
Supported Data Sources Features
- Supported: Oracle
- Supported: MS SQL Server
- Supported: IBM DB2
- Supported: Postgres
- Supported: MySQL
- Supported: Cloudera Hadoop
- Supported: Hortonworks Hadoop
- Supported: EMC Greenplum
- Supported: IBM Netezza
- Supported: HP Vertica
- Supported: ParAccel
- Supported: SAP Hana
- Supported: Teradata
- Supported: Sage 500
- Supported: SAP
BI Standard Reporting Features
- Supported: Pixel Perfect reports
- Supported: Customizable dashboards
- Supported: Report Formatting Templates
Ad-hoc Reporting Features
- Supported: Drill-down analysis
- Supported: Formatting capabilities
- Supported: Integration with R or other statistical packages
- Supported: Report sharing and collaboration
Report Output and Scheduling Features
- Supported: Publish to Web
- Supported: Publish to PDF
- Supported: Output Raw Supporting Data
- Supported: Report Versioning
- Supported: Report Delivery Scheduling
Data Discovery and Visualization Features
- Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)
- Supported: Location Analytics / Geographic Visualization
- Supported: Support for Machine Learning models
- Supported: Integration with R or other statistical packages
Access Control and Security Features
- Supported: Multi-User Support (named login)
- Supported: Role-Based Security Model
- Supported: Multiple Access Permission Levels (Create, Read, Delete)
- Supported: Report-Level Access Control
- Supported: Table-Level Access Control (BI-layer)
- Supported: Field-Level Access Control (BI-layer)
Mobile Capabilities Features
- Supported: Responsive Design for Web Access
- Supported: Dashboard / Report / Visualization Interactivity on Mobile
Looker Screenshots
Looker Video
Looker Competitors
Looker Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, Mac |
Mobile Application | No |
Supported Countries | United States, Canada, United Kingdom, Mexico, Germany, France, Australia, New Zealand, South Africa, Brazil |
Supported Languages | English |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(376)Attribute Ratings
Reviews
(1-25 of 70)User experience on Looker
- data analytics for huge data from multiple factories.
- Integration with other software for data transfer for analysis purpose
- variety of dashboards with interactive visualizations, filters helps us to get great insights.
- Support team takes time to resolve issue.
- Learning cost is high
- training materials and documentation is not easily available for learning
Looker software requires experienced personnel to handle large amounts of data, which makes it less user-friendly.
- Semantic layer
- Dynamic visualisations
- Intuitive design
- Can be slow at times
- Some features locked behind pricing tiers
- Semantic layer requires additional knowledge to use to full extent
Not the most advanced option; great value for the price
- Formatting
- Querying
- Security
- Graphics
- Visual builder
- User Interface
- Training and Documentation
- Video tutorials
- Support
- Offers numerous data options and scalability.
- Can increase productivity and efficiency with greater cost control.
- Can easily customize your data.
- Data migrating or uploading time could be reduced.
- Managing large number of users can easily become very tough to handle.
- No other downside.
- It is very easy to start a new dashboard and configure what you want to display by just selecting/dragging from the list of available columns.
- It is intuitive, mainly if you use other Google services like Google Sheets.
- The look and feel is modern and nice.
- It it very useful to have an immediate visual overview of the data in a spreadsheet.
- I’d like a bit more personalization, particularly in the “Style” section (e.g., fonts, paragraph settings, the ability to map the axis labels to shorter names…).
- Performance can be quite slow when there are many graphs on one page, even making the page unresponsive sometimes.
- I’d love to be able to easily embed a dashboard in the Google Sheets it comes from (without injecting code to embed the HTML).
Looker Studio web based report maker.
- Connect to multiple data sources.
- Automated data aggregations.
- Automated data segmentation.
- With larger data sets it slows down.
- Dashboards and Reports
- Logical Separation of Data Fields and Measures
- Tailored Report and Data Delivery
- Customizing Data Schedule
- Complex Query Building
- Lack of Documentation
Super Tool to intelligently manage Data Representation!!
- Data Visualization
- Sharing of Reports
- Sync with multiple data points
- Content Management
- Robust nature
- Need more developer options to user
A very good BI software with a soft learning curve
- Real time data aggregation
- Very large data source connection pool
- Querying data can be as simple as a filter, up to LookML
- The default user interface is very spartan
- If you don't use BigQuery, some queries can be slow
- LookML can be daunting
Looker - Flexible but Not Intuitive
- Looker has high bandwidth and can process a lot of information quickly
- Looker is relatively easy to understand as a non technical staff
- Looks provides a lot of flexibility to integrate with our APIs
- Looker isn't build friendly with non engineering staff
- Looker crashes occasionally
- Looker could have a better looking UI
A fantastic solution for small and medium businesses to quickly get reporting up and customized to your liking
- Automation
- API coverage
- Integration of many different data sources
- Customization
- Ease of use
- Data uptime (portions go out frequently)
- Help articles and resources are lacking
- Learning curve is steep
Good product, a bit pricey!
- Visualization
- Version Control.
- Organization
- Customer Support.
- Error Handling/Reporting.
- Pricing
Great tool for advanced users.
- Perfect integration into other dashboarding platforms.
- Pulls data from multiple sources.
- Integrates with our Hubspot CRM.
- Finicky user interface.
- Pretty extensive learning curve.
- Would love to see a seamless integration of UA and GA4 together.
Looker Review.
- Simple interface.
- Helps users with no SQL experience.
- Easy to integrate.
- Scalability for large data.
- Time for import large amount of data.
Looker: Cheap for what it delivers!
- Visually good graphical representations
- Data combination tool
- Native data integration with google products (ads, analytics, etc)
- Fully real-time collaborative
- Lacks a native data wrangling tool
- few options for visuals customization
- few native connectors with external sources
- Excel Online Connector
Using Looker as explorer for the last year
- Integration with some solutions
- Easy data extractation
- Easy to build visuals
- It is too difficult for simple use cases
- User experience is not intuitive enough for explorers
- Integrations with other visualization tools from other companies can improve
- Easy to set up.
- Shareable and end-user ease of use.
- Data joining is a particular highlight for tagging up URLs.
- Plug and play in many cases.
- Menus and navigation for set up can be a bit confusing for first time users.
- Add the ability to manually change the canvas size rather than setting it in pixels, which is counterintuitive.
Looker is the report engine for you!
- Granular reporting.
- Ease of building.
- Ease of access.
- Needs training to be a builder.
- Needs training to be a user.
- Can get visually cluttered.
Great BI tool for data aggregation
Besides, most legacy systems within our organization required the users to have SQL hands on experience, which limited the number of people who could actually access and use the data.
- The response speed of the dashboards
- Seamless integration with Slack/Salesforce/Github etc.
- Visualizing the KPI metrics of multiple divisions in a unified dashboard
- Still room for improvement in terms of user interface
- Not so much room the customization
- Lack of documentation of some system errors
It is also a good solution where employees used to use Excel for data analysis and want to switch to a more powerful solution without the need to learn SQL.
Deep dive into Looker
The business problems Looker helps to address
- Users with no experience of SQL or in particular, any coding or knowledge of machine language, extract data from different tables and retrieve the data needed by the user
- Creating and extracting data from customer/adhoch reports is super simple and user-friendly
- The explore view of Looker saves the day - Creating adhoch reports is super simple
- Slicing, dicing and filtering data based on multiple parameters is super easy rather than writing complex SQL queries
- Adding fields, removing fields, changing layouts, minor alterations and joining tables to get the desired data is easier than ever
- People can save their own views for the next time - same base data can have N number of views based on users and fields
- Looker is less graphical or pictorial which makes it less attractive
- Consumes a lot of memory when there are multiple rows and columns, impacts performance too
- At times when we download huge chunks of raw data from Looker dashbords, the time taken to prepare the file is enormous - The user fails to understand if Looker has frozen or if the data is getting prepared in the background for downloading. In turn, user ends up triggering multiple downloads
Very useful when the data is scattered across tables and a user wishes to co-relate all and extract the results.
Easy to have data in dynamic and also get a current snapshot.
Memory/performance issues come in when there is a lot of data.
Looker is a fantastic BI tool that scales with the business
- Able to connect to multiple different data sources
- Easy data filtering and navigation
- Clean visualizations and easy to download the data
- Looker lacks the ability to provide 'and' operators when filtering. Only 'or' is provided
- Looker lacks the ability to auto create a data dictionary for defined dimensions and measures within the software. A person must access the API to create one, which is rather inconvenient
- Looker lacks the ability to display descriptions on the Lookml Dashboard view, which is a list of dashboards where descriptions are not displayed
Looker's great if you're looking for a customizable solution for making data available to your team
- Customizing your build -- Fields and measures can represent whatever you want it to.
- Transparency -- Everything is translated to SQL in real-time so you know what's going on in the background.
- Innovation -- There's a monthly update where new features are regularly released.
- User Management and Sharing Data could be a little easier. Your entire model needs to be built with user permissions in mind.
- It's not quite as plug 'n play as the alternatives, but that's okay.
- Visualizations could be improved for large amounts of data.
- Date reporting could be improved. Date, week, hour, month, etc are separate fields...you can't quickly shift between them in reporting/visualizations.
Analyze your data efficiently with Looker
- The UI is simple and easy to understand.
- Online training materials is sufficient to work on the solution.
- Helps in keeping the data organized.
- Able to analyze data and visualize it.
- Easy to integrate with data sources.
- Addition of advanced level of visualization
- Must be scalable when you have a large amount of data.
- Data uploading time could be better.
- Wide options for data integration should be added.
It helps us to enable the target users to give more information about the data, if they are using other legacy system, then they will found that how easy is to analyze data using Looker.
Overall a good and reliable solution.
Looker for our Business Operations team
- Visuals are amazing
- UI is easy to use
- Advanced formula creation seems to lack in comparison to other tools
- The core-visibility lets you monitor your entire workflow along with live data.
- The user interface makes the task of figuring out the data easy.
- Find the relevant data that your business needs.
- Build models on the fly.
- Customer service could be more responsive.
- Platform can be expensive depending on the level of your business.