Skillnaija Start free

BUSINESS

Analytics & Modelling for Consultants

Build a model that ties, stress it until it breaks, and say exactly where the answer flips.

  • 12 lessons
  • ~3 hours
  • Intermediate
  • Project + certificate

Free account required to open the lessons. Any price is shown before you pay.

What you'll learn

  • Write the decision a model exists to serve, and cut every tab that cannot change it
  • Wire a P&L, balance sheet and cash flow so they genuinely tie, with three visible checks and no plug
  • Resolve interest circularity honestly instead of switching on iterative calculation
  • Drive every model from one assumptions sheet where each row carries a value, a unit, a source and a date
  • Split revenue into volume times price, and costs into quantity times rate, so sensitivity is nearly free
  • Model working capital in days and find the month a business actually runs out of cash
  • Build a revenue forecast bottom-up, triangulate it top-down, and check it against physical capacity
  • Classify costs as variable, fixed or stepped, and name the volume at which the next step is triggered
  • Rank which assumptions move the answer, cross the top two in a table, and state the flip point in words
  • Build three internally consistent scenarios with correlated shocks, and report the cash low point in each
  • Judge an investment on payback, NPV and IRR while keeping cash flows and the discount rate consistently nominal or real
  • Audit a model you were handed and separate mechanical errors from assumption disputes and structural limits
  • Produce a defensible number by counting, sampling and triangulation when the data does not exist
  • Compress a finished model onto one page a chief executive will read, with its limits stated

About this course

The second course in the Consulting Mastery sequence, and the one that turns a defensible question into arithmetic somebody can check. It assumes you can already drive a spreadsheet — lookups, pivots, charts — and teaches instead the judgement that spreadsheet skill does not confer: what to model and what to leave out, how to wire three statements so they genuinely tie rather than balancing on a plug, why every human-chosen number belongs on one assumptions sheet with its unit, source and date, and how to split revenue into volume and price so the model can tell you which problem you actually have. It puts working capital where it belongs — at the centre — because a Nigerian business rarely fails from a bad month and often fails from a good one it could not fund, and because the cash conversion cycle decides whether growth is survivable. It then does the part that separates advice from arithmetic: ranking which two or three assumptions actually move the answer, crossing them in a table a client can locate their own beliefs on, and back-solving to the point at which the recommendation reverses. Costs are classified by how they behave rather than what they are called, so the step where a second shift, a third van or a bigger generator lands is visible before the client grows into a loss, and energy is modelled from litres and grid hours rather than as a small fixed overhead. The last third covers what nobody teaches: auditing a model somebody hands you and reporting it as findings rather than a verdict, producing defensible numbers by counting and triangulation when the records simply do not exist, and compressing everything onto the one page a chief executive will actually read. It ships with a 24-month operating dataset for a synthetic Nigerian packaging manufacturer, and the capstone is a working three-statement model built on it.

Most business models fail long before a formula breaks. They fail because nobody wrote down the question the model exists to answer, so it grows tabs the way a house grows clutter — one for competitors, one for staff, one somebody built in week two and cannot now explain — until it is large, slow, impressive and incapable of settling anything. A consulting model is not a description of a business. It is an argument, expressed in arithmetic, that some course of action is better than another, and every sheet in it either serves that argument or should not exist.

Who it's for

Intermediate. Some grounding in the subject will help you move faster.

The lessons 12 lessons, ending in a graded project

  1. 1A model is an argument, not a spreadsheet15 min
  2. 2The three statements, and the check that they tie17 min
  3. 3Drivers, not hardcodes15 min
  4. 4Working capital, where Nigerian businesses actually die17 min
  5. 5Forecasting revenue you can defend in the room16 min
  6. 6Costs that move, costs that stay, and costs that jump16 min
  7. 7Sensitivity: find the point where the answer flips16 min
  8. 8Scenarios: three worlds, named and defended15 min
  9. 9Is it worth it? Payback, discounting and the honest investment case17 min
  10. 10Auditing a model — theirs, and your own16 min
  11. 11When the data does not exist: research that holds up18 min
  12. 12One page a chief executive will actually read15 min
  13. Project: A three-statement model, stressed, with its flip point namedGraded

THE PROJECT AND YOUR CERTIFICATE

A three-statement model, stressed, with its flip point named

