Materi 15 · Career & Capstone

Career Path Business Analyst

Materi penutup. Map career BA dari junior ke executive, tools wajib di tiap level, sertifikasi yang berbobot, gaji range Indonesia, dan capstone project untuk portfolio.

⏱ 30 Menit + Capstone🎯 All Levels🚀 Career

1. CAREER LADDER BA

Junior / Associate BA

0-2 tahun. Fokus eksekusi: pull data, build dashboard, write report. Belajar tools & business context.

Rp 7-12 juta/bulan

Business Analyst (Mid)

2-4 tahun. Lead project sendiri, propose insight, present ke manager. Domain expertise mulai terbentuk.

Rp 12-20 juta/bulan

Senior BA / Lead

4-7 tahun. Mentor junior, drive strategy, influence cross-functional. C-level visibility.

Rp 20-35 juta/bulan

Manager / Head of Analytics

7-12 tahun. Manage tim 3-10 orang, set analytics roadmap, OKR ownership. Hire & develop talent.

Rp 35-65 juta/bulan

Director / VP Analytics

12+ tahun. C-suite advisor, set vision, multiple team. Industry thought leader.

Rp 65 juta - 200jt+ /bulan

Range gaji 2026 untuk Jakarta-tier perusahaan. Bandung/Surabaya 70-80%. Startup unicorn / MNC top kuartal 1.5-2× range.

2. SKILL STACK PER LEVEL

Level	Hard Skills	Soft Skills
L1 Junior	Excel, SQL basic, BI tool 1×	Communication, attention to detail
L2 Mid	SQL advanced, Python pandas, statistik	Project management, stakeholder mgmt
L3 Senior	ML basics, MMM, A/B testing rigorous	Influence without authority, mentoring
L4 Manager	Strategic planning, vendor mgmt, hiring	People management, executive comm
L5 Director	Industry vision, M&A analytics	Board presence, talent development

3. SERTIFIKASI YANG BERBOBOT

Google Data Analytics Professional (Coursera) — bagus untuk pemula, recognized.
Microsoft Certified: Power BI Data Analyst — wajib kalau lingkungan Microsoft.
Tableau Certified Associate — Tableau dominasi enterprise viz market.
IIBA CBAP / CCBA — internationally recognized untuk traditional BA.
AWS Certified Data Analytics — kalau infra di AWS.
CFA Level 1 — tambahan kuat untuk financial analytics.
PMP / Scrum Master — untuk lead project & agile environment.

Sertifikat ≠ Pengganti Pengalaman

Sertifikat membantu lewat ATS recruiter, tapi portfolio project > sertifikat. Hiring manager mau lihat: bisa solve real problem? Pakai SQL/Python beneran? Bukan slide PPT teori.

4. PORTFOLIO YANG NENDANG

3 Project = Job Ticket

Bangun 3 portfolio project di GitHub + blog/Medium. Hiring manager spend < 5 menit review CV — portfolio yang clear & impactful akan stand out.

Project 1: SQL + Dashboard. Dataset publik (Kaggle e-commerce), build SQL query analysis + Tableau/Looker dashboard. Tulis case study di blog.
Project 2: Python EDA. Jupyter notebook lengkap dengan EDA, insight, visualisasi. Push ke GitHub dengan README jelas.
Project 3: A/B Test atau Experiment Design. Bahkan dummy data — tunjukkan rigor: hypothesis, sample size, statistical test, interpretasi.
Bonus: contribute open source (DVC, dbt, Pandas) — bukti collaboration skill.

5. INTERVIEW PREP

4 Tipe Interview Round Standar

1. SQL test: live coding, problem realistic. Latih di StrataScratch, LeetCode SQL.
2. Case study: "Bagaimana kamu analyze X?" — pakai framework SCQA + MECE breakdown.
3. Behavioral: "Cerita waktu kamu disagree dengan stakeholder" — gunakan STAR method.
4. Technical/Product sense: "Bagaimana ngukur sukses fitur baru di app?" — kreativitas + structured thinking.

6. TOOLS LANDSCAPE 2026

