CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Data Analyst mock test: free online practice

15 to 30 random questions in 15 to 30 minutes, by the level you choose: sql, excel, statistics, cleaning, charts, kpis, a/b tests, cases. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.

Want to revise first? Read the Data Analyst interview questions and answers.

Choose your experience

Free with a CoreHRx Jobs account: you will be asked to sign in or create one first.

What does the Data Analyst mock test cover?

The test covers 13 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.

  • SQL Joins and Windows
  • SQL Queries
  • Excel for Analysis
  • A/B Testing
  • Descriptive Statistics
  • Data Cleaning
  • KPIs and Metrics
  • Python for Analysis
  • Probability
  • Business Case Questions
  • Data Modelling Basics
  • Data Visualization
  • Data Storytelling

Sample Data Analyst mock test questions

One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.

  1. FresherData Visualization

    You need to compare the sales of 7 product categories in one quarter as accurately as possible. Which chart works best?

    • A 3D pie chart with one slice for each category
    • A scatter plot of category name against sales
    • A bar chart with the bars sorted from largest to smallest
    • A line chart that joins the categories in order
    Show the answer

    Answer: A bar chart with the bars sorted from largest to smallest. People compare lengths from a common baseline far more accurately than angles or areas, so bars beat pies, and sorting puts the ranking in view. A line implies a continuous order between categories that does not exist.

  2. Intermediate (1-5 years)KPIs and Metrics

    An app has 60,000 monthly active users and an average of 12,000 daily active users. What is its DAU/MAU stickiness?

    • 5%
    • 20%
    • 50%
    • 500%
    Show the answer

    Answer: 20%. Stickiness is average DAU divided by MAU: 12,000 / 60,000 = 0.2, so a typical monthly user opens the app on about 20% of days, roughly 6 days a month. Higher values mean more habitual use.

  3. Experienced (5+ years)Descriptive Statistics

    For x = 1, 2, 3, 4, 5, 6 and y = 2, 3, 4, 5, 6, 60, what are Pearson r and Spearman rho?

    • Pearson about 0.70, Spearman 0.70
    • Pearson about 0.99, Spearman 1.00
    • Pearson about 0.70, Spearman 1.00
    • Pearson about 1.00, Spearman 0.70
    Show the answer

    Answer: Pearson about 0.70, Spearman 1.00. y rises every time x rises, so the ranks agree perfectly and Spearman is 1. Pearson measures straight-line fit, and the single 60 pulls the points far off any line, cutting r to about 0.70. Spearman resists such outliers.

Take the full Data Analyst mock test: 15 to 30 questions and 15 to 30 minutes, by level.

How is the Data Analyst mock test scored?

A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.

  • 75% or more in a topica strength
  • 50% to 74%worth a revision
  • Under 50%a topic to work on

Data Analyst mock test: questions people ask

Is the Data Analyst mock test free?

Yes. The Data Analyst mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.

How many questions are in the Data Analyst mock test?

It depends on the level: Fresher has 15 questions in 15 minutes, Intermediate has 20 questions in 20 minutes, Experienced has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of Data Analyst questions at your level, so every attempt is different.

Which Data Analyst topics does the test cover?

The questions cover SQL Joins and Windows, SQL Queries, Excel for Analysis, A/B Testing, Descriptive Statistics, Data Cleaning, KPIs and Metrics, Python for Analysis, Probability, Business Case Questions, Data Modelling Basics, Data Visualization, Data Storytelling. Your result shows how you did in each topic.

Which level should I choose?

Fresher if you are a student or have less than a year of experience, Intermediate for 1 to 5 years at work, and Experienced for 5 years or more.

Can employers see my Data Analyst score?

Only your best Data Analyst score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.

Can I take the Data Analyst mock test again?

Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.

All mock tests