Looker - bobbae/gcp GitHub Wiki

Looker lets you describe their data using a modeling language called LookML.

LookML tells Looker how to query data, so everyone in the organization can create easy-to-read reports and dashboards to explore patterns of data. Looker offers additional features for creating custom data applications and experiences.

https://info.looker.com/youtube-learning-looker-tutorials-and-product-features

https://www.youtube.com/channel/UC1AIN4pUKbLzzMg8RKprtgQ

https://www.youtube.com/watch?v=XG4ytmgqSpU

Looker's platform works with transactional databases like Oracle and MySQL as well as analytical datastores like BigQuery, Snowflake, Redshift, and more. Looker lets you create consistent data models on top of all your data with speed and accuracy. Looker offers a unified surface to access all of an organization's data.

https://looker.com/solutions/google-bigquery

Looker gives you the tools to power a multitude of data experiences, from modern business intelligence and embedded analytics to workflow integrations and custom data apps.

https://cloud.google.com/looker

Looker is a data aggregation and dashboard tool. It was built from the ground up to integrate a variety of data sources and allow for the flexibility to aggregate and transform data with LookML.

https://youtu.be/fbgva493gb8

Looker also allows you to send data to other platforms through an Application Programming Interface (API) and develop separate data services and products, proving there is much more you can do with the platform than just develop dashboards.

https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts

Looker and database connection

https://docs.looker.com/setup-and-management/connecting-to-db

Looker for data consumers

https://training.looker.com/looker-for-data-consumers

Looker concepts

https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts

Projects

https://docs.looker.com/data-modeling/getting-started/how-project-works

Models

https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts#model

Explores

https://docs.looker.com/exploring-data/exploring-data

https://info.looker.com/youtube-learning-looker-tutorials-and-product-features/building-explores

Join

https://docs.looker.com/data-modeling/learning-lookml/working-with-joins

https://docs.looker.com/reference/explore-params/sql_on

Views

https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts#view

https://docs.looker.com/reference/view-reference

Drilling

https://help.looker.com/hc/en-us/articles/360023589613--More-powerful-data-drilling

Dimensions and Measures

https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts

https://info.looker.com/youtube-learning-looker-tutorials-and-product-features/creating-dimensions-and-measures

Aggregate awareness

https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness

relationship

https://docs.looker.com/reference/explore-params/relationship

count vs count_distinct

https://help.looker.com/hc/en-us/articles/360023626514-The-Difference-Between-count-and-count-distinct-Measure-Types

measure types

https://docs.looker.com/reference/field-reference/measure-type-reference

Symmetric aggregates

https://help.looker.com/hc/en-us/articles/360023722974-A-Simple-Explanation-of-Symmetric-Aggregates-or-Why-On-Earth-Does-My-SQL-Look-Like-That-

LookML

LookML โ€‹is a language for describing dimensions, aggregates, calculations, and data relationships in a SQL database.

Filtering Explores with LookML

https://www.cloudskillsboost.google/focuses/18477?parent=catalog

filter expressions

https://docs.looker.com/reference/filter-expressions

Constants

https://docs.looker.com/reference/manifest-params/constant

Parameters

https://docs.looker.com/reference/field-params/parameter

Derived Tables

https://docs.looker.com/data-modeling/learning-lookml/derived-tables

Derived columns and Native Derived Tables

https://docs.looker.com/data-modeling/learning-lookml/creating-ndts

PDTs

https://docs.looker.com/data-modeling/learning-lookml/derived-tables#persistent_derived_table

Caching and Datagroups

https://docs.looker.com/data-modeling/learning-lookml/caching

datagroups

https://docs.looker.com/reference/model-params/datagroup

persist_with

https://docs.looker.com/reference/explore-params/persist_with

persist_for

https://docs.looker.com/reference/explore-params/persist_for-for-explore

Security and Authentication

https://docs.looker.com/admin-options/security

Roles

https://docs.looker.com/admin-options/settings/roles

Content access

https://docs.looker.com/admin-options/settings/content-access

Access filter

https://docs.looker.com/reference/explore-params/access_filter

User attributes

