![[05/Rokel/20]](https://images.unsplash.com/photo-1642356692954-3fbb84baf1a6?ixid=M3w0MjA4MDF8MHwxfHNlYXJjaHwyM3x8dmlydHVhbCUyMGRhdGFzZXRzJTIwRmxvdy5CSSUyMGRhc2hib2FyZGluZyUyMFNRTCUyMFBvc3RncmVTUUx8ZW58MXwwfHx8MTcwNjQ3NzEwMnww&ixlib=rb-4.0.3&w=800&fit=crop&h=300&q=75&fm=webp)
Podcast
Questions and Answers
What is the purpose of cohorting based on the first month that a customer has placed an order?
What is the purpose of cohorting based on the first month that a customer has placed an order?
- To group customers by the month they signed up
- To group customers by their location
- To group customers by the month they made their first purchase (correct)
- To group customers by their age
In creating a heatmap chart, what does the x-axis represent?
In creating a heatmap chart, what does the x-axis represent?
- Coaching date
- Customer segment
- Product category (correct)
- Number of sales
What does the SQL query 'SELECT product_category, COUNT(*) AS sales FROM orders GROUP BY product_category ORDER BY sales DESC;' do?
What does the SQL query 'SELECT product_category, COUNT(*) AS sales FROM orders GROUP BY product_category ORDER BY sales DESC;' do?
- Filters out products with low sales
- Lists product categories in alphabetical order
- Returns the product category and the number of sales for each category (correct)
- Counts the total number of products sold
How is the cohort chart different from the heatmap chart?
How is the cohort chart different from the heatmap chart?
What information does the SQL query 'SELECT cohort_date, customer_segment, COUNT(*) AS active_users FROM users GROUP BY cohort_date, customer_segment ORDER BY cohort_date;' provide?
What information does the SQL query 'SELECT cohort_date, customer_segment, COUNT(*) AS active_users FROM users GROUP BY cohort_date, customer_segment ORDER BY cohort_date;' provide?
What does each line on a cohort chart represent?
What does each line on a cohort chart represent?
Why would you add a heatmap or cohort chart to a dashboard?
Why would you add a heatmap or cohort chart to a dashboard?
In a heatmap chart, the x-axis represents the number of sales for each product category.
In a heatmap chart, the x-axis represents the number of sales for each product category.
In a cohort chart, each line represents a different cohort date.
In a cohort chart, each line represents a different cohort date.
The SQL query 'SELECT product_category, COUNT(*) AS sales FROM orders GROUP BY product_category ORDER BY sales DESC;' provides the count of active users for each product category.
The SQL query 'SELECT product_category, COUNT(*) AS sales FROM orders GROUP BY product_category ORDER BY sales DESC;' provides the count of active users for each product category.
A cohort chart is created with the cohort date on the x-axis.
A cohort chart is created with the cohort date on the x-axis.
In a heatmap chart, the y-axis represents the number of active users.
In a heatmap chart, the y-axis represents the number of active users.
The SQL query for creating a heatmap chart involves selecting cohort_date and customer_segment.
The SQL query for creating a heatmap chart involves selecting cohort_date and customer_segment.
Cohorting in this context means dividing customers based on the last month they placed an order.
Cohorting in this context means dividing customers based on the last month they placed an order.
Match the following SQL queries with their corresponding chart type:
Match the following SQL queries with their corresponding chart type:
Match the following descriptions with the correct chart element:
Match the following descriptions with the correct chart element:
Match the following actions with their respective outcomes:
Match the following actions with their respective outcomes:
Match the following data components with their placement on the charts:
Match the following data components with their placement on the charts:
Match the following SQL query results with their corresponding information:
Match the following SQL query results with their corresponding information:
Match the following terms with their correct definitions:
Match the following terms with their correct definitions:
Match the following tasks with their corresponding steps:
Match the following tasks with their corresponding steps:
![[05/Rokel/22]](https://images.unsplash.com/photo-1661468038478-50ca22780f5a?ixid=M3w0MjA4MDF8MHwxfHNlYXJjaHw5fHxSaGlubyUyMDNEJTIwbW9kZWxpbmclMjBsYXllcnN8ZW58MXwwfHx8MTcwNDA1NTAzMXww&ixlib=rb-4.0.3&w=300&fit=crop&h=200&q=75&fm=webp)
