COMSPARK INNOV AND INFRA Business Intelligence Developer Analyst Interview Questions and Answers

Q1. Write a query to get first order for every customer in the year 2021
Ans. 
Query to retrieve the first order for each customer in 2021
• Use a subquery to find the minimum order date for each customer in 2021

• Join the subquery with the main table on customer ID and order date to get the first order
Answered by AI
Add your answer
Q2. How do you connect S3 and Lambda
Ans. 
S3 and Lambda can be connected using S3 event notifications to trigger Lambda functions.
• Set up an S3 bucket and create a Lambda function

• Configure the S3 bucket to send event notifications to the Lambda function

• Define the event type and prefix/suffix for triggering the Lambda function

• Lambda function will be automatically triggered when the specified event occurs in the S3 bucket
Answered by AI
Add your answer
Q3. What is Churn Rate? What is customer conversion rate?
Ans. 
Churn rate is the percentage of customers who stop using a product or service over a certain period of time. Customer conversion rate is the percentage of potential customers who take a desired action, such as making a purchase.
• Churn rate measures customer retention and loyalty.

• Customer conversion rate measures the effectiveness of marketing and sales efforts.

• Churn rate can be calculated by dividing the number of custo...read more
Answered by AI
Add your answer

Quantitavtive logical verbal puzzles reasoning arithmetic

DSA array string loops function and algorithms

Communication leadership teamwork

Fundamental of ai ml and also about nural network

Q1. Over fitting and underfitting ?
Add your answer
Q2. What is P value and what is its significance?
Ans. 
P value is a statistical measure that helps determine the significance of results in hypothesis testing.
• P value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

• A small P value (typically ≤ 0.05) indicates strong evidence against the null hypothesis, leading to its rejection.

• A large P value (> 0.05) suggests weak evidence against the null hypothesis, leadi...read more
Answered by AI
Add your answer
Q3. Explain your projects. Explain about RAG
Add your answer

Write a code to reverse a list. Write a code to add value to a dataframe and edit the value in data frame

Q1. Tell about yourself.
Add your answer
Q2. Explain projects. How much will you rate yourself in technical knowledge
Add your answer

It was a campus placement during my second year of Mtech. So they followed the usual standard format. Aptitude and personality quiz.

Q1. Tell me about yourself favourite subject Python Libraries Projects Data science (NLP)
Add your answer

Q1. The usual tell me about yourself and some casual conversation.
Add your answer

Q1. Asked various ai related basic questions, algorithms and basics of python.
Add your answer

Q1. Basic Computer Vision questions
Add your answer
Q2. What is convolution
Ans. 
Convolution is a mathematical operation that combines two functions to produce a third function.
• Convolution involves sliding one function over another and multiplying the overlapping values at each point.

• It is commonly used in signal processing, image processing, and neural networks.

• In image processing, convolution is used for tasks like blurring, sharpening, edge detection, etc.
Answered by AI
Add your answer

Q1. About tableau advance questions
Add your answer
Q2. Tableau lod related questions
Add your answer

Q1. Flexible to work and timings
Add your answer

Number,ratio,speed&distance,game based questions

Q1. Oops concept and all above in java questions
Add your answer

Q1. Self introduction HR all question
Add your answer