Cummins IT Business Analyst Interview Questions and Answers

Q1. Explain your experience.I have worked in Feed back infra as water supply expert.I have designed various capacities water treatment plant.
Add your answer

Q1. Where I worked . About my experience. Details regarding my experience . Question regarding design of water treatment plant
Add your answer
Q2. Nature of work preferred. Salary requirements
Add your answer

Q1. Simple question they asked
Add your answer

Q1. About handling worst situation like I failed to do something on big event
Add your answer
Q2. How I managed reports in system
Ans. 
I managed reports in the system by creating templates, gathering data, analyzing trends, and presenting findings to stakeholders.
• Created report templates to standardize format and content

• Gathered data from various sources such as databases, spreadsheets, and software systems

• Analyzed trends and patterns in the data to identify insights and opportunities

• Presented findings to stakeholders through visualizations, charts, a
Answered by AI
Add your answer

Focus on logical reasoning, quantitative analysis, and verbal reasoning.

Two questions were given that pertained to arrays and strings. It is advisable to practice more with array and string manipulation.

It was an elimination round, and the assigned topic was ChatGPT. We discussed it for 30 minutes.

Q1. Can you introduce yourself, and what do you know about the company?
Ans. 
I am a data analyst with 5 years of experience in analyzing and interpreting complex data sets. I have a strong background in statistical analysis and data visualization.
• I have a Bachelor's degree in Statistics from XYZ University.

• I have experience using tools such as SQL, Python, and Tableau for data analysis.

• I have worked on projects involving predictive modeling, data mining, and trend analysis.

• I am familiar with th...read more
Answered by AI
Add your answer
Q2. Data analysis-related questions were asked during the interview
Add your answer

A dataset was shared for analysis

Q1. Data analyst experience share
Add your answer

Q1. Explain Order of execution in SQL
Ans. 
Order of execution in SQL determines the sequence in which different clauses are processed in a query.
• SQL query is processed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• FROM clause is processed first to retrieve data from tables.

• WHERE clause filters the data based on specified conditions.

• GROUP BY clause groups the data based on specified columns.

• HAVING clause filters the grouped data.

• SELECT ...read more
Answered by AI
Add your answer
Q2. Sumifs function
Add your answer
Q3. Boxplots?Histograms?
Add your answer

Q1. Why you want to change job
Add your answer