https://docs.looker.com/admin-options/settings/user-attributes

Access grants

https://docs.looker.com/reference/model-params/access_grant

Groups

https://docs.looker.com/admin-options/settings/groups

System Activity

https://docs.looker.com/admin-options/system-activity

Clustering

https://docs.looker.com/setup-and-management/tutorials/clustering

Filtering and Limiting

https://docs.looker.com/exploring-data/filtering-and-limiting

Labels

Field labels

https://docs.looker.com/reference/field-params/label-for-field

View labels

https://docs.looker.com/reference/view-params/label

Model labels

https://docs.looker.com/reference/model-params/label-for-model

Extends

https://docs.looker.com/data-modeling/learning-lookml/extends

Validation

https://docs.looker.com/data-modeling/getting-started/look-validation

Optimizing

https://help.looker.com/hc/en-us/articles/360001847227-Best-Practice-Optimize-Looker-Performance

General Admin settings

https://docs.looker.com/admin-options/settings/general

Multi stage development framework

https://help.looker.com/hc/en-us/articles/360033944133-Looker-Multistage-Development-Framework-Dev-QA-Prod-

Liquid templating

https://docs.looker.com/data-modeling/learning-lookml/templated-filters

https://docs.looker.com/reference/liquid-variables

Refinements

https://docs.looker.com/data-modeling/learning-lookml/refinements

Learning Looker

https://connect.looker.com/

https://www.cloudskillsboost.google/quests/182

https://hevodata.com/learn/understanding-looker-ml/

https://github.com/sathishvj/awesome-gcp-certifications/blob/master/looker-lookml-developer.md

Looker Business Intelligence Learning Path

https://googlecourses.qwiklabs.com/course_templates/253

Looker Delivery verification requirements

https://storage.googleapis.com/looker-partner-enablement/How%20to%20Get%20Looker%20Delivery%20Verified.pdf

LookML Developer certification

https://cloud.google.com/certification/guides/lookml-developer

Looker learning topics

https://help.looker.com/

Learning LookML

https://docs.looker.com/data-modeling/learning-lookml

Database to Dashboard

https://www.youtube.com/watch?v=HBgJWCBOOZg

Dimension, filter, and parameter types

https://docs.looker.com/reference/field-reference/dimension-type-reference

Building Reports in Looker

Looker for data explorers.

https://training.looker.com/looker-for-data-explorers

Solving business problems with data

https://cloud.google.com/blog/products/data-analytics/looker-solutions-solving-business-problems-with-data

Training business users

https://training.looker.com/training-business-users

Visualization example

https://medium.com/badal-io/gcp-iiot-visualization-and-analytics-in-looker-for-oil-gas-systems-90b9b8526976

Looker, Building Explores:

https://training.looker.com/building-explores-users-will-love

Looker, Dashboards

https://training.looker.com/designing-great-dashboards

Recorded Training

https://training.looker.com/series/recorded-webinars

Performance Best Practice

https://help.looker.com/hc/en-us/articles/360001847227-Best-Practice-Optimize-Looker-Performance

Forecasting

https://blog.rittmananalytics.com/adding-forecasting-to-your-looker-report-and-dashboards-833670e569d9

Looker Business Analyst certification

https://cloud.google.com/certification/looker-ba

Extension Framework

The Looker extension framework is a development framework that significantly reduces the effort and complexity of building custom JavaScript data applications and tools.

https://developers.looker.com/extensions/getting-started

Looker Extension SDK

https://www.npmjs.com/package/@looker/extension-sdk

Public API

https://docs.looker.com/reference/api-and-integration/api-getting-started

React UI Components

A library of pre-built React UI components you can use in your extensions.

https://developers.looker.com/components/develop

Embed SDK

A library you can use to embed dashboards, Looks, and Explores in your extension.

https://developers.looker.com/embed/embed-sdk

create-looker-extension Tool

This utility helps you rapidly create new Looker Extension Framework extensions.

https://github.com/looker-open-source/create-looker-extension

Looker Components

https://developers.looker.com/components/develop

https://cloud.google.com/blog/topics/developers-practitioners/going-beyond-dashboard-paradigm-looker-components

