I.E.S Public School Data Quality Analyst Interview Questions and Answers

Q1. Data Given on Excel to Solve.
Add your answer
Q2. Advanced Functions of Excel.
Ans. 
Advanced Excel functions enhance data analysis through powerful tools like VLOOKUP, INDEX, MATCH, and pivot tables.
• VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from a specified column. Example: =VLOOKUP(A2, B2:D10, 3, FALSE)

• INDEX & MATCH: A powerful combination for flexible lookups. Example: =INDEX(B2:B10, MATCH(A2, A2:A10, 0))

• Pivot Tables: Summarize large dataset...read more
Answered by AI
Add your answer

Q1. Excel assignment
Add your answer

Q1. Sql based one on one round
Add your answer
Q2. Excel based one on one round
Add your answer

Q1. Spreadsheet automation
Add your answer
Q2. Google sheet work
Add your answer

Q1. Why your interested
Add your answer
Q2. Why you want to Jon
Add your answer

Question about excel, pivot table , SQL and power bi

Q1. Sql question basic
Add your answer

Aptitude test aptitude test

Q1. Technical question. Excel power bi
Add your answer

Q1. Salary discussed
Add your answer

Q1. About your self
Add your answer
Q2. Technical based on ur role
Add your answer

Q1. Missing values outliers, over fitting underfitting
Add your answer

Q1. Outliers missing values, overfitting underfitting
Ans. 
Understanding outliers, missing values, overfitting, and underfitting in data science.
• Outliers are data points that significantly differ from other data points in a dataset.

• Missing values are data points that are not present in a dataset.

• Overfitting occurs when a model learns noise in the training data rather than the underlying pattern.

• Underfitting occurs when a model is too simple to capture the underlying pattern in...read more
Answered by AI
Add your answer