8 questions
Data Analytics interview questions and answers
Questions for data analyst roles: Excel, SQL, Power BI and basic statistics.
- Classroom and live onlineAmeerpet centre or from home
- Real-time projectsBuild work you can show
- Placement supportResume, mock interviews, guidance
- Free demo classSee a class before you join
What does a data analyst do?
Collects and cleans data, analyses it to answer business questions, and presents findings through reports and dashboards so teams can make decisions.
What is the difference between VLOOKUP and INDEX-MATCH?
VLOOKUP searches the first column of a range and returns a value to its right. INDEX-MATCH can look in any direction and does not break when columns are inserted. XLOOKUP now covers both.
What is a pivot table?
An Excel tool that summarises large tables by grouping rows and columns and calculating totals, counts or averages without formulas.
What is the difference between a measure and a calculated column in Power BI?
A calculated column is computed for each row and stored in the model. A measure is calculated at query time for the current filter context and is the right choice for aggregations.
What is DAX?
Data Analysis Expressions: the formula language of Power BI, used to write measures, calculated columns and tables.
How do you handle missing values?
First understand why they are missing. Then remove the rows, fill them with a sensible value such as the median, or flag them, depending on how much is missing and what the analysis needs.
What is the difference between mean, median and mode?
Mean is the average, median is the middle value and mode is the most frequent. The median is more reliable when the data has outliers.
What is the difference between correlation and causation?
Correlation means two variables move together. Causation means one causes the other. Correlation alone does not prove causation.
More topics
Next step
Practise these in a mock interview
Sit in a free demo class first. We will call you back in 5 minutes
- See a live class before you join
- Meet the trainer and review the syllabus
- Get a batch and timing that fits you
- Ask about EMI and placement support
Where to learn
Ameerpet, Hyderabad
3rd Floor, Green House, Ameerpet, Hyderabad, Telangana
Live online
Join the same class from anywhere, ask questions live and get the same project reviews.
Request your free demo
Takes 30 seconds. No payment needed.