Establishing a Cohort Data Set
Learn how to uncover long-term customer trends with cohort analysis. Every dataset tells a story, but sometimes the most powerful insights come from asking different questions. In this Data Survival Skills session, Robin introduces cohort analysis—a method of grouping customers by a shared characteristic, like the date of their first tour. Instead of just tracking how many people booked in May 2022, cohort analysis reveals how many first-time guests joined that month, how many friends they later brought along, and how much revenue those cohorts generated over time. By creating cohort definitions in Power Query and joining them back to booking data, you’ll see how to surface deeper trends that connect customer acquisition to lasting growth.
#DataAnalytics #CohortAnalysis #PowerQuery #BusinessIntelligence #CustomerInsights #DataSkills
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.


