From the course: The Data Skills Survival Kit
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Establishing a cohort data set
From the course: The Data Skills Survival Kit
Establishing a cohort data set
- [Instructor] We've studied different gaps and other information in this series for Explore California and their tour bookings. We can see things like number of tours taken, even tours each month, different tours by month, just all of the typical data measures for this type of data. And that's been great, but we need to gain insight with different questions. And to do this, we need to implement the concept of cohorts. Cohorts are where you group similar data based on a shared set of characteristics. Now, to identify a cohort, all you need is a cohort definition based on the things that you believe are shared characteristics of the data that you want to work with. And for our analysis, we're going to define a cohort based on the first tour, a guest for Explore California books. Now, the guest may take multiple tours, but their cohort is based on their very first one. This allows us to transition our questions from…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
- Ex_Files_Data_Skills_Survival_Kit_2022_Q4.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q1.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q2.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q3.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q4.zip
- Ex_Files_Data_Skills_Survival_Kit_2024_Q1.zip
- Ex_Files_Data_Skills_Survival_Kit_2024_Q2.zip
- Ex_Files_Data_Skills_Survival_Kit_2024_Q4.zip
- Ex_Files_Data_Skills_Survival_Kit_2025_Q2.zip
- Ex_Files_Data_Skills_Survival_Kit_2025_Q3.zip
- Ex_Files_Data_Skills_Survival_Kit_2025_Q4.zip
Contents
-
-
-
-
-
-
-
-
-
- (Locked) Perform basic analysis on datasets11m 6s
- (Locked) Using analysis commands built into popular tools7m 30s
- (Locked) Basic dates analysis12m 46s
- (Locked) Analyzing data using a matrix and conditional formats10m 42s
- (Locked) Using Case statements for conditional logic in SQL queries9m 49s
- (Locked) Establishing a cohort data set13m 3s
- (Locked) Adding additional data to your cohorts7m 13s
- (Locked) Analyzing top and bottom scenarios11m 57s
- (Locked) Understanding and communicating impacts5m 51s
- (Locked) Working with different group sizes5m 42s
- (Locked) Visualizing Subgroups when searching for insights6m 33s
- (Locked)
-
-
-