Introduction
In many cases the most common measurement technique in working with data is to find the center (very often referred to as "the average"). What does the typical _______________ look like? Fill in the blank examples include:
- What does the typical ___customer look like?
- How much is typically spent in a customers' first year...
- On average, how long can we expect any given customer to stay active...
- How many times do they request help from our staff...
All of these questions are answered via a measure of center, which we'll dive in to inside this lesson.
Spreadsheet
Allocating our data into different segments in Google Sheets will be introduced in this lesson.
- AVERAGE
- MEDIAN
- MODE
Database and SQL
This lesson will cover how to classify our data into different segments in SQL, by introducing a powerful and commonly used SQL operator:
- AVG
- PERCENTILE_CONT(0.50)
- MODE()
BI Software
We will cover how to create segments in Looker.
- Table calculations
- LookML development