Skip to content

7-Day Business Analytics Interview Preparation Plan

Your saved questions plus a day-by-day plan. Add questions with Save to → 7-Day Job Prep on any question page.

Day-by-day plan

Day 1Business fundamentals and KPIs
  • Revise revenue, margin, CAC, LTV, churn, ARPU and AOV definitions with one example each
  • Solve five quick metric calculations on paper
  • Write a KPI set with leading and lagging indicators for an e-commerce business
Day 2Excel deep practice
  • Practise XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS and dynamic arrays on a sample sales file
  • Build a PivotTable report with slicers and a chart
  • Create a break-even or what-if model using Goal Seek and a data table
Day 3SQL for analysis
  • Solve ten problems on joins, GROUP BY and HAVING
  • Practise ROW_NUMBER, RANK, LAG and running totals
  • Write queries for monthly revenue growth, top N per group and repeat purchase rate
  • Explain how you would debug a total that doubled after a join
Day 4Power BI or Tableau
  • Build a small star-schema model with a date table
  • Write DAX measures for total sales, YoY growth and percent of total
  • Design a one-page dashboard and prepare to explain each visual choice
Day 5Requirements and Agile
  • Write three user stories with Given-When-Then acceptance criteria
  • Draw an AS-IS and TO-BE process map for a refund process
  • Revise BRD vs FRD, Scrum ceremonies, DoR vs DoD and change control
Day 6Cases, guesstimates and product analytics
  • Solve two guesstimates aloud with a timer
  • Practise one profitability case and one metric-drop case with a MECE structure
  • Revise funnels, cohorts and A/B testing basics including sample size and guardrails
Day 7Behavioural and mock interview
  • Prepare six STAR stories: conflict, saying no, mistake, influence, deadline and impact
  • Rehearse your tell-me-about-yourself answer in 90 seconds
  • Do one full mock interview and review weak answers
  • Revise the 30 key revision points

Frequently asked questions

Can I prepare for a Business Analytics interview in 7 days?

Seven days is enough to revise and sharpen, not to learn from zero. Use the plan to cover each core topic once, practise questions daily and finish with a mock interview.

How do I add questions to the plan?

On any question page choose Save to → 7-Day Job Prep. Saved questions show up at the top of this page.

How many hours a day should I study?

Two to four focused hours a day works for most people: one hour of revision, one to two hours of questions, and the rest on projects or mock answers.