Data Analysis Test

Q: What are the main Data Analysis related tests?

Some key data-related tests are: Data Analytics in AWS Test Data Analytics in Azure Test Data Science Assessment Test

The Data Analysis Test assesses a candidate's ability to handle, modify, analyze and interpret data. The test uses scenario-based MCQ questions to screen for experience with analyzing data to find possible outcomes, detect anomalies, extract meaningful insights, project estimates and visualize data using charts and graphs. The test has 15 MCQ questions on data analysis, business analysis, data interpretation and SQL. The test will be customized according to your data analyst job description so that the questions and topics are relevant to your company.

Covered skills:

Basics of data modelling (Entities and Relations)
Basics of data analysis (Aggregations and Statistics)
Business analysis fundamentals
Data interpretation (Charts and Graphs)
Data queries and databases (SQL)
Data operations (Predictions and Anomalies)
Data investigations (Correlations and Ranking)
Popular data tools (Excel)

Get started for free

Preview questions

About the Data Analysis Assessment Test

The Data Analysis Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

Understanding the basics of data modelling including entities and relations
Applying data analysis techniques such as aggregations and statistics
Applying fundamentals of business analysis
Interpreting data using charts and graphs
Executing data queries and utilizing databases using SQL
Performing data operations including predictions and anomalies
Conducting data investigations including correlations and ranking
Utilizing popular data tools like Excel

1200+ customers in 80 countries

Use Adaface tests trusted by recruitment teams globally. Adaface skill assessments measure on-the-job skills of candidates, providing employers with an accurate tool for screening potential hires.

Get started for free

Preview questions

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

These are just a small sample from our library of 15,000+ questions. The actual questions on this Data Analysis Test will be non-googleable.

🧐 Question
Medium Hiring Developer Skewed Data Graph	Solve
Two companies A and B hired developers from the year 2001 to 2005. The given bar graph shows the hiring details. Now select the statements that are true based on the given details. A: The data given for Company A is skewed to the left. B: The data given for Company B is skewed to the right. C: The data given for Company A is skewed to the right. D: For Company B, mean and mode are equal. E: For Company B, mean is equal to median but less than mode. F: For Company A, median is less than mode but greater than mean.
Medium Negative correlation Correlation Association	Solve
Saffi, one of the popular schools in San Francisco did a school wide study of the students in middle school. The study found that there is a negative correlation between the time spent on Facebook per day by students and their academic achievement. How can we understand the results of this study? A: An increase in time spent on Facebook per day causes a drop in the academic achievement of students at the middle school level. B: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at Saffi. C: An increase in the time spent on Facebook per day causes a drop in the academic achievement of students at Saffi. D: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at the middle school level.
Medium Multi Select JOIN GROUP BY Sql Join Data Analysis	Solve
Consider the following SQL table: How many rows does the following SQL query return?
Medium nth highest sales Nested queries User Defined Functions	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
Medium Select & IN Nested queries	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
Medium Sorting Ubers Nested queries Join Comparison operators	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
Hard With, AVG & SUM MAX() MIN() Aggregate functions	Solve
Consider the following SQL table: How many tuples does the following query return?
Medium Dividends Financial Analysis Percentage and Average Calculations	Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
Medium Laptop Brands Proportions and Percentages Financial Reasoning Cost Price Ratio Calculation Percentage Profit Calculation	Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
Hard Median Trend Analysis Statistical Reasoning Median Calculation Percentage Change Calculation	Solve
Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

	🧐 Question	🔧 Skill
	Medium Hiring Developer Skewed Data Graph	3 mins Data Analysis	Solve
Two companies A and B hired developers from the year 2001 to 2005. The given bar graph shows the hiring details. Now select the statements that are true based on the given details. A: The data given for Company A is skewed to the left. B: The data given for Company B is skewed to the right. C: The data given for Company A is skewed to the right. D: For Company B, mean and mode are equal. E: For Company B, mean is equal to median but less than mode. F: For Company A, median is less than mode but greater than mean.
	Medium Negative correlation Correlation Association	2 mins Data Analysis	Solve
