Cohort Analysis

Before I dive into the main juice of this article, it is important to note that this is a documentation of my learning process for data analytics. For better understanding and retention of anything I’m learning, I find that writing it down is extremely helpful. That way, I’m communicating to…

SQL 的樞紐分析 PIVOT 這次要筆記的是 SQL 上的樞紐分析！樞紐分析簡言之就是將資料依多個變數或維度彙整，但呈現上通常將欲彙整的維度分成欄與列（寬表），如 Fig-1 分別將原資料彙整後（平均），再將 Name 和 Subject 這兩個維度分別彙整於欄與列。 說穿了，樞紐分析就是 GROUP BY 後，再將資料重新排列。但我們為什麼需要使用到樞紐分析呢？也許最常見的原 …

Having a customer come back time after time is the greatest feeling. — A user that had used your app today and kept using it for next day indicates that you’ve managed to retain this user. So if Jenna logged in to the app on Friday, and them logged in again on Saturday, she is retained. However, if on that Friday, Danny had…

Analyze user behavior and conversions with cohort reports — the method that mirrors reality. Let’s say you’re analyzing an event — maybe it’s webinar registrations, or clicks generated by a paid campaign — and you need to build a report. I’m willing to bet that your first impulse is to…

Summary : Given a dataset, using table “stories” to create monthly retention cohorts and then how many of them (%) coming back for the following months in 2014. Here’s a graph showing what percent of author came back to the hacker news to create a story after visiting for the…

In this article, we’ll learn about Customer Segmentation. I broke down the topic to make it understandable and practical for you. We all know that today, the most successful companies are the ones that know their customers so well that they can anticipate their needs. Data analysts play a key…

In simple terms, a cohort is just a group of various subjects that share a defining feature. We can then observe the behaviour of a cohort over time and then it can be compared to other cohorts. This article is a presentation of a cohort analysis with Python. What is…