Looker is a relatively new browser-based, ad hoc query, reporting, and dashboard product that runs on-premise or in the cloud. Purpose-built to leverage the next generation of analytic databases and native SQL code, Looker doesn't move and store data. Rather, it pushes all queries to the database, allowing business analysts to query any data without limit and build interactive dashboards for casual users.
The strength of the Looker product is its modeling layer that automatically generates a data model based on underlying data and then enables data analysts to use a SQL-like scripting language called LookML to create custom logic and extend the model to meet user requirements.