ADF Data Science Data Analyst Interview Questions and Answers

Basics related to stats and aptitude questions. Level was moderate to tough.

Very easy coding question for the python or c programming language

Q1. First round of interview was the tecnical interview , data analysis and basic data managemet questions were asked.
Add your answer

Q1. Tableau, python, previous projects
Add your answer
Q2. Natural language processing, regression
Add your answer

Clustering code on cricket anslytics

Audit assurance case study… examples and estimation

Focus on little bit of dynamic programming

Q1. Apache spark architecture and ecosystem along with memory management
Add your answer
Q2. SQL queries for manager salary
Add your answer
Q3. Python decorators --> @
Add your answer
Q4. RANK and other window functions
Add your answer
Q5. Joins along with use case
Ans. 
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Use cases for joins include combining customer data with order data, merging employee information with department details
Answered by AI
Add your answer

Q1. Why data analysis and data science
Ans. 
Data analysis and data science are crucial for extracting valuable insights from large datasets to drive informed decision-making.
• Data analysis and data science help in uncovering patterns and trends within data.

• They enable businesses to make data-driven decisions for improved efficiency and effectiveness.

• These fields also play a vital role in predictive analytics and forecasting.

• Examples include using machine learning...read more
Answered by AI
Add your answer
Q2. Why pgdm in business analytics
Ans. 
PGDM in Business Analytics provides specialized knowledge and skills for analyzing data to drive business decisions.
• Specialized curriculum focusing on data analysis techniques and tools

• Hands-on experience with real-world data sets

• Opportunities for networking with industry professionals

• Career advancement in the field of business analytics
Answered by AI
Add your answer

Asked about Numpy , Panads . Some operations of data slicing . 3 problems of python coding .

Q1. What is standard deviation ? state formula for standard deviation
Ans. 
Standard deviation is a measure of the amount of variation or dispersion of a set of values.
• Standard deviation is calculated as the square root of the variance.

• It measures how spread out the values in a data set are around the mean.

• A higher standard deviation indicates more variability in the data.

• Formula for standard deviation: sqrt(Σ(x - μ)² / N), where x is each value, μ is the mean, and N is the number of values.
Answered by AI
Add your answer
Q2. What is correlation , regression , gradient descent
Ans. 
Correlation measures the relationship between two variables, regression predicts a dependent variable based on independent variables, and gradient descent is an optimization algorithm for finding the minimum of a function.
• Correlation measures the strength and direction of a linear relationship between two variables. It ranges from -1 to 1.

• Regression is a statistical technique used to model the relationship between a de...read more
Answered by AI
Add your answer
Q3. What is R square
Ans. 
R square is a statistical measure that represents the proportion of the variance for a dependent variable that's explained by an independent variable.
• R square ranges from 0 to 1, with 1 indicating a perfect fit.

• It is used to evaluate the goodness of fit of a regression model.

• A higher R square value indicates that the model explains a larger proportion of the variance in the dependent variable.
Answered by AI
Add your answer
Q4. How will you select columns ?
Ans. 
I will select columns based on relevance to the analysis goals and data quality.
• Identify columns relevant to the analysis goals

• Consider data quality and completeness of each column

• Remove redundant or irrelevant columns

• Use statistical methods or domain knowledge to prioritize columns
Answered by AI
Add your answer