EXL Service Assistant Manager Analytics Interview Questions and Answers

DSA and ML, AI, Coding question

Q1. Case study which was easy
Add your answer

Q1. In depth questions on ML
Add your answer

Q1. How is the effectiveness of a campaign analysed ?
Ans. 
The effectiveness of a campaign is analyzed by measuring key performance indicators (KPIs) and conducting A/B testing.
• Identify and track relevant KPIs such as conversion rate, click-through rate, return on investment (ROI), and customer acquisition cost.

• Compare the campaign results to benchmarks and historical data to assess performance.

• Conduct A/B testing to test different variables such as messaging, visuals, and tar...read more
Answered by AI
Add your answer
Q2. How to improve ROI of a marketing channel
Ans. 
To improve ROI of a marketing channel, focus on targeting the right audience, optimizing ad creatives, analyzing data regularly, and testing different strategies.
• Target the right audience based on demographics, interests, and behavior

• Optimize ad creatives for better engagement and conversion rates

• Analyze data regularly to identify trends, patterns, and areas for improvement

• Test different strategies such as A/B testing,
Answered by AI
Add your answer

Given 6 coding qns related to java and html and also ML.

Q1. Explain abt projects and qns related to ML.
Ans. 
Projects in machine learning involve developing algorithms to analyze and interpret data for various applications.
• Developing a recommendation system for an e-commerce website

• Predicting customer churn for a telecommunications company

• Classifying images in a computer vision project

• Anomaly detection in network traffic for cybersecurity

• Natural language processing for sentiment analysis
Answered by AI
Add your answer

Q1. Basic hr qns why straive?
Add your answer

Q1. What is Bank reconciliation?
Ans. 
Bank reconciliation is the process of comparing a company's financial records with the bank's records to ensure they match.
• Bank reconciliation helps identify discrepancies such as missing transactions or errors in recording.

• It involves comparing the ending balance on the bank statement with the ending balance in the company's accounting records.

• Adjustments may need to be made for outstanding checks, deposits in transit...read more
Answered by AI
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer

2hrs - sections include aptitude, machine learning, deep learning and two easy python coding questions

Q1. Resume scrutiny with projects and internships
Add your answer
Q2. How to measure 45 mins duration using two identical wires
Add your answer
Q3. Partition a round cake into eight equal parts within three cuts
Add your answer
Q4. 10 coins puzzle (5 heads up and 5 tails up)
Add your answer

It was MCQ in simple aptitude, python and SQL questions

Q1. Python coding and explaination
Add your answer
Q2. SQL coding and explaination
Add your answer

Q1. Case study based on data understanding
Add your answer

Q1. Behavioural and questions from my resume
Add your answer