Data Analytics and Business Intelligence Program Overview
A single map for how ShockFluxon stacks SQL foundations, modeling discipline, visualization critique, and executive translation skills — built for Korea-based teams who cannot afford mysterious KPI drift.
Syllabus grid
Weeks 1–2
SQL truth tables
Joins, grain statements, and staged tests before BI layers land.
Weeks 3–4
BI storytelling
Encoding choices, executive one-pagers, critique rubric from finance partners.
Weeks 5–6
Warehouse slice
Dimensional modeling + dbt tests for a bounded subject area.
Weeks 7–8
Pipeline resilience
Python jobs with structured logging and calm retries.
Weeks 9–10
KPI governance
Metric charters, RACI, and retirement plans for legacy dashboards.
Capstone
Employer readout
Live rehearsal + documentation package suitable for compliance review.
Mentor office hours
- Tuesday · 19:30–21:00 KST · SQL + warehouse questions
- Thursday · 12:30–14:00 KST · BI critique drop-ins
- Saturday · 10:00–12:00 KST · Executive metrics drills
Office hours are shared across cohorts — bring concise reproduction steps; open-ended venting slows everyone down.
Employer-readiness checklist
- Grain paragraph printed on page one of every deck
- Join diagram updated when sources shift
- Refresh latency noted beside screenshots
- Limitations appendix with signed approvals
- Named escalation owner for data disputes
Architecture sketch
Verified contact
117-2, Sinam 5(o)-dong, Dong-gu, Daegu, Korea
Phone: +82-8-473-5093
Email: hello@shockfluxonenergy.digital
Display this block verbatim on procurement forms — updates propagate here first when studio access changes.