A link to your model (Google Sheets, or an Excel file shared from Drive or OneDrive, with view access confirmed working), plus a written summary of roughly 800 to 1,400 words containing: what the three checks read; your assumptions sheet described, including the units, sources and dates; the cash conversion cycle in days, the lowest cash balance and its month; the bottom-up build with its top-down triangulation, the gap between them, the capacity check and the implied growth rate; the cost classification with the exchange-rate-exposed share and the named step-cost trigger; the sensitivity ranking, the two-way table's values and the flip point stated in words; the three named scenarios with outcome, margin, cash low point and month for each; and the one-page executive summary reproduced in full.

Certificates on Skillnaija are earned, not issued for attendance: you submit this project, an examiner grades the real work against a published rubric (you need 65% to pass), and passing issues a certificate anyone can verify. If you don't pass yet, you get written feedback and can try again.

  • The model is structurally sound and genuinely ties: three statements present and linked, a visible check block whose three rows are reported and read correctly in every period, interest circularity resolved by a stated method rather than iterative calculation, and no plug or balancing line anywhere25%
  • The model is driven, not hardcoded: one assumptions sheet with every row carrying value, unit, source and date; no typed values inside formulas beyond arithmetic constants; revenue built as volume times price and at least three cost lines as quantity times rate, with energy driven from hours, litres and price rather than as a share of revenue15%
  • Working capital is modelled properly: inventory, receivable and payable days each derived from the supplied history rather than assumed, the cash conversion cycle stated, and the lowest cash balance identified with the exact month it occurs and any financing requirement quantified15%
  • The forecast is defensible: built bottom-up from physical quantities, triangulated against an independent top-down estimate with the gap stated and a choice made between them, checked against a named physical capacity constraint, carrying an explicit seasonality index derived from the history, with the implied growth rate stated as an inspected output15%
  • Risk is analysed rather than displayed: assumptions ranked over evidenced and possibly asymmetric ranges, the top two crossed in a two-way table, the flip point stated in plain words as a condition on two named variables, and three internally consistent named scenarios whose bad case moves correlated variables together, each reporting outcome, margin, cash low point and month20%
  • The executive page does its job: a single-sentence recommendation leading, no more than four supporting numbers each of which would change an action if it changed, the flip point marked on the grid, and an honest limits box naming exclusions, estimates, what would make the recommendation wrong and the earliest warning indicator10%

See the full project brief, rubric and free workbook →

Frequently asked questions

Is Analytics & Modelling for Consultants free?

Most Skillnaija courses can be started free with a free account: your first two courses are free to start, then one new course each month. Some courses are paid; the course page in the app shows whether Analytics & Modelling for Consultants is one, and its price, before you pay. You can also buy any course on its own for twelve months, or open every course with the All-Access Pass. Certificates are never sold: you earn one by passing the course's project.

How long does Analytics & Modelling for Consultants take to complete?

6 weeks · ~4 hrs/week. There are 12 lessons, about 3 hours of material in total. You learn at your own pace and your progress is saved.

Do I need any experience to start Analytics & Modelling for Consultants?

Intermediate. Some prior grounding in the subject will help you move faster.

What will I learn in Analytics & Modelling for Consultants?

You will build practical skills in Write the decision a model exists to serve, and cut every tab that cannot change it, Wire a P&L, balance sheet and cash flow so they genuinely tie, with three visible checks and no plug, Resolve interest circularity honestly instead of switching on iterative calculation, Drive every model from one assumptions sheet where each row carries a value, a unit, a source and a date, Split revenue into volume times price, and costs into quantity times rate, so sensitivity is nearly free, Model working capital in days and find the month a business actually runs out of cash, Build a revenue forecast bottom-up, triangulate it top-down, and check it against physical capacity, Classify costs as variable, fixed or stepped, and name the volume at which the next step is triggered, Rank which assumptions move the answer, cross the top two in a table, and state the flip point in words, Build three internally consistent scenarios with correlated shocks, and report the cash low point in each, Judge an investment on payback, NPV and IRR while keeping cash flows and the discount rate consistently nominal or real, Audit a model you were handed and separate mechanical errors from assumption disputes and structural limits, Produce a defensible number by counting, sampling and triangulation when the data does not exist, Compress a finished model onto one page a chief executive will read, with its limits stated. Every lesson is written in plain English, with examples drawn from how the work is actually done and paid for, in Nigeria and beyond.

Do I get a certificate for Analytics & Modelling for Consultants?

Yes, but it has to be earned. You complete the course project — A three-statement model, stressed, with its flip point named and submit it for grading. Passing the project issues a verifiable certificate; finishing the lessons alone does not.

Ready to start Analytics & Modelling for Consultants?

It is self-paced, and it ends with something you can show an employer.

Start learning free