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.
415
9
장
결론
지금까지 데이터 프로파일링부터 시계열 분석, 텍스트 분석, 이상 탐지까지, 여러 가지 분석 업
무를 살펴보면서
SQL
이 얼마나 유연하고 강력한 언어인지 알아봤습니다.
SQL
문으로 실험
분석을 수행하거나 복잡한 데이터셋을 생성할 수도 있습니다. 물론
SQL
이 모든 분석에 만능은
아니지만 일반적인 분석 도구로는 손색이 없습니다.
이 장에서는 다양한
SQL
기법을 활용한 새로운 분석 몇 가지를 알아봅니다. 그리고 여러분이
데이터 분석 기술을 계속해서 발전시키고 더 깊이 이해하는 데 유용한 자료를 소개하며 책을
마무리합니다.
9.1
퍼널 분석
퍼널
funnel
은 특정 목적을 달성하기 위해 거쳐야 하는 여러 단계로 구성됩니다. 여기서 목적이
란 서비스 회원 가입, 구매 완료, 과정 수료증 취득 등입니다. 예를 들어, 웹사이트의 상품 구매
퍼널은 ‘장바구니에 추가’ 버튼을 클릭하고, 배송 정보를 기입하고, 신용 카드 정보를 입력하고,
마지막으로 ‘주문하기’ 버튼을 클릭하는 단계로 구성됩니다.
퍼널 분석에는
3
장에서 다룬 시계열 분석과
4
장에서 다룬 코호트 분석을 함께 사용하기도 합
니다. 단, 시계열 분석에서는 시간에 따라 한 가지 이벤트의 변화를 분석한 반면 퍼널 분석에
서는 단계별로 다른 이벤트를 분석한다는 차이가 있습니다. 퍼널 분석에서 주목적은 ...
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.