Saffi, one of the popular schools in San Francisco did a school wide study of the students in middle school. The study found that there is a negative correlation between the time spent on Facebook per day by students and their academic achievement. How can we understand the results of this study? A: An increase in time spent on Facebook per day causes a drop in the academic achievement of students at the middle school level. B: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at Saffi. C: An increase in the time spent on Facebook per day causes a drop in the academic achievement of students at Saffi. D: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at the middle school level.
	Medium Multi Select JOIN GROUP BY Sql Join Data Analysis	2 mins SQL	Solve
Consider the following SQL table: How many rows does the following SQL query return?
	Medium nth highest sales Nested queries User Defined Functions	3 mins SQL	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Medium Select & IN Nested queries	3 mins SQL	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Medium Sorting Ubers Nested queries Join Comparison operators	3 mins SQL	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	Hard With, AVG & SUM MAX() MIN() Aggregate functions	2 mins SQL	Solve
Consider the following SQL table: How many tuples does the following query return?
	Medium Dividends Financial Analysis Percentage and Average Calculations	3 mins Data Interpretation	Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
	Medium Laptop Brands Proportions and Percentages Financial Reasoning Cost Price Ratio Calculation Percentage Profit Calculation	2 mins Data Interpretation	Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
	Hard Median Trend Analysis Statistical Reasoning Median Calculation Percentage Change Calculation	3 mins Data Interpretation	Solve
Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

	🧐 Question	🔧 Skill	💪 Difficulty	⌛ Time
	Hiring Developer Skewed Data Graph	Data Analysis	Medium	3 mins	Solve
Two companies A and B hired developers from the year 2001 to 2005. The given bar graph shows the hiring details. Now select the statements that are true based on the given details. A: The data given for Company A is skewed to the left. B: The data given for Company B is skewed to the right. C: The data given for Company A is skewed to the right. D: For Company B, mean and mode are equal. E: For Company B, mean is equal to median but less than mode. F: For Company A, median is less than mode but greater than mean.
	Negative correlation Correlation Association	Data Analysis	Medium	2 mins	Solve
Saffi, one of the popular schools in San Francisco did a school wide study of the students in middle school. The study found that there is a negative correlation between the time spent on Facebook per day by students and their academic achievement. How can we understand the results of this study? A: An increase in time spent on Facebook per day causes a drop in the academic achievement of students at the middle school level. B: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at Saffi. C: An increase in the time spent on Facebook per day causes a drop in the academic achievement of students at Saffi. D: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at the middle school level.
	Multi Select JOIN GROUP BY Sql Join Data Analysis	SQL	Medium	2 mins	Solve
Consider the following SQL table: How many rows does the following SQL query return?
	nth highest sales Nested queries User Defined Functions	SQL	Medium	3 mins	Solve
Consider the following SQL table: Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
	Select & IN Nested queries	SQL	Medium	3 mins	Solve
Consider the following SQL table: Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
	Sorting Ubers Nested queries Join Comparison operators	SQL	Medium	3 mins	Solve
Consider the following SQL table: What will be the first two tuples resulting from the following SQL command?
	With, AVG & SUM MAX() MIN() Aggregate functions	SQL	Hard	2 mins	Solve
Consider the following SQL table: How many tuples does the following query return?
	Dividends Financial Analysis Percentage and Average Calculations	Data Interpretation	Medium	3 mins	Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
	Laptop Brands Proportions and Percentages Financial Reasoning Cost Price Ratio Calculation Percentage Profit Calculation	Data Interpretation	Medium	2 mins	Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
	Median Trend Analysis Statistical Reasoning Median Calculation Percentage Change Calculation	Data Interpretation	Hard	3 mins	Solve
Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

Get started for free

Preview questions

With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!

Brandon Lee, Head of People, Love, Bonito

It's very easy to share assessments with candidates and for candidates to use. We get good feedback from candidates about completing the tests. Adaface are very responsive and friendly to deal with.

Kirsty Wood, Human Resources, WillyWeather

We were able to close 106 positions in a record time of 45 days! Adaface enables us to conduct aptitude and psychometric assessments seamlessly. My hiring managers have never been happier with the quality of candidates shortlisted.

