Lewati ke konten

Belajar Tantangan Playbook Ensiklopedia Leaderboard

Belajar Tantangan Playbook Ensiklopedia Leaderboard

Produk lain

NgulikSheetExcel · Google Sheets

Analyst SQL Vault - Playbook | NgulikSQL

NgulikSQL/Playbook/Analyst SQL Vault

Analyst SQL Vault

100 Pola query yang dipakai analyst. Tinggal copy, update, beres.

10 dari 100 query bisa kamu buka gratis

Premium membuka sisanya: query siap-pakai buat kerjaan analis, plus penjelasan kapan dipakai dan variasi per dialek.

Buka semua querymulai Rp 69.000/bulan

Kategori

🔍Eksplorasi & Profiling Data10
📊Agregasi & Grouping15
📈Time Series & Analisis Tanggal15
👥Cohort & Retention15
🎯Funnel & Konversi15
🪟Ranking & Window Functions15
✅Data Quality & Audit10
⚡Performance & Optimisasi5

Tingkat

Pilih Kategori

Menampilkan 100 dari 100 query

🔍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

★★★☆☆