Archive 2025 Jan 25 데이터 마트 모델링 후기 (First Activation Funnel 지표) Language (Korean) Article (Project) Level (3. Advanced) Jan 25 Data Mart Modeling Review (First Activation Funnel Metrics) Language (English) Article (Project) Level (3. Advanced) 2024 Dec 28 Airflow 도입 후기 Language (Korean) Article (Project) Level (1. Beginner) Dec 28 Review of Implementing Airflow Language (English) Article (Project) Level (1. Beginner) Nov 03 GA4 기반 데이터 웨어하우스 구축 후기 Language (Korean) Article (Project) Level (2. Intermediate) Nov 03 GA4-based Data Warehouse Implementation Review Language (English) Article (Project) Level (2. Intermediate) Sep 21 dbt Docs 사내 공유 방법 (사이트 호스팅 후기) Language (Korean) Article (Issue Resolution) Level (1. Beginner) Sep 21 How to Share dbt Docs Internally (Site Hosting Review) Language (English) Article (Issue Resolution) Level (1. Beginner) Aug 29 구매 전환율 급상승 후기 Language (Korean) Article (Project) Level (1. Beginner) Aug 29 Dramatic Increase in E-commerce Conversion Rates Language (English) Article (Project) Level (1. Beginner) Aug 13 NOT IN 대신 JOIN을 통한 쿼리 최적화 Language (Korean) Article (Issue Resolution) Level (2. Intermediate) Aug 13 Query Optimization by Using JOIN Instead of NOT IN Language (English) Article (Issue Resolution) Level (2. Intermediate) Aug 09 Redash 대시보드 활용 후기 Language (Korean) Article (Project) Level (2. Intermediate) Aug 09 Redash Dashboard Usage Review Language (English) Article (Project) Level (2. Intermediate) Jul 20 데이터 기반 VOC 분석 및 자동화 대시보드 구축: 비용 절감과 효율성 극대화 Language (Korean) Article (Project) Level (2. Intermediate) Jul 20 Data-driven VOC Analysis and Automated Dashboard Development: Reducing Cost and Maximizing Efficiency Language (English) Article (Project) Level (2. Intermediate) Jun 30 Rolling MAU 쿼리 최적화 Language (Korean) Article (Issue Resolution) Level (3. Advanced) Jun 30 Rolling MAU Query Optimization Language (English) Article (Issue Resolution) Level (3. Advanced) May 19 IP 주소-국가 매핑 쿼리 최적화 Language (Korean) Article (Issue Resolution) Level (3. Advanced) May 19 IP Address-Country Mapping Query Optimization Language (English) Article (Issue Resolution) Level (3. Advanced) Jan 01 데이터 분석가의 SQL 최적화 일기: 코호트 리텐션 Batch Query 만들기 Language (Korean) Article (Issue Resolution) Level (3. Advanced) 2023 Nov 30 데이터 분석가의 SQL 최적화 일기: SELF JOIN을 피하는 방법 Language (Korean) Article (Issue Resolution) Level (2. Intermediate) Nov 19 데이터 분석가의 SQL 최적화 일기: Static vs. Rolling Stickiness Language (Korean) Article (Issue Resolution) Level (2. Intermediate) Jul 15 데이터 분석가의 파이썬 클라이언트 개발기 feat. pyinstaller Language (Korean) Article (Project) Level (2. Intermediate) Jul 09 The Last Click Attribution Model Using BigQuery Language (English) Article (Issue Resolution) Level (3. Advanced) Jun 14 It’s Harder than You Think to Extract DAU Separating New and Existing Users in BigQuery Language (English) Article (Issue Resolution) Level (1. Beginner) Jun 04 Harnessing the Power of BigQuery and Python: Overcoming Google Optimize A/B Testing Limitations Language (English) Article (Issue Resolution) Level (2. Intermediate) May 21 Let’s Create the Sankey Chart Language (English) Article (Project) Level (2. Intermediate) Apr 30 A/B 테스트 후기: 할인율 명시의 효과 Language (Korean) Article (Project) Level (2. Intermediate) Apr 30 A/B Test Review: The Impact of Displaying Discount Percentages Language (English) Article (Project) Level (2. Intermediate) 2022 Dec 25 회귀 모델이 풀 수 없는 문제 Language (Korean) Article (Project) Level (2. Intermediate)
Jan 25 데이터 마트 모델링 후기 (First Activation Funnel 지표) Language (Korean) Article (Project) Level (3. Advanced)
Jan 25 Data Mart Modeling Review (First Activation Funnel Metrics) Language (English) Article (Project) Level (3. Advanced)
Nov 03 GA4-based Data Warehouse Implementation Review Language (English) Article (Project) Level (2. Intermediate)
Sep 21 dbt Docs 사내 공유 방법 (사이트 호스팅 후기) Language (Korean) Article (Issue Resolution) Level (1. Beginner)
Sep 21 How to Share dbt Docs Internally (Site Hosting Review) Language (English) Article (Issue Resolution) Level (1. Beginner)
Aug 29 Dramatic Increase in E-commerce Conversion Rates Language (English) Article (Project) Level (1. Beginner)
Aug 13 NOT IN 대신 JOIN을 통한 쿼리 최적화 Language (Korean) Article (Issue Resolution) Level (2. Intermediate)
Aug 13 Query Optimization by Using JOIN Instead of NOT IN Language (English) Article (Issue Resolution) Level (2. Intermediate)
Jul 20 데이터 기반 VOC 분석 및 자동화 대시보드 구축: 비용 절감과 효율성 극대화 Language (Korean) Article (Project) Level (2. Intermediate)
Jul 20 Data-driven VOC Analysis and Automated Dashboard Development: Reducing Cost and Maximizing Efficiency Language (English) Article (Project) Level (2. Intermediate)
Jun 30 Rolling MAU Query Optimization Language (English) Article (Issue Resolution) Level (3. Advanced)
May 19 IP Address-Country Mapping Query Optimization Language (English) Article (Issue Resolution) Level (3. Advanced)
Jan 01 데이터 분석가의 SQL 최적화 일기: 코호트 리텐션 Batch Query 만들기 Language (Korean) Article (Issue Resolution) Level (3. Advanced)
Nov 30 데이터 분석가의 SQL 최적화 일기: SELF JOIN을 피하는 방법 Language (Korean) Article (Issue Resolution) Level (2. Intermediate)
Nov 19 데이터 분석가의 SQL 최적화 일기: Static vs. Rolling Stickiness Language (Korean) Article (Issue Resolution) Level (2. Intermediate)
Jul 15 데이터 분석가의 파이썬 클라이언트 개발기 feat. pyinstaller Language (Korean) Article (Project) Level (2. Intermediate)
Jul 09 The Last Click Attribution Model Using BigQuery Language (English) Article (Issue Resolution) Level (3. Advanced)
Jun 14 It’s Harder than You Think to Extract DAU Separating New and Existing Users in BigQuery Language (English) Article (Issue Resolution) Level (1. Beginner)
Jun 04 Harnessing the Power of BigQuery and Python: Overcoming Google Optimize A/B Testing Limitations Language (English) Article (Issue Resolution) Level (2. Intermediate)
Apr 30 A/B Test Review: The Impact of Displaying Discount Percentages Language (English) Article (Project) Level (2. Intermediate)
