Business Analyst Capstone: From Problem to Board Decision

Programme overview

The capstone of the Business Analyst track. Shieldline Insurance's managing director says motor claims take too long, customers are leaving, the regulator is asking questions, Lagos has tried some changes, and IT wants a ₦280 million claims system. You'll frame the problem and map the stakeholders, measure the current state, rebuild the real process from 32,000 events, and trace the delay to four root causes: incomplete documents from agents, a physical inspection for every claim, managers who approve only on Fridays, and too few assessors in Port Harcourt. Then you'll judge the Lagos pilot against the other regions, put a value on slow claims through lost renewals, compare the options by NPV, write user stories with the controls finance needs, read the acceptance test results honestly, and write the decision paper for the board. Use SQL, Excel or Power BI: every answer is checked against the data.

Curriculum

1. 01The Brief and the Plan25 min

   • The brief and the planMeet Shieldline Insurance, turn a managing director's frustration into a problem statement, scope and plan, agree the definitions, and map the stakeholders you'll need on side.
2. 02The Current State in Numbers25 min

   • The current state in numbersMeasure the problem before explaining it. Find out how slow claims are by channel, region and type, what happens to claims that aren't paid, and what customers complain about.
3. 03The Process from the Event Log25 min

   • The process from the event logMap how claims really flow from the claims system's event log, not from the procedure manual. Find the common paths, the rework loops and the waits between steps.
4. 04Root Causes25 min

   • Root causesFind out why claims are slow. Split the delay by stage, then test each theory against the data. Look at documents by channel, the day managers approve claims, which claims really need an inspection, and assessor capacity.
5. 05Did the Pilot Work?25 min

   • Did the pilot work?Evaluate the Lagos pilot honestly. Compare it with the other regions over the same months, so the season isn't mistaken for the change. Then check every measure the pilot was meant to move, and the ones it mustn't harm.
6. 06Options and the Business Case30 min

   • Options and the business casePut a value on slow claims through lost renewals, cost the benefits of rolling out the Lagos changes from the pilot's evidence, and compare the options by net present value and payback, with every assumption stated.
7. 07Requirements and Readiness25 min

   • Requirements and readinessTurn the root causes into requirements, business rules and user stories with acceptance criteria. Define the measures that will prove the change worked, then read the acceptance test results and make an honest go or no-go call.
8. 08The Decision Paper25 min

   • The decision paperBring the analysis together into a decision paper the board can approve. Lead with the recommendation, back it with evidence, state the conditions and risks, prepare for the hard questions, and plan your final project.

Assessment and certificate

You are assessed with a final assessment (pass mark 60%) and a final project. Your certificate is awarded when you meet those requirements. Paying for the programme does not award it on its own.