Analyst SQL Vault
100 Pola query yang dipakai analyst. Tinggal copy, update, beres.
🔍Eksplorasi & Profiling Data(10)
Row Count & Basic Stats per Tabel
🔍Eksplorasi & Profiling Data
Null Count & Null Percentage per Kolom
🔍Eksplorasi & Profiling Data
Distinct Value Count per Kolom
🔍Eksplorasi & Profiling Data
Data Type & Schema Audit
🔍Eksplorasi & Profiling Data
Min, Max, Avg, StdDev per Kolom Numerik
🔍Eksplorasi & Profiling Data
Date Range Audit
🔍Eksplorasi & Profiling Data
Top 10 Most Frequent Values per Kolom
🔍Eksplorasi & Profiling Data
Cardinality Check (Low vs High Cardinality)
🔍Eksplorasi & Profiling Data
Row Count per Partition / per Tanggal
🔍Eksplorasi & Profiling Data
Cross-Table Row Count Comparison
🔍Eksplorasi & Profiling Data
📊Agregasi & Grouping(15)
Revenue by Single Dimension
📊Agregasi & Grouping
Revenue by Multi-Dimension
📊Agregasi & Grouping
Conditional Aggregation dengan CASE
📊Agregasi & Grouping
Percentage Share per Group
📊Agregasi & Grouping
Top N per Group
📊Agregasi & Grouping
Running Total per Group
📊Agregasi & Grouping
Aggregate dengan HAVING Filter
📊Agregasi & Grouping
GROUPING SETS / ROLLUP untuk Subtotal
📊Agregasi & Grouping
COUNT DISTINCT yang Efisien
📊Agregasi & Grouping
Weighted Average
📊Agregasi & Grouping
Median dan Percentile
📊Agregasi & Grouping
Ratio antara Dua Metric
📊Agregasi & Grouping
Null-Safe Aggregation
📊Agregasi & Grouping
Multi-Metric dalam Satu Query
📊Agregasi & Grouping
Aggregasi dengan Filter Dinamis
📊Agregasi & Grouping
📈Time Series & Analisis Tanggal(15)
Daily / Weekly / Monthly Aggregation
📈Time Series & Analisis Tanggal
Month-over-Month (MoM) Growth Rate
📈Time Series & Analisis Tanggal
Year-over-Year (YoY) Comparison
📈Time Series & Analisis Tanggal
Year-to-Date (YTD) Running Total
📈Time Series & Analisis Tanggal
7-Day Rolling Revenue
📈Time Series & Analisis Tanggal
Rolling 30-Day Average
📈Time Series & Analisis Tanggal
Week-over-Week dengan LAG()
📈Time Series & Analisis Tanggal
Date Spine / Fill Missing Dates
📈Time Series & Analisis Tanggal
Fiscal Year / Custom Calendar Logic
📈Time Series & Analisis Tanggal
Time Between Events (DATEDIFF)
📈Time Series & Analisis Tanggal
First and Last Event per User
📈Time Series & Analisis Tanggal
Events within Time Window
📈Time Series & Analisis Tanggal
Trailing 12-Month (TTM) Metric
📈Time Series & Analisis Tanggal
Seasonality Detection (Day of Week Pattern)
📈Time Series & Analisis Tanggal
Anomaly Flag (Value > 2 StdDev dari Rolling Avg)
📈Time Series & Analisis Tanggal
👥Cohort & Retention(15)
Classic Acquisition Cohort
👥Cohort & Retention
D1 / D7 / D30 Retention Rate
👥Cohort & Retention
N-Day Retention Matrix (Wide Format)
👥Cohort & Retention
Revenue Cohort
👥Cohort & Retention
Cohort Size over Time
👥Cohort & Retention
Active User Cohort (Rolling 30-Day Active)
👥Cohort & Retention
Churn Cohort (Bulan Terakhir Aktif)
👥Cohort & Retention
Re-Engagement Cohort (Lapsed then Returned)
👥Cohort & Retention
Feature Adoption Cohort
👥Cohort & Retention
Subscription Cohort (SaaS)
👥Cohort & Retention
Cohort LTV (Lifetime Value per Cohort)
👥Cohort & Retention
Retention by Acquisition Channel
👥Cohort & Retention
Retention Heatmap Data
👥Cohort & Retention
Early vs Late Cohort Comparison
👥Cohort & Retention
Cohort dengan Grace Period
👥Cohort & Retention
🎯Funnel & Konversi(15)
Basic Step-by-Step Funnel
🎯Funnel & Konversi
Drop-off Rate per Step
🎯Funnel & Konversi
Time-to-Convert (Median & Percentile)
🎯Funnel & Konversi
Funnel by Segment (A/B Comparison)
🎯Funnel & Konversi
Ordered Funnel (Harus Berurutan)
🎯Funnel & Konversi
Unordered Funnel (Boleh Lompat Step)
🎯Funnel & Konversi
Funnel Completion Rate
🎯Funnel & Konversi
Multi-Touch Attribution (First / Last / Linear)
🎯Funnel & Konversi
Cart Abandonment Analysis
🎯Funnel & Konversi
Form Completion Funnel
🎯Funnel & Konversi
Signup to First Action Funnel
🎯Funnel & Konversi
Upgrade / Upsell Funnel
🎯Funnel & Konversi
Reactivation Funnel
🎯Funnel & Konversi
Funnel dengan Time Constraint
🎯Funnel & Konversi
Funnel Volume vs Rate Trade-off
🎯Funnel & Konversi
🪟Ranking & Window Functions(15)
ROW_NUMBER per Partition
🪟Ranking & Window Functions
RANK vs DENSE_RANK (Kapan Pakai Mana)
🪟Ranking & Window Functions
NTILE untuk Quartile / Decile
🪟Ranking & Window Functions
PERCENT_RANK dan CUME_DIST
🪟Ranking & Window Functions
LAG untuk Perbandingan Nilai Sebelumnya
🪟Ranking & Window Functions
LEAD untuk Nilai Berikutnya
🪟Ranking & Window Functions
FIRST_VALUE / LAST_VALUE per Partition
🪟Ranking & Window Functions
NTH_VALUE (Ambil Nilai ke-N dalam Group)
🪟Ranking & Window Functions
Deduplication dengan ROW_NUMBER
🪟Ranking & Window Functions
Running Total dengan SUM OVER
🪟Ranking & Window Functions
Moving Average dengan ROWS BETWEEN
🪟Ranking & Window Functions
Rank Change Week-over-Week
🪟Ranking & Window Functions
Gap and Island Problem
🪟Ranking & Window Functions
Session Attribution dengan Window
🪟Ranking & Window Functions
Top 3 per Category dengan QUALIFY
🪟Ranking & Window Functions
✅Data Quality & Audit(10)
Duplicate Row Detector
✅Data Quality & Audit
Duplicate Key Detector
✅Data Quality & Audit
Orphan Record Detector (FK tanpa Parent)
✅Data Quality & Audit
Referential Integrity Check
✅Data Quality & Audit
Value Constraint Checker
✅Data Quality & Audit
Format Validation (Email, Phone, Tanggal)
✅Data Quality & Audit
Unexpected NULL di Kolom Wajib Isi
✅Data Quality & Audit
Row Count Reconciliation (Source vs Target)
✅Data Quality & Audit
Freshness Check (Data Terlambat Masuk)
✅Data Quality & Audit
Cross-Table Consistency Check
✅Data Quality & Audit
⚡Performance & Optimisasi(5)
Anti-Pattern: SELECT * Replacement
⚡Performance & Optimisasi
Anti-Pattern: NOT IN vs NOT EXISTS vs LEFT JOIN
⚡Performance & Optimisasi
Partition Pruning Check
⚡Performance & Optimisasi
Subquery vs CTE vs Temp Table — Kapan Mana
⚡Performance & Optimisasi
EXPLAIN / Query Profiling Template (per Dialect)
⚡Performance & Optimisasi
