Data analyst interview prep

Advanced 1 hr 20 min 5 exercises

Focused data analyst interview prep covering the Excel workflows often tested in real assessments.

What you'll learn

  • Identify and remove duplicate records using COUNTIF with an expanding range
  • Build a customer cohort retention grid with COUNTIFS
  • Calculate stage-by-stage and end-to-end conversion rates for a marketing funnel
  • Rank items by frequency and isolate the 80/20 contributors with a Pareto analysis
  • Compare A/B test variants by computing lift, standard error, and a significance decision

Functions you'll practice

ABS COUNTIF COUNTIFS IF RANK SQRT SUM
Start track

Exercises in this track

0 of 5 completed 0%
1

Remove duplicate customer records

Intermediate

Use COUNTIF with an expanding range to mark which customer records to keep and which repeats to remove.

COUNTIF IF
Start
2

Build a basic cohort retention table

Intermediate

Build a customer cohort retention grid by counting each signup cohort and calculating what share stayed active in later months.

COUNTIF COUNTIFS
Start
3

Funnel conversion analysis

Advanced

Calculate conversion rates between each stage of a marketing funnel, plus overall conversion and stage-by-stage drop-off rates.

Start
4

Pareto analysis (80/20)

Advanced

Build a complete Pareto analysis ranking defect categories by frequency with cumulative percentages and 80/20 classification.

RANK SUM IF
Start
5

A/B test results analysis

Advanced

Compare two experiment variants by calculating conversion rates, percentage lift, standard errors, and a significance decision.

SQRT ABS IF
Start
Start track

Where to go next

Pick another track

Browse all learning tracks to find your next focus area.

Browse all tracks

Keep building your data skills

If you've got the Excel side down, DataCamp is a natural next step. It's hands-on like the exercises here, and it goes where Excel stops: into SQL and Python. Start free. The first lesson of every track is open.

Heads up: this is an affiliate link, so a purchase helps support the site.

Explore DataCamp career tracks

Want a recognized data credential?

If you're aiming for a data role, the Google Data Analytics Certificate is a solid on-ramp. It's beginner-friendly, employer-recognized, and self-paced. You can audit the courses for free, or apply for financial aid.

This is an affiliate link, so a purchase helps support the site.

Get the Google Data Analytics Certificate