Look & Learn: Building Queries for Cohort Analysis

Business users can drive engagement and improve retention by creating a cohort analysis in Looker. In this demo, we create a dataset starting with the date in which users signed up to a website. Then we use Looker to drill into the data, revealing what those users went on to order over the next six months. Equipped with this level of detail, business teams and data teams can discover patterns in user orders by month.

Previous Flipbook

Data Modeling in Looker

Quick iteration and reusability of metric calculations for powerful data exploration.

Next Video

Look & Learn: Intro to LookML

Lindsey Meyer, Support Analyst at Looker, takes us through some basics to begin writing LookML.

Explore and discover your data — start your free trial today.

Return to Home

Look & Learn: Building Queries for Cohort Analysis

Previous Flipbook

Next Video

Other content in this Stream

The focus of modern business intelligence has been self-service; pushing raw data into the hands of end users quickly with an accessible user interface so they can get their own answers fast. This has

The focus of modern business intelligence has been self-service; pushing data into the hands of end users more quickly with more accessible user interfaces so they can get answers fast and on their ow

Cohort Analysis is a great way to calculate various metrics in your organization such as customer lifetime value and retention analysis.

Looker Analyst, Chris Billet, runs through LookML filtering parameters on the explore level. Through these filtering expressions, you can specify the field you'd like to filter on for future queries.

Quick iteration and reusability of metric calculations for powerful data exploration.

Lindsey Meyer, Support Analyst at Looker, takes us through some basics to begin writing LookML.

Looker Founder and CTO Lloyd Tabb will introduce a major new component to the modeling layer that lets you build interesting and complex computational patterns.

New analytical tools such as Looker allow data analysts to speed up the dirty work around building data models—making it less painful to clean data, explore predictive factors, and evaluate results.

A key difference of LookML is that, unlike older approaches, it combines modeling, transformations, and derivations at the same layer (late-binding modeling). This allows vast amounts of data to be ca