Advanced Analysis with Derived Tables

Advanced Analysis with Derived Tables

Gain the flexibility to restructure your data to do interesting things like cohort and retention analysis, sessionalize event data, and calculate the average lifetime value of a customer.

About this course

Have you ever wished for the flexibility to restructure your data to do interesting things like cohort and retention analysis, sessionalize event data, and calculate the average lifetime value of a customer?

With derived tables, you can create new tables and data sets in Looker that don’t exist within your underlying database. That means you can leverage complex SQL queries to solve for challenging questions like, “At what point in a repeat customer’s lifetime are they spending the most money?”

Come learn about some of the advanced analytical patterns that you can model through the use of derived tables.

Curriculum

  • Webinar Recording (55:00)
  • Frequently Asked Questions

About this course

Have you ever wished for the flexibility to restructure your data to do interesting things like cohort and retention analysis, sessionalize event data, and calculate the average lifetime value of a customer?

With derived tables, you can create new tables and data sets in Looker that don’t exist within your underlying database. That means you can leverage complex SQL queries to solve for challenging questions like, “At what point in a repeat customer’s lifetime are they spending the most money?”

Come learn about some of the advanced analytical patterns that you can model through the use of derived tables.

Curriculum

  • Webinar Recording (55:00)
  • Frequently Asked Questions
/