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
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
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.
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.