Skip to content

Business Analytics Last-Minute Revision

Quickly revise the questions you picked. Add questions from the interview-questions lists with Save to → Last-Minute Revision.

30 quick revision notes for Business Analytics

  1. A KPI is a metric tied to a strategic goal with a target; every KPI is a metric, but not every metric is a KPI.
  2. Profit equals revenue minus cost, and revenue equals price multiplied by volume; start profitability cases from this equation.
  3. MECE means mutually exclusive and collectively exhaustive: no overlap between parts and nothing left out.
  4. TAM is the total market, SAM the reachable part, and SOM the share you can realistically capture soon.
  5. Gross margin is revenue minus cost of goods sold divided by revenue; net margin includes all expenses and tax.
  6. CAC is sales and marketing spend divided by new customers; LTV to CAC around 3 to 1 is commonly considered healthy.
  7. Churn rate equals customers lost in a period divided by customers at the start of that period.
  8. Leading indicators predict outcomes, such as pipeline or activations; lagging indicators confirm them, such as revenue.
  9. WHERE filters individual rows before grouping happens, while HAVING filters the grouped results after aggregation.
  10. Logical SQL order: FROM, JOIN, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT.
  11. ROW_NUMBER is always unique, RANK skips after ties, DENSE_RANK does not skip after ties.
  12. A LEFT JOIN with a right-table condition in WHERE behaves like an INNER JOIN; move it to the ON clause.
  13. Revenue doubling after a join usually means fan-out from a one-to-many relationship; check grain before joining.
  14. COUNT(*) counts every row in the result, while COUNT(column) ignores rows where that column is NULL.
  15. UNION removes duplicates and is slower; UNION ALL keeps all rows and is faster.
  16. XLOOKUP and INDEX-MATCH can look left and handle inserted columns, unlike VLOOKUP with a fixed column number.
  17. Use $A$1 for absolute, A1 for relative, and $A1 or A$1 for mixed references; F4 cycles through them.
  18. SUMPRODUCT handles weighted totals and OR logic that SUMIFS cannot do directly.
  19. A calculated column is stored and computed row by row at refresh; a measure is computed at query time with filters.
  20. CALCULATE changes filter context in DAX and is the basis of time intelligence and percent-of-total measures.
  21. A star schema has one fact table linked to dimension tables, with single-direction filters from dimension to fact.
  22. Import mode is fastest, DirectQuery is near real time but slower, and live connection reuses a published model.
  23. In Tableau, FIXED LOD computes at stated dimensions, INCLUDE adds detail and EXCLUDE removes detail from the view.
  24. BRD captures what the business needs and why; FRD describes how the system must behave to meet it.
  25. A good user story follows As a, I want, so that, and meets INVEST with testable acceptance criteria.
  26. Definition of Ready decides if a story can enter a sprint; Definition of Done decides if it is complete.
  27. A sprint review demonstrates the product to stakeholders; a retrospective improves the team's process.
  28. The power-interest grid sorts stakeholders into manage closely, keep satisfied, keep informed and monitor.
  29. Stickiness equals DAU divided by MAU and shows how often monthly users return to the product.
  30. A p-value below 0.05 means the result is unlikely under no effect; fix sample size first and avoid stopping tests early.

Night-before checklist

  • Revise your saved questions on this page once, aloud.
  • Read the quick notes and mark any you cannot explain in one line.
  • Rehearse a two-minute self-introduction and two project stories.
  • Keep CV, ID, laptop charger and interview link ready; sleep on time.

Frequently asked questions

How does Last-Minute Revision work?

On any question page, open Save to → Last-Minute Revision. Saved questions appear here with their answers, so the night before an interview you revise only what you found hard.

Is my list saved?

Yes, in this browser. Guests can save 5 questions; free accounts can save 20 for revision and 100 for the 7-day plan.

What should I revise last before a Business Analytics interview?

Your saved misses first, then the quick notes on this page, then one or two project stories. Avoid learning brand-new topics the night before.