HARMAN Senior Data Analyst Interview Questions and Answers

Detailed case with four questions, required intensive number crunching and data analysis.
Suggestions: Stick to your basic understanding of the problem statement and state all your assumptions clearly.

A real business case was presented in a group of 5-7 people. Each one of us was given a specific role and we were told to discuss the case as a group and come up with a detailed solution.
A brief description of your answers/approach: We discussed the problem in hand from different angles - considering each function in detail. In the end of the discussion, we presented the business model of our idea to the Apple representatives in the form of a presentation.

Q1. Tell me about yourself
Add your answer
Q2. Tell me about a time when you had to deal with a difficult colleague
Add your answer
Q3. Biggest achievement
Add your answer
Q4. Resume based questions
Add your answer
Q5. Next part of the interview was case presentation - the at-home case we submitted before the GD round. We were given 10 minutes to give a detailed PPT on the case, which was followed by 30 minutes of Q&A se...read more
Add your answer

The diagonals AC and BD of a cyclic quadrilateral ABCD intersect each other at the point P. Then, it is always true that

Q1. Nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Programming Machine Learning Aptitude Write & Earn Web Development P...read more
Add your answer
Q2. Everything you need to know about the job-search process itself.nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Prog...read more
Add your answer

Q1. Couple of leetcode medium questions (i think it was around 3 questions) and they had their own platform
Add your answer

Skil set for My relevant job update

Communication discussion

Q1. About My profile and knowledge
Add your answer
Q2. About My attitude and experience
Add your answer

Q1. Excel formula and macro MS word and PowerPoint dashboard advanced Excel and power bi
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. About yourself n work profile
Add your answer

Q1. Write a sql query to retrieve the department names along with total number employees in each department
Ans. 
The SQL query retrieves department names and the total number of employees in each department.
• Use the SELECT statement to retrieve the department names and count of employees.

• Join the employee table with the department table using the department ID.

• Group the results by department name.

• Use the COUNT function to calculate the total number of employees in each department.
Answered by AI
Add your answer
Q2. Write a sql query to find total amount of order placed by each customer
Ans. 
This query calculates the total amount of orders placed by each customer.
• Use the GROUP BY clause to group the orders by customer.

• Use the SUM() function to calculate the total amount of each group.

• Join the orders table with the customers table to get the customer names.
Answered by AI
Add your answer

Q1. Tell me about the project you have worked recently
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecom company
• Used Python and SQL to clean and analyze customer data

• Implemented machine learning algorithms such as logistic regression and random forest

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer
Q2. What kind of forecasting have you done
Ans. 
I have experience in time series forecasting using statistical models and machine learning algorithms.
• Utilized ARIMA model to forecast sales data for a retail company

• Implemented Prophet algorithm to predict stock prices for a financial institution

• Used LSTM neural network for demand forecasting in supply chain management
Answered by AI
Add your answer

Excel assessment- was made to make a report from multiple sheets