August 2022
Beginner to intermediate
436 pages
9h 43m
Korean
Content preview from SQL로 시작하는 데이터 분석
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
207
4
장
코호트 분석
의원 유형별 리텐션
리텐션 비율
rep
sen
구간(연도)
그림
4-10
2000
년에 재임 중인 의원의 유형별 리텐션
코호트를 정의할 때는 기준과 시작 날짜를 신중하게 선택해야 합니다. 날짜가 아닌 다른 기준
으로 코호트를 정의하는 예로는, 고객의 구매 활동이 특정 임계값(특정 구매 횟수 또는 소비
금액 등 )에 도달한 이후의 리텐션 분석이 있습니다.
코호트 리텐션 분석은 시계열 데이터에서 개체의 행동을 이해하는 데 아주 유용한 방법입니다.
지금까지
SQL
을 활용해 리텐션을 계산하는 방법, 시계열 데이터 또는 다른 테이블의 데이터
를 기준으로 코호트 리텐션을 분석하는 방법, 개체 수명 주기상 중간 지점 날짜를 기준으로 리
텐션을 분석하는 방법을 알아봤습니다. 시계열 데이터에서 윈도우 함수와
JOIN
을 활용해 희소
코호트를 다루는 방법도 배웠습니다. 그 외에도 생존자, 리턴십, 누적 계산 등 코호트 리텐션
분석과 관련된 다양한 분석이 있으며, 모두 지금까지 살펴본 리텐션 계산
SQL
코드를 그대로
활용합니다. 다음 절에서 하나씩 자세히 알아봅시다.
208
SQL로 시작하는 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.