Looker – is an American developer of BI solutions based on SQL.

Company was founded in 2012 by two professionals of this industry. Its products on the business intelligence platform have become the first for scalable or MPP-based SQL databases, including Netezza, Amazon Redshift, Teradata, Google BigQuery and HP Vertica.

Looker customers are more than 750 companies around the world: Asana, Avant, Carbonite, Dollar Shave Club, Etsy, Hubspot, Intel Security, Kickstarter, Kiva, Kohler, MIT Technology Review, Sony, Upworthy, Warby Parker. Looker is used in such industries as finance, retail, technology, marketing, gaming and media.

In 2017 Looker debuted as Strong Performer in the Forrester report.

Looker is completely SQL based solution. It can be deployed both in the cloud on the developer side, and on-premise/ in the cloud on the client side. There is no standard price list: each price offer is issued based on the number of users, number of connections to databases and the scale of deployment

Capabilities of the embedded analytics platform

For clients

For developers

Flexible dashboards and visualizations

Modern level of data modeling

Research of data in Ad hoc mode

Git version-control

Creating of content and data loading

RESTful API for access to data

Powerful scheduling and notification capabilities

Configurable database connections

Options for uploading data to selected tools

Single sign-on and programmable resolutions

Organized data flows

Ability to work white-label

Why Looker?

One-time metric setting
Looker once forms SQL queries to determine the desired business metrics (lifetime customer value or conversion rate) and table connections. In the future, analysts use a simple but powerful modeling language LookML to answer all the questions that arise.

Providing meaning to data
Create easily readable reports and detailed dashboards that allow you to “dig” further and continue research. Exchange visualizations at any time from any device.

Usage of modern technologies
Today’s databases requests huge data assets with great ease. Due to the fact that Looker directly connects to the database, the user can enjoy this advantage. No data extraction. No additional software. And there are no restrictions on the scale of research.

Building a data culture
When the whole company has reliable, authoritative answers – and analysts cease to be a “bottleneck” – each employee can get answers to their questions and make more justified decisions.

How does Looker work?

STEP 1

Connect Looker to any relational database, such as Amazon Redshift or Google BigQuery.

STEP 3

If necessary, make corrections to the received model to reflect the unique indicators of your company and business logic.

STEP 2

Looker automatically generates a data model from your schema.

STEP 4

Work out the basics: KPI toolbars and department reports. After this, give access to colleagues.

FINAL STEP

Encourage colleagues to use all the functions of the provided environment, knowing that Looker will turn them into an accurate, executable SQL.