Looker lets organizations access, control, describe, explore, and see their data.


Connects directly to your entire data source, whether that's in the office or the cloud.

Looker works with your data as it is, wherever it lives, connecting directly to your entire data source rather than importing only part of it. You'll always be working with the complete picture, and can drill into anything of interest, all the way down to the source.

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

Unlock massive datasets.

The new generation of analytic databases are built to power the processing of massive amounts of data, and that's exactly what Looker lets them do. Looker was built from the ground up to enable Big Data processing, leveraging dialect-specific SQL and analytic functions within backend databases to enable the serious heavy-lifting required to analyze all of the datasets in your organization.

Work with your database, not against it.

Looker is 100% in-database, on-premise or in the cloud. It builds queries that are sent back to your database and returned as results. You never have to duplicate or warehouse your data, and your results set is always as real-time as your data source.

Why connect your data to Looker?

  • Zero-lag access to data. Connect directly to your data source where it resides for results that are as up-to-date as your data.

  • No limits. Looker isn’t bound by how much data you put through it, ensuring you’ll always be able to explore the whole picture.

  • Personalized setup and support. Every free trial starts with us helping you connect to and model your data.

  • No uploading, warehousing, or indexing. By making a direct connection to your data source, you avoid the hassles of unnecessary warehousing.

  • Deploy anywhere. Looker can be run on our (or your) servers in the cloud or on-premise, behind the firewall. Whatever’s best for your team, Looker does.

  • Works in any browser, anywhere. Access your Looker instance through any modern browser, on any device, with zero software to install.

  • Personalized access points. Because Looker is, at its heart, a web server, you can set it up on any custom domain, like looker.yourcompany.com.

Use Looker's powerful data modeling language to build truly self-service data experiences.

LookML is a easy-to-use modeling language for encapsulating business logic, defining important metrics once and then reusing them throughout the model. It provides an agile data environment where your data keeps up with your ever-evolving business.

Abstract the essential business logic once, then reference it within other dimensions and measures for quick, rapid iteration of data exploration while also ensuring the accuracy of the SQL that’s generated underneath.

Create a single source of truth.

LookML models are the backbone of Looker, providing a platform where you define key metrics once, in one place, so people from across your organization utilize those defined measures and dimensions in useful, meaningful, and often previously-unthought ways.

Transform at query time and ditch the ETL process.

Unlike older approaches, LookML combines modeling, transformations and derivations at the same layer, on demand (also known as late-binding modeling). This allows vast amounts of data to be captured in relatively inexpensive databases, and derivations and transformations to occur much closer to, or at, query time.

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

LookML is meant to be iterative: you can create, change and fine-tune elements of the model as you go, without impacting the underlying database. Better still, you can let the rest of the team experiment with model changes on their own, since model revision is always controlled through git.

Why work with LookML?

  • Track changes from across your organization. Looker's integration with Git lets you roll back and review changes to the model anytime, for any user.

  • Transform your data when you ask a question, not before. Edit Looker’s lightweight modeling layer when you’d like to make a change, and generally do what you want, when you want, without waiting for someone else to change the ETL.

  • LookML gets everyone on your team talking about the same thing.Complex queries and calculations are easily reusable by anyone on your team at anytime, putting everyone in the business on the same page.

  • All the intelligence of your best data analysts. Because you can reuse, tweak and utilize work done by others, your whole organization can leverage the work done by your data team, So analysts can spend less time writing SQL and more time innovating.

  • Extensibile and reusable. LookML reinvents the idea of SQL reusability. It's an extensible model that separates structure from content and represents your data consistently across questions, reports, and visualizations. Models can easily change with your business and be exposed to users through Looker's intuitive web UI or to other applications through a RESTful API and set of integration points.

"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,
Senior Manager of Analytics

Search and explore through your data, build dashboards and reports, and share everything you find easily and quickly.

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. Select 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 saving it to a dashboard, copying the URL or scheduling an email.

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.

Flexible.

Start building a Look 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.

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.


Why explore your data in Looker?

  • Create queries without having to write them. Browse measures and dimensions, quickly select from filters, and refine selections all in point-and-click.

  • Match your data to your KPIs. Browse measures and dimensions, quickly select from filters, and refine selections all in point-and-click.

  • Dashboards that anyone can build. It's easy to add a chart to any dashboard from either a Look or an exploration.

  • Dashboards that work on any device. Because Looker was built for the web, you can review the latest numbers from the device of your choice, from anywhere in the world.

  • Fully customizable charts, graphs and tables. Any visualization can be refined to a near-infinite degree through a series of simple controls for axis labels, colors, scale, etc.

  • Format values once and for all. Utilizing LookML, you'll be able to set currency, percentage displays and more, always seeing the right data in the right format when working with it.

  • Create calculated metrics and reuse them anytime. LookML lets you build calculations, from the simple to the complex, and re-use them in queries and charts in language that's easy to use, and to understand.

  • Unfettered exploration. Looker users aren't restricted to pre-built dashboards or views. Once given access to a data source they can explore through it in its entirety, as creatively as they'd like.

  • Secure Access. Looker supports third-party authentication via LDAP and Google Apps, and multi-factor authentication in the method of your choice.

  • Track changes on the model and the dashboard. Let your team explore data freely, without having to worry about anything breaking. Using git you can version-control, create staging and production instances, and roll back anytime.

  • The most data-per-screen. Charts on the Looker dashboard responsively scale and realign themselves, giving you the best view for your device.

  • Download any view or visualization. Once you've found the data you're after, you can easily download it as a CSV, JSON or TXT file.

  • Embed BI in your app. Have a tried-and-trusted internal reporting app you're looking to get data or visualizations into? Looker can do that too.

  • Schedule any query. When you're exploring data, each change you make results in a new look that can easily be scheduled to run anytime.

Support

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.

More on our Analyst Team