Business Analytics

Panduan komplit untuk pemula: 4 tipe analitik (Descriptive, Diagnostic, Predictive, Prescriptive), workflow standar, dan studi kasus nyata.

Beda KPI vs Metric vs OKR. Framework AARRR. Rumus CAC, LTV, Churn, NPS. Plus daftar KPI per industri yang bisa langsung dipakai.

Pilih chart yang tepat. Hindari grafik yang menyesatkan. Anatomi dashboard standar: KPI cards di atas, trend di tengah, detail di bawah.

Dua teknik wajib di tim Product & Growth. Funnel untuk menemukan kebocoran konversi, cohort untuk membongkar ilusi pertumbuhan total.

Framework DECIDE, panduan A/B testing yang benar, dan 6 bias kognitif yang sering merusak analisis. Materi penutup yang menyatukan semua.

Skill #1 wajib BA. SELECT/JOIN/GROUP BY, CTE, window functions (LAG, RANK), MoM growth, cohort retention query patterns.

VLOOKUP/XLOOKUP/INDEX-MATCH, Pivot Table, SUMIFS, conditional formatting, Power Query, VBA & Apps Script automation untuk BA produktif.

Naik kelas dari Excel ke Python. DataFrame, groupby, merge, apply, matplotlib, seaborn. EDA workflow profesional 7-step.

Descriptive vs inferential, distribution, correlation vs causation, hypothesis testing, p-value fallacies, confidence interval, power analysis.

Trend, seasonality, ARIMA, SARIMA, Prophet, exponential smoothing. Stationarity, decomposition, evaluation metrics (MAE/MAPE/RMSE), backtesting.

Pareto 80/20, RFM segmentation 11 segmen, CLV calculation, churn prediction, behavioral clustering. Strategi marketing per segmen.

CAC, ROAS, MER, CPA, attribution model (first/last touch, data-driven), MMM (Marketing Mix Modeling), incrementality test, budget allocation.

SCQA framework, Pyramid Principle (Barbara Minto), chart choosing, slide design 1-slide-1-message, presentation flow, dealing with objection.

Struktur 10-section business case, ROI/NPV/IRR/payback, sensitivity analysis, executive summary template, report cadence (daily-quarterly), BLUF writing.

Career ladder L1-L5, skill stack, gaji range Indonesia, sertifikasi berbobot, portfolio project, interview prep, industry path, capstone project.