Xtranet Technologies Data Analyst Interview Questions and Answers

SQL Test with 5 questions

Q1. Approach towards solving the SQL Queries from the test
Add your answer
Q2. Past Experiences
Add your answer

Q1. Resume related Questions
Add your answer
Q2. Power BI and SQL related questions. How to approach in a dashboard building process
Add your answer

Forecasting problem - Predict daily sku level sales

Q1. What is difference between bias and variance
Ans. 
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
• Bias is the error introduced by approximating a real-world problem, leading to underfitting.

• Variance is the error introduced by modeling the noise in the training data, leading to overfitting.

• High bias can cause a model to miss relevant relationships between features and target variable.

• High variance can cause a model to ...read more
Answered by AI
Add your answer
Q2. Parametric vs non parametruc model
Ans. 
Parametric models make strong assumptions about the form of the underlying data distribution, while non-parametric models do not.
• Parametric models have a fixed number of parameters, while non-parametric models have a flexible number of parameters.

• Parametric models are simpler and easier to interpret, while non-parametric models are more flexible and can capture complex patterns in data.

• Examples of parametric models inc...read more
Answered by AI
Add your answer

Aptitude test, basic maths and LR

SQL and Visualisation related

Q1. Asked for details after qualifying in test
Add your answer

Easy and moderate level question

Given a relevant topic and discussion on it

Q1. Introducd yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Reasoning and aptitude questions were asked

Q1. Interview was around python programming and team fitment
Add your answer

SQL Test with 5 questions

Q1. Approach towards solving the SQL Queries from the test
Add your answer
Q2. Past Experiences
Add your answer

Q1. Resume related Questions
Add your answer
Q2. Power BI and SQL related questions. How to approach in a dashboard building process
Add your answer

Q1. Basic questions about the role and responsibilities of my previous organisation
Add your answer

Q1. One on one round is about my skills
Add your answer