Amit Kataria, CHRO, Hanu

We evaluated several of their competitors and found Adaface to be the most compelling. Great library of questions that are designed to test for fit rather than memorization of algorithms.

Swayam Narain, CTO, Affable

Why you should use Pre-employment Data Analysis Test?

The Data Analysis Test makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects:

Basics of data modelling (Entities and Relations)
Basics of data analysis (Aggregations and Statistics)
Business analysis fundamentals
Data interpretation (Charts and Graphs)
Data queries and databases (SQL)
Data operations (Predictions and Anomalies)
Data investigations (Correlations and Ranking)
Popular data tools (Excel)
Data modelling techniques (Normalization and Indexing)
Data analysis methods (Regression and Time Series)

Once the test is sent to a candidate, the candidate receives a link in email to take the test. For each candidate, you will receive a detailed report with skills breakdown and benchmarks to shortlist the top candidates from your pool.

What topics are covered in the Data Analysis Test?

Basics of data modelling (Entities and Relations): Data modelling involves designing the structure of a database, identifying the entities (objects or concepts) and their relationships. This skill is measured in the test to evaluate the candidate's ability to organize and represent data effectively, ensuring data integrity and optimizing database performance.

Basics of data analysis (Aggregations and Statistics): Data analysis involves examining, cleansing, transforming, and modeling data to uncover meaningful insights. This skill is measured in the test to assess the candidate's familiarity with key concepts like aggregations (sums, averages, etc.) and statistical measures (mean, median, etc.), enabling them to explore, summarize, and interpret data accurately.

Business analysis fundamentals: Business analysis involves identifying business needs, recommending solutions, and facilitating the implementation of changes. This skill is measured in the test to gauge the candidate's understanding of essential techniques and tools used in business analysis, such as SWOT analysis, stakeholder analysis, and requirements elicitation, to ensure their proficiency in analyzing and solving business problems.

Data interpretation (Charts and Graphs): Data interpretation involves understanding and deriving insights from visual representations like charts and graphs. This skill is measured in the test to evaluate the candidate's ability to interpret and analyze data visually, enabling them to effectively communicate important findings and trends to stakeholders.

Data queries and databases (SQL): Data queries and databases involve using Structured Query Language (SQL) to retrieve, manipulate, and manage data in relational database systems. This skill is measured in the test to assess the candidate's proficiency in writing SQL queries, ensuring they can effectively extract and manipulate data to support various business requirements.

Data operations (Predictions and Anomalies): Data operations involve predicting future outcomes and identifying anomalies or outliers in data. This skill is measured in the test to ascertain the candidate's knowledge and ability in using statistical techniques, machine learning algorithms, and data mining methods to perform predictive modeling and anomaly detection for valuable data-driven insights.

Data investigations (Correlations and Ranking): Data investigations involve exploring relationships between variables, identifying correlations, and ranking data based on specific criteria. This skill is measured in the test to evaluate the candidate's capability to analyze and interpret statistical relationships, enabling them to uncover patterns, make informed decisions, and identify key factors influencing outcomes.

Popular data tools (Excel): Popular data tools include software applications like Microsoft Excel, which offer features for data analysis, manipulation, and visualization. This skill is measured in the test to determine the candidate's proficiency in using Excel's advanced functions, formulas, and features for data processing, analysis, and reporting, thereby assessing their ability to leverage this widely used data tool effectively.

Full list of covered topics

The actual topics of the questions in the final test will depend on your job description and requirements. However, here's a list of topics you can expect the questions for Data Analysis Test to be based on.

Data Modelling

Entities

Relations

Aggregations

Statistics

Business Analysis

Data Interpretation

Charts

Graphs

Data Queries

Databases

SQL

Data Operations

Predictions

Anomalies

Data Investigations

Correlations

Ranking

Data Tools

Excel

Data Analysis

Basics

Understanding Data

Statistical Analysis

Business Fundamentals

Visualization

Pivot Tables

Normalization

Joins

Subqueries

Conditional Filtering

Grouping and Summarizing

Data Cleaning

Hypothesis Testing

Regression Analysis

