Skip to content
DevOps with Multi Cloud: new batch 25 Nov
novarynit: Training, Placement, Consulting

8 questions

Data Analytics interview questions and answers

Questions for data analyst roles: Excel, SQL, Power BI and basic statistics.

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.

+91

Free · no obligation

Book your free demo class

Leave your number and we will call you back.

  1. We will call you back in 5 minutes
  2. Attend a free demo class
  3. Join only if you like it