Business Analysis by the Numbers: Stakeholder Grids, RACI Checks, Elicitation Plans, Requirement Quality, MoSCoW Capacity, Objective Traceability, Process Gaps & the Business Case
Turn a business analyst's lists into numbers you can defend. You will score stakeholders on power and interest, check a RACI matrix for gaps, plan elicitation sessions, flag vague requirements, fit Must/Should/Could items into capacity, trace every requirement to an objective, cost the as-is and to-be process and finish with a business case and change-request impacts, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course turns the lists of a business analyst into numbers, one checked cell at a time. You score stakeholders on power and interest and sort them into quadrants with IFS, check a RACI matrix for missing or double owners, and plan interviews, workshops and surveys in analyst hours with a WORKDAY calendar. You flag vague words in 30 requirements with FIND and IFERROR, score their quality, fit Must, Should and Could items into release capacity with a running total, and trace every requirement to a business objective. Finally you cost an as-is and a to-be order process, build a five-year business case with NPV and judge three change requests on payback and go-live date.
Lessons
- Stakeholder Register: Power & Interest Scores, Quadrants with IFS and a Grid Chart Pro
- RACI Checks: Exactly One A, at Least One R, Missing Owners and Overloaded Roles Pro
- Elicitation Plan: Interviews, Workshops & Surveys, BA Hours, Group Coverage and a WORKDAY Calendar Pro
- Requirement Quality: Vague Words with FIND & IFERROR, Missing Acceptance Criteria and a Quality Score Pro
- MoSCoW against Capacity: Must Share vs a Fictional 60 % Rule, Running Totals and the Cut Line Pro
- Traceability to Objectives: Orphan Requirements, a Trace Matrix, Objective Coverage and Wasted Effort Pro
- As-Is vs To-Be: Hand-Offs, Cost per Order with Rework, Yearly Savings and the Biggest Gap Pro
- Capstone – Business Case & Change Requests: Net Cash Flow, NPV, Schedule Shift with WORKDAY and Approve/Defer Pro