Decision Trees

Time Series Analysis

Data Presentation

Data Manipulation

Data Visualization

Data Mining

Data Warehousing

Data Integration

Data Security

Data Governance

Data Quality

Data Transformation

Data Analysis Techniques

Descriptive Statistics

Inferential Statistics

Exploratory Data Analysis

Statistical Modeling

Forecasting

Data Patterns

Data Patterns Recognition

BI Reporting

Data Mining Techniques

Qualitative Analysis

Quantitative Analysis

Dashboard Design

What roles can I use the Data Analysis Test for?

Data Analyst
Senior Data Analyst
Data Analyst SQL
Marketing Analyst
Business Analyst
Data Assistant

How is the Data Analysis Test customized for senior candidates?

For intermediate/ experienced candidates, we customize the assessment questions to include advanced topics and increase the difficulty level of the questions. This might include adding questions on topics like

Data interpretation techniques (Data Visualization and Geospatial Analytics)
Data querying and optimization strategies
Data manipulation and transformation techniques
Data investigation techniques (Causal Inference and Machine Learning)
Specialized data analysis tools (Tableau, Power BI)
Data governance and data quality management
Designing and implementing complex database systems
Experience in conducting root cause analysis and performance tuning

Preview this test

View sample scorecard

Try the most advanced candidate assessment platform

ChatGPT Protection

Non-googleable Questions

Web Proctoring

IP Proctoring

Webcam Proctoring

MCQ Questions

Coding Questions

Typing Questions

Personality Questions

Custom Questions

Ready-to-use Tests

Custom Tests

Custom Branding

Bulk Invites

Public Links

ATS Integrations

Multiple Question Sets

Custom API integrations

Role-based Access

Priority Support

GDPR Compliance

Screen candidates in 3 easy steps

Pick a test from over 500+ tests

The Adaface test library features 500+ tests to enable you to test candidates on all popular skills- everything from programming languages, software frameworks, devops, logical reasoning, abstract reasoning, critical thinking, fluid intelligence, content marketing, talent acquisition, customer service, accounting, product management, sales and more.

Invite your candidates with 2-clicks

Make informed hiring decisions

Get started for free

Preview questions

Have questions about the Data Analysis Hiring Test?

What is the Data Analysis Test?

The Data Analysis Test evaluates candidates on their ability to understand, interpret, and analyze data. It is used by recruiters to identify candidates with strong data analysis skills quickly. Useful for data-centric roles.

Can I combine the Data Analysis test with SQL questions?

Yes, recruiters can create a custom test that includes both Data Analysis and SQL questions. For more details on assessing SQL skills, check the SQL Online Test.

What kind of questions are used to evaluate senior candidates in the Data Analysis Test?

For senior roles, the test includes questions on data interpretation techniques, data querying and optimization strategies, specialized analysis tools (such as Tableau or Power BI), and root cause analysis.

How to use the Data Analysis Test in my hiring process?

We recommend using the Data Analysis Test at the early stages of your recruitment process. Include a link to the assessment in your job post or invite candidates directly by email. Adaface helps you find skilled candidates faster.

What are the main Data Analysis related tests?

Some key data-related tests are:

Can I combine multiple skills into one custom assessment?

Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify. Here's a quick guide on how you can request a custom test.

Do you have any anti-cheating or proctoring features in place?

We have the following anti-cheating features in place:

Non-googleable questions
IP proctoring
Screen proctoring
Web proctoring
Webcam proctoring
Plagiarism detection
Secure browser
Copy paste protection

Read more about the proctoring features.

How do I interpret test scores?

The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

What experience level can I use this test for?

Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

Does every candidate get the same questions?

Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

I'm a candidate. Can I try a practice test?

No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

What is the cost of using this test?

You can check out our pricing plans.

Can I get a free trial?

Yes, you can sign up for free and preview this test.

I just moved to a paid plan. How can I request a custom assessment?

Here is a quick guide on how to request a custom assessment on Adaface.

View sample scorecard

Along with scorecards that report the performance of the candidate in detail, you also receive a comparative analysis against the company average and industry standards.

View sample scorecard