Data discovery, exploration
and business intelligence, all
on any device.

The Looker Product Overview
2 minutes
Watch the Video

Product

Looker provides a powerful new way to analyze your data, easily: connect to your data, describe what it means, and explore it as a team.

Connect

Looker turns disparate data into one thing: your data.

Before you can visualize, share or understand, you have to connect. This is where we first start to make a difference. Looker connects live to your analytics data store so you can leave your data where it resides. Because the most actionable data is always the data you have access to in it's entirety, in real time.

 

Supports the data sources modern businesses run on.

Looker accesses live, real-time data on any SQL analytics database or data warehouse. Platform tools allow you to create and manage multiple connections from a single interface.

Connects directly to your entire data source.

Work with your data as it is, wherever it lives. By connecting directly to your entire data source rather than importing only part of it, Looker gives you unmatched fidelity — you can be certain you're always working with the complete picture, drilling into anything of interest, all the way down to the source.

 

Easy to deploy, in the office or the cloud.

The entire Looker platform can be distributed on our infrastructure or yours—whether that's managed on-premise or in the cloud. It's packaged in an easy to distribute fashion, so implementation is fast and requires very few resources.

 

A custom experience for any organization

At its heart Looker is analytics technology built as a web application server. That means you can build your company a completely custom experience, from the domain they use to log in to charts sent to your custom internal applications via the API.

An expert data analyst with every purchase

We're absolutely focused on your success - not just with using the product, but actually making actionable business decisions from data analysis. That's why we've included a simple, but effective, feature in Looker - live chat with a dedicated support analyst. At the click of a button, our customers can ask us any question, getting direct help with the product, but also another set of eyes on the problems they face as a business.

 
Describe

Flexible data modeling that's as powerful as SQL and built to be easy.

We've built our own data modeling language called LookML that's easy to use and understand, completely reusable, and makes your organization more powerful with SQL.

LookML turns disparate data sources into a single source of truth.

LookML models create a single version of truth for your organization, so your team can work with profit and subscribers instead of obscure SQL strings. Anyone can create multiple models for any number of data sources, sharing elements between them to build on the creativity of others. Because everything can be version-controlled, you can experiment with new queries and objects and easily revert your changes anytime.

It's a data model, not a
black box.

As you explore your data you'll always find new things you'd like to do with it, and Looker is meant to be iterative. Once set up you can change, fine tune and create new elements of the data model as you go without changing how the data is stored in the underlying database. That's why Looker was built for the modern development environment, with full authentication and permissions controls for each user, and revision control with Git and GitHub.

 
Here's what separating customers into tiers based on the days since they joined takes in LookML...
 
  - dimension: days_as_customer_tiered
    type: tier
    tiers: [1,3,7,14,30,60,90,180,365]
    sql: ${days_as_customer}
...and in raw SQL.
 
CASE
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 1 THEN 'T00 (-inf,1)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 1 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 3 THEN 'T01 [1,3)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 3 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 7 THEN 'T02 [3,7)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 7 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 14 THEN 'T03 [7,14)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 14 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 30 THEN 'T04 [14,30)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 30 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 60 THEN 'T05 [30,60)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 60 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 90 THEN 'T06 [60,90)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 90 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 180 THEN 'T07 [90,180)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 180 AND (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) < 365 THEN 'T08 [180,365)'
WHEN (DATEDIFF('day', users_orders_facts.first_order, users_orders_facts.latest_order)+1) >= 365 THEN 'T09 [365,inf)'
ELSE 'TXX Undefined'
END AS "users_orders_facts.days_as_customer_tiered"
 
I love LookML. It's the single most innovative part of Looker. It makes BI so much more fun - it's absolutely painless compared to the BI tools I've used in the past. LookML lets you define things through the front-end; you just make the change then the data is available instantly. In the past I'd have to make a change and then wait while cubes were rebuilding.
Sandeep Kamath, Marketing & BI
Explore

Discover data exploration built for the internet age.

Looker is a data exploration platform that works just like the web. Quickly search your data, build reports, dashboards and email alerts, and collaborate with your team all in the browser - any browser, on any modern device.

Exploring with Looker

When you ask a question of your data, you never know where it will lead. Looker provides all of the tools you need to go there. It starts with the connection - you're actually working with the database, so you're already exploring the total true picture. Drag and drop measures and dimensions to sort the data you want, filter, drill down and pivot to refine the results, and quickly flip through visualization types to arrive at the best presentation. When you've found something you'd like to share you can easily do so by copying the URL or scheduling an email.

 
 

Any browser, anywhere

Looker works on the device and OS of your choice; phone, tablet or computer, Windows, Mac or Linux. That's because it works over a web browser, and once connected to your data there's nothing to install for your users.

 

Flexible reporting

Start building a report with a single search, then share the results as a URL, create visualizations and combine them into robust dashboards, or schedule email alerts to any address.

 

Essential Visualizations

Looker provides an always-growing list of visualization types that can be explored on their own or in dashboards to help you showcase and understand your data. Because you're connected to the source data when working with Looker, each chart is automatically capable of drilling down as far as you'd like to go.

Cooperative

We believe collaboration leads to a more creative solution, and that's why Looker was built to be a collaborative environment by nature. Every search run in Looker becomes its own dynamic web page, letting users share a URL at any point in the exploration process. Because of its easy sharing nature, Looker becomes the most valuable when many teams are using it with many different data sources - reusing data elements across models to build a larger single view of your business.

Built for Developers Too

There's even a seamless integration with Google Docs and Sheets, a robust API for developers, an additional package for R developers, and a Ruby SDK to help you build custom apps, so you can bring query results and charts from Looker into your existing infrastructure.