Business analyst interview prep, head-to-head
Generic copilots either go too deep (DS-style stats rounds) or too shallow (just behavioral). BA loops sit in the middle — SQL + business framing + stakeholder narrative.
Built for the four BA rounds
SQL rounds — calibrated to BA, not DS
BA SQL rounds rarely need complex statistical aggregations. They test JOIN strategy, window functions for ranking / running totals, COALESCE / NULL handling, and the ability to read a query plan. The copilot stays at BA depth — not over-engineered DS-style.
Business-case rounds — problem-first
"Our refund rate jumped 8% this quarter — investigate." The copilot enforces problem-first framing: define the metric precisely, segment by likely cause (cohort, channel, geo, product line), narrow to root cause, validate, recommend. Most candidates jump to data; the copilot anchors the question.
Stakeholder-communication prompts
The classic BA test: "explain this finding to the COO in two sentences". The copilot has tested phrasing patterns — anchor the business question, state the finding in one line, name the uncertainty, recommend the action — that consistently land with non-data execs.
Process-improvement rounds
When the round is "this onboarding takes 14 days — fix it", the copilot scaffolds the Lean / Six-Sigma approach: map the current state, identify the wait/handoff/rework drivers, propose the future state, name the change-management cost. Without diving into Six-Sigma certification jargon that does not land.
Requirements elicitation rounds
"How would you gather requirements for a new finance dashboard?" The copilot walks the canonical sequence: stakeholder mapping, current-state interview, success-criteria definition, data-source inventory, scope-vs-MVP cut, sign-off. With the failure mode for each step.
Tableau / Power BI dashboard reasoning
BA loops often include "design a dashboard for X". The copilot does not pick chart types in isolation — it anchors the audience, the decision the dashboard enables, the metric hierarchy, the interactivity cost. So you sound like a BA who has shipped dashboards an exec actually used.