Universal Semantic Model

https://cloud.google.com/blog/products/data-analytics/lookers-universal-semantic-model

Looker and Cloud composer

https://cloud.google.com/blog/products/data-analytics/looker-cloud-operators-for-apache-airflow-available-in-cloud-composer

Using the Looker Marketplace

The Looker Marketplace is a central location for finding, deploying, and managing many types of Looker content, such as Looker Blocks, applications, visualizations, and plug-ins.

https://docs.looker.com/data-modeling/marketplace

https://cloud.google.com/blog/products/data-analytics/looker-public-marketplace

Blocks

https://docs.looker.com/data-modeling/looker-blocks

Customizing Looker Marketplace Blocks

https://docs.looker.com/data-modeling/marketplace/customize-blocks

Available Blocks

https://docs.looker.com/data-modeling/looker-blocks#available_blocks

Directory

https://looker.com/platform/directory/home

BigQueryML and Looker

https://cloud.google.com/blog/products/data-analytics/explainable-ai-using-bigquery-machine-learning-and-looker

Open source

https://github.com/looker-open-source

gzr

https://github.com/looker-open-source/gzr

henry

https://github.com/looker-open-source/henry

malloy

https://github.com/looker-open-source/malloy

https://looker-open-source.github.io/malloy/documentation/language/basic.html

https://medium.com/@michaeltoy/designing-malloy-0-introduction-88b8809d75d0

Comparisons

Looker vs Tableau

https://looker.com/compare/looker-vs-tableau

Looker vs Power BI

https://looker.com/compare/looker-vs-power-bi

Looker and Data Studio

Google Data Studio is a visualization and reporting tool, and an integral part of Google Marketing Platform. It enables an enhanced approach to decision-making, allowing your entire organization to readily access and use marketing insights.

https://infotrust.com/articles/google-data-studio-looker-comparison/

Metabase

https://www.metabase.com/

Trevor.io

https://trevor.io

LinceBI

https://www.lincebi.com/

Talend

https://www.talend.com/

Sisence

https://www.sisense.com/

The Data Modeling Layer

https://www.holistics.io/blog/the-data-modeling-layer/

dbt

dbt is a transformation workflow and data pipeline tool that lets teams collaboratively deploy analytics code following practices like modularity, portability, CI/CD, and documentation.

https://www.getdbt.com/docs/

Serverless dbt on GCP

https://robertsahlin.com/serverless-dbt-on-google-cloud-platform/

Spectacles

https://github.com/spectacles-ci/spectacles

Looker Performance

https://help.looker.com/hc/en-us/articles/360001847227-Best-Practice-Optimize-Looker-Performance

Examples

Python examples

Python Looker source code example that use SDKs to communicate with the Looker API.

https://cloud.google.com/blog/topics/developers-practitioners/building-looker-made-easier-extension-framework

Looker API Examples

https://training.looker.com/series/recorded-webinars/the-looker-api

Hospital Readmission Rates

https://cloud.google.com/blog/topics/healthcare-life-sciences/looker-helps-predict-hospital-readmission-rates-with-google-cloud

Self-hosted Looker installation on GCP

https://medium.com/google-cloud/looker-self-hosted-installation-on-gcp-7e6a5050784a

Customer hosted Looker installation on GCP

https://medium.com/@shivam_m7/customer-hosted-looker-installation-on-google-cloud-platform-vm-9cb19221a572

Qwiklabs

https://www.qwiklabs.com/catalog?keywords=looker

Working with Looker content

https://looker.qwiklabs.com/focuses/18346?parent=catalog

Creating dimensions

https://looker.qwiklabs.com/focuses/18345?parent=catalog

Creating measures

https://looker.qwiklabs.com/focuses/18347?parent=catalog

Building Explores

https://looker.qwiklabs.com/focuses/18348?parent=catalog

Modifying Explorers

https://looker.qwiklabs.com/focuses/18349?parent=catalog

Filtering Explorers

https://looker.qwiklabs.com/focuses/18350?parent=catalog

Exploring Data with Looker

https://www.qwiklabs.com/quests/165