AI & Data
Data Analyst (SQL and Power BI) Practice Test
20 multiple choice questions for data analysts: SQL, Power BI and DAX, data modelling, statistics and clear reporting.
- Questions
- 20
- Time
- 20 min
- Pass mark
- 60%
No account or email needed.
About this test
This test is built around the Data Analyst (SQL and Power BI) role. It covers SQL, the Power BI concepts you meet daily, a few statistics ideas that prevent wrong conclusions, and how to build reports people actually use.
It is practice only and is not part of any job application.
What it covers
The question set has 24 questions: 15 easy, 8 medium and 1 hard. Each attempt draws 20 of them at random, so a second try is not the same test.
- Analysis and statistics (7)
- Power BI (7)
- SQL (10)
Try a few sample questions
These are real questions from the set, with the answers and a short explanation. Read the question, decide, then open it to check.
Sample 1 · SQL · easyWhich clause filters individual rows before they are grouped?Show the answer
- HAVING
- WHERECorrect
- GROUP BY
- ORDER BY
WHERE filters rows before grouping. HAVING filters the groups afterwards.
Sample 2 · Power BI · easyWhat is DAX?Show the answer
- A chart type
- A formula language for calculations in Power BICorrect
- A database
- A file format
Data Analysis Expressions are used for measures, calculated columns and tables.
Sample 3 · Analysis and statistics · easyWhich chart is usually best to show a trend over time?Show the answer
- Pie chart
- Line chartCorrect
- Scatter of random points
- Table only
Lines make change over time easy to read.
How it works
- 20 multiple choice questions, drawn at random from a larger set.
- 20 minutes on the clock. The test submits itself when time runs out.
- Pass mark: 60%.
- No marks are taken off for wrong answers, so answer every question.
- Some questions have more than one correct answer. You must pick all of them to score.
- When you finish you see your score, the correct answers and a short explanation for each.
- Your answers save as you go, so a dropped connection will not lose your work.
- Please stay on the test page. Switching to another tab or window is recorded and you will see a warning.
- Copying text, printing and screenshots are not allowed during the test.
This role is open
This test is built around the Data Analyst (SQL and Power BI) role on our jobs board. Taking it is not part of the application.
See the roleMore practice tests
- AI and Automation Engineer Practice TestAI & Data
- Data Engineer Practice TestAI & Data
- Machine Learning Engineer Practice TestAI & Data
- Workflow Automation Developer Practice TestAI & Data
See all practice tests.