SQL flavors: PostgreSQL, MySQL, BigQuery, Snowflake. Wajib bisa minimum 2.
Python ecosystem: pandas, numpy, scikit-learn, matplotlib, seaborn.
BI Tools: Looker Studio (free), Tableau, Power BI, Metabase, Looker.
Data Modeling: dbt (transformasi modern), Apache Airflow.
Spreadsheet: Excel, Google Sheets, Airtable.
Notebook: Jupyter, Google Colab, Databricks.
Statistics: R, statsmodels, Prophet, scipy.
AI tools: ChatGPT/Claude untuk code assist, dashboard summary auto.

7. INDUSTRY-SPECIFIC PATH

Industry	Spesialisasi	Skill Tambahan
E-Commerce	Funnel, RFM, marketing	Looker, GA4, attribution
Fintech	Risk, fraud, credit scoring	Python ML, regulatory knowledge
SaaS B2B	Product analytics, churn	Mixpanel, Amplitude, cohort
Retail / FMCG	Demand forecasting, inventory	SAP, time series, supply chain
Healthcare	Patient outcome, RCT	R, biostatistics, HIPAA/regulasi
Manufacturing	QA, throughput, OEE	SPC, Six Sigma, lean

8. NETWORKING & VISIBILITY

Bangun Personal Brand

LinkedIn aktif: share insight 1×/minggu. Build following 3,000+ data professionals dalam 1 tahun.
Medium / blog: tulis case study analysis. Sumber traffic untuk recruiter.
Komunitas: JS Indonesia, Bandung BI Meetup, MeetUp Tableau, kompetisi Kaggle.
Conference: hadiri minimum 1× setahun. Network organic dari 500+ peer.

9. STUDI KASUS — Career Hop

Junior BA → Data Director di 8 Tahun

Seorang lulusan IT yang start sebagai Junior BA di e-commerce Rp 8jt/bulan. Strategi: level up tools tiap tahun (Excel → SQL → Python → ML), switch perusahaan setiap 2-3 tahun untuk rapid salary growth (Rp 8 → 15 → 28 → 45 → 70 juta), build personal brand di LinkedIn (15K followers), dan certifikasi internasional (Google Data Analytics + Tableau).

Pelajaran: career compounding. Tahun 1-3 build skill, tahun 4-6 build network, tahun 7+ leverage both untuk leadership role.

📝 CAPSTONE PROJECT — Materi Penutup

Sebagai project akhir kurikulum 15 materi Business Analytics, bangun 1 portfolio piece end-to-end yang menggabungkan minimum 5 materi:

Pilih business problem. Contoh: "Kenapa retention M2 turun di e-commerce X?"
Define metric & hypothesis. Pakai materi 2 (KPI) & 5 (Decision Making).
Pull data dengan SQL. Materi 6 — minimum 3 query non-trivial.
EDA dengan Python pandas. Materi 8 — 1 jupyter notebook lengkap.
Statistical test / cohort analysis. Materi 9 atau 11 — formal hypothesis test.
Build dashboard interaktif. Materi 3 + 7 — Looker Studio / Tableau.
Tulis business case. Materi 14 — executive summary + ROI.
Storytelling presentasi 5 menit. Materi 13 — rekam video atau live demo.
Publish: GitHub repo + blog post + LinkedIn share.

Output: 1 portfolio project yang menggambarkan kamu siap untuk mid-level BA role. Pakai untuk apply kerja, freelance, atau pitch ke client.

★ SELESAI! 🎉 ★

Kamu telah menyelesaikan 15 materi kurikulum Business Analytics. Total ~7 jam materi + tugas. Kamu sekarang punya pondasi solid: Foundation → Tools → Advanced Techniques → Strategic Soft Skills.

"In God we trust. All others must bring data." — W. Edwards Deming

Rangkuman

Career ladder BA: Junior → Mid → Senior → Manager → Director.
Skill stack berkembang dari executor → strategist → leader.
Sertifikat membantu, tapi portfolio project lebih nendang.
Bangun 3 portfolio project + LinkedIn presence + conference network.
Industry-specific path: pilih spesialisasi sesuai passion.
Switch perusahaan tiap 2-3 tahun untuk rapid salary growth.
Career compounding: skill → network → leadership.