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.
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.
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.
Answer: What one row represents, for example one product on one order. Declaring the grain first, such as one row per product per order line, decides which measures and dimensions fit. Mixing grains, for example daily totals and single orders in one table, causes double counting.
A B
1 Date Amount
2 28-Mar-2024 500
3 01-Apr-2024 700
4 15-Apr-2024 300
5 30-Apr-2024 400
6 01-May-2024 900
E2: =SUMIFS(B2:B6,
A2:A6, ">="&DATE(2024,4,1),
A2:A6, "<"&DATE(2024,5,1))Answer: 1400. The two conditions keep dates from 1 April up to, but not including, 1 May, so 700 + 300 + 400 = 1400. Using >= with the first day and < with the first day of the next month stays correct even when cells hold a time too.
Answer: Agents closed tickets early to hit the target; pair it with reopen rate and CSAT. When a measure becomes a target it gets gamed (Goodhart's law): closing a ticket is easier than solving it. Balancing speed with reopen rate and satisfaction rewards resolved problems rather than fast closures.
Take the full Data Analyst mock test: 15 to 30 questions and 15 to 30 minutes, by level.
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.
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.
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.
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.
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.
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.
Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.