Subex Senior Data Analyst Interview Questions and Answers

6 mcqs and 2 sql questions

Q1. Difference between having and where in sql
Add your answer
Q2. Sql joins and it types
Add your answer
Q3. Window functions and subqueries
Add your answer
Q4. Sql scenario question based on joins
Add your answer
Q5. Kpi's and metrics
Add your answer

Q1. Business problem related to case study
Add your answer

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
Add your answer
Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
Ans. 
The query selects all columns and calculates the total amount for each customer in table t2.
• The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

• The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

• The 'select *' statement selects all columns from the table along with the calculated total amount.

• The 'sum(amt) over (partiti...read more
Answered by AI
Add your answer
Q3. How many Customers has purchased same item on the Same day more than onnce
Ans. 
To find customers who purchased the same item multiple times on the same day.
• Identify unique customers who purchased the same item multiple times on the same day

• Check for duplicate transactions by customer and item on the same day

• Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Answered by AI
Add your answer

In a group discussion, one or more members engage in conversation about specific topics, sharing their knowledge and gaining insights from each other.

Q1. Ask short introduction about employees
Add your answer
Q2. Ask questions about our discussed topic in group discussion and questions about relavant job title
Add your answer
Q3. Ask some technical questions
Add your answer
Q4. And ask some coding syntax
Add your answer
Q5. Ask about job title
Add your answer

Easy question for aptitude test

Q1. Ask self introduction?
Add your answer
Q2. Ask relevant topic about job title
Add your answer
Q3. Ask about ai skills?
Add your answer
Q4. Ask about the experience intership group discussion?
Add your answer
Q5. What did you learn about ai in college
Ans. 
I learned about AI's applications, algorithms, and ethical considerations during my college studies, enhancing my analytical skills.
• Studied machine learning algorithms like decision trees and neural networks, which are essential for predictive analytics.

• Explored natural language processing (NLP) techniques, such as sentiment analysis, to understand customer feedback.

• Analyzed case studies on AI in healthcare, demonstrat...read more
Answered by AI
Add your answer

Q1. What is your salary expectation
Ans. 
My salary expectation is based on my experience, skills, and the market rate for Data Analyst positions.
• Consider my years of experience in data analysis

• Research the average salary for Data Analysts in this location

• Factor in any additional skills or certifications I bring to the table
Answered by AI
Add your answer
Q2. What skills you have
Ans. 
I have strong analytical skills, proficiency in data analysis tools, and excellent communication skills.
• Strong analytical skills

• Proficiency in data analysis tools (e.g. Excel, SQL, Python)

• Excellent communication skills (both written and verbal)
Answered by AI
Add your answer
Q3. About previous company
Add your answer