Skip to content

7-Day Data 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 1SQL foundations
  • Revise joins, GROUP BY, HAVING and the logical order of execution
  • Solve 10 practice queries on joins and aggregation
  • Practise NULL handling with COALESCE and NULLIF
  • Write down three join mistakes and how to check for them
Day 2Advanced SQL
  • Practise ROW_NUMBER, RANK, LAG and running totals
  • Solve top N per group and consecutive days problems
  • Write a retention or churn query from scratch
  • Explain one query's execution plan aloud
Day 3Excel and data cleaning
  • Revise XLOOKUP, SUMIFS, FILTER, UNIQUE and PivotTables
  • Clean a messy sample file in Power Query end to end
  • Practise handling duplicates, text numbers and mixed dates
  • Build a small dynamic summary with slicers
Day 4Power BI or Tableau
  • Build a star schema model with a date table
  • Write CALCULATE, YoY and running total measures, or Tableau LOD and table calcs
  • Review filter context or Tableau order of operations
  • Rebuild one KPI dashboard page in under an hour
Day 5Python and statistics
  • Practise pandas groupby, merge, pivot_table and date handling
  • Revise mean, median, standard deviation, percentiles and z-scores
  • Revise p-values, confidence intervals and A/B test design
  • Solve two hypothesis testing examples by hand
Day 6Case studies and KPIs
  • Solve two case questions: a sales drop and a guesstimate
  • Draw a KPI tree for an e-commerce business
  • List KPIs for HR, support and sales dashboards
  • Practise explaining one case solution in five minutes
Day 7Projects, storytelling and HR
  • Prepare a two-minute walkthrough of your best project with impact numbers
  • Write STAR answers for five behavioural questions
  • Rewrite your project chart titles as action titles
  • Do one full mock interview and note weak areas

Frequently asked questions

Can I prepare for a Data 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.