Mphasis Senior Data Analyst Interview Questions and Answers

Q1. Regarding powerbi basic and how to connect with different data sources and sql question
Add your answer

Q1. Sql question , python basic question
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Add your answer
Q4. Could you share the technical skills you possess?
Add your answer
Q5. Can you explain what a Pivot Table is?
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Add your answer

Basics of mathematical ability and verbal ability

Q1. Introduction - explain projects
Add your answer
Q2. Data analytics explain
Add your answer

Q1. About your self
Add your answer
Q2. Communication skills
Add your answer

Q1. Programming language
Add your answer
Q2. What tools do you utilize for data analysis?
Ans. 
I utilize tools such as Excel, Python, SQL, and Tableau for data analysis.
• Excel for basic data manipulation and visualization

• Python for advanced data analysis and machine learning

• SQL for querying databases

• Tableau for creating interactive visualizations
Answered by AI
Add your answer
Q3. Pandas numpy seaborn matplot
Add your answer

Data analysis of code in the context of data analysis.

Coding logical question paper.

Q1. DAX Related Syntax and Codes
Add your answer
Q2. Data Modelling, SQL, Python
Add your answer

Q1. No Response from HR after calling of selection after Round 1
Add your answer

There were verbal, non verbal, reasoning , English and maths questions

Q1. Tell me about your project.
Ans. 
I worked on a project analyzing customer behavior using machine learning algorithms.
• Used Python for data preprocessing and analysis

• Implemented machine learning models such as decision trees and logistic regression

• Performed feature engineering to improve model performance
Answered by AI
Add your answer
Q2. What programming knowledge you have ?
Ans. 
Proficient in Python, R, and SQL with experience in data manipulation, visualization, and machine learning algorithms.
• Proficient in Python for data analysis and machine learning tasks

• Experience with R for statistical analysis and visualization

• Knowledge of SQL for querying databases and extracting data

• Familiarity with libraries such as Pandas, NumPy, Matplotlib, and Scikit-learn
Answered by AI
Add your answer

Q1. Where do you stay ?
Ans. 
I currently stay in an apartment in downtown area.
• I stay in an apartment in downtown area

• My current residence is in a city

• I live close to my workplace
Answered by AI
Add your answer
Q2. Tell me about you
Ans. 
I am a data science enthusiast with a strong background in statistics and machine learning.
• Background in statistics and machine learning

• Passionate about data science

• Experience with data analysis tools like Python and R
Answered by AI
Add your answer

Q1. I'm changing my domain because I don't see much scope for growth in my current domain and I want to make advantage of new opportunities for learning, creativity and success. Additional, I believe that the ...read more
Add your answer
Q2. I understand that being asked to work for an extended number of hours comes with a good reason in the first place, so I'm ok with it.
Add your answer
Q3. Over the year I have really upskilled my self. I believe based on the market standards for this particular role and my experience and skill set a salary range between 10000- 35000 would be fair and appreci...read more
Add your answer
Q4. Can you share more about the day to day responsibilities of this role?
Add your answer
Q5. If I am hired for this role, what would you want me to a achieve in my first two months?
Add your answer
Q6. No ma'am certainly not. Before coming here, I read the job description thoroughly and I have the right skills and qualification required for the role.
Add your answer
Q7. I believe a change in work environment with stimulate my creativity and drive for success.